Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word should catalog misspelled words to study. rndthought Microsoft Word Help 39 May 21st 23 02:47 AM
take yet another lesson from wordperfect "reveal codes" wordperfect is superior Microsoft Word Help 5 May 11th 09 07:58 PM
Word applies direct format on File open Uriel Microsoft Word Help 16 November 27th 05 07:22 PM
How do I set right and left alignment on the same line in Word? Matador Page Layout 1 November 9th 05 08:32 PM
formatting links from excel into word (extra line feeds) JGT Microsoft Word Help 1 December 9th 04 11:01 AM


All times are GMT +1. The time now is 03:53 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"