Changing name/address in Excel row to Word address block format

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

Hi Studebaker,

Perhaps a mailmerge is what you're after. The Word mailmerge process allows you to choose which fields (columns) from you Excel
workbook to insert into your document, and where. When you execute the merge, all the letters will be produced for you.

--
Cheers
macropod
[Microsoft MVP - Word]


"Studebaker" wrote in message ...
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

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

I appreciate both of your replies. I don't know if mail merge will
necessarily work be efficient in this instance b/c I'll have to set up fields
for each of my letters already made.
I will keep in mind your first link, though.

Thank you.

Studebaker

"Graham Mayor" wrote:

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

I agree with macropod and Graham that a mail merge is what is needed, at
least if you are producing multiple letters at one time. See
http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm and
http://word.mvps.org/FAQs/MailMerge/...ataSource.htm; from the latter
you will see that what you have in Excel is already a perfectly satisfactory
data source. You can insert merge fields in the desired order, separating
lines with line breaks, then complete the merge. The letter you have already
written can easily be used as the mail merge main document.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"Studebaker" wrote in message
...
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