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!

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/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Mike Rogers


"alinne5" wrote:

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!

Greatly appreciated Mike!

"Mike Rogers" wrote:

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/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Mike Rogers


"alinne5" wrote:

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!