Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
1. Use Find and Replace to replace ^p (a paragraph mark) with ^l (that's a
lowercase L, a line break). 2. Replace ^l^l (two line breaks) with ^p (a paragraph break). This puts each address in its own paragraph. 3. Replace ^l with ^t (a tab character). 4. Table | Convert | Text to Table, choosing "Tabs" for "Separate text at." 5. The result will be a table you can use as a mail merge data source. It will work best if you add a row at the top with column headings, which will become your merge fields. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Fitzwilliam Darcy" wrote in message oups.com... I would like to know how to edit addresses already in a word document so that they can be read by the mail merge feature. After using OCR software to get addresses into word, I am going to clean them up to make a document that can be used to mail merge. So far, I have the document formatted like this: Name(enter) Address(enter) City, State, Zip(enter) (enter) Name(enter) Address(enter) City, State, Zip(enter) (enter) And so on; but that an enter after each field and an enter (or two) between records does not seem to work. Any suggestions? Thank you! |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mail Merge Word 2003 Issue | Mailmerge | |||
Mail Merge - Parameter prompts twice... | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Word-Excel 2003 - Mail Merge Recipients problem | Mailmerge |