[Graham Mayor]

See http://www.gmayor.com/mail_merge_lab...th_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm and insert the fields
you require in the layout you want.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Studebaker wrote:
Hello,

I have a row in Excel where each cell has a first name, last name,
address, city, state and zip code. I don't need to copy all of the
cells in this row; just the cells I listed above.
I want to be able to copy those cells, paste it in Word and format it
so it looks like an address block at the beginning of a letter, ex:

John Smith
123 Apple St.
St. Louis, MO 98765

These different address blocks will be added to letters that already
exist.
I just have to add the address blocks to them.
I tried pasting the cells from Excel to Word, converting table to
text, then replacing the tab markers to paragraph markers but the
paragraph marks didn't shift my address underneath my names or my
city/state/zips under my addresses.

Please help. I have hundreds of letters to do and don't relish having
to manually add the address info in Excel to these different letters
in Word.

Thank you!!
Studebaker