Formula or code for address list into mailing format?

[alinne5]

I have hundreds of addresses for wedding invites in a list. The columns are
broken into:
Name, street address, city, state, zip.

With each row being a new record.

I know very little about macro's except for the concept. I think if I knew
the symbol for "return" to put the address under the name I could figure it.
And how to send the info from one worksheet into another worksheet that I
have formatted for printing in mailing form.

Thank you!

 

[Mike Rogers]

alinne5

This is a job for mail merge using word.

For help on Word mail merge using Excel as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm


Mike Rogers

 

[alinne5]

Greatly appreciated Mike!

alinne5

This is a job for mail merge using word.

For help on Word mail merge using Excel as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.htm


Mike Rogers