Mail Merge Mystery

[Fitzwilliam Darcy]

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!

 

[Suzanne S. Barnhill]

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

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.