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" <(E-Mail Removed)> wrote in message news:F4842749-FE2B-4311-9AB7-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:F4842749-FE2B-4311-9AB7-(E-Mail Removed)...
> 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
>