View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
funky Hamsta
 
Posts: n/a
Default Formatting data in word label merging, commas into line breaks

When making labels for posting letters, I have a data field in my excel table
which has the address data in the following format:

" Mr A B Bloggs, 12 Nowhere Raod, Somewhere, Shireshire, SN12 4UP. "

How can I point word mail merge at this data field and get it to insert a
line break where it sees a comma? so that there format becomes:

Mr A B Bloggs
12 Nowhere Road
Somewhere
Shireshire
SN12 4UP

Any suggestions/solutions greatly appreciated.