View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Rogers[_2_] Mike Rogers[_2_] is offline
external usenet poster
 
Posts: 284
Default Formula or code for address list into mailing format?

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!