mailing labels from Excel?

[Wayfarer]

Is there a way to export or create mailing labels from an Excel spreadsheet?

I am trying to take about 400 names and address from the spreadsheet and
create mailing labels for a newsletter.

Thanks!

 

[David McRitchie]

Hi Marta,
See my page
Mail Merge, Printing Labels using Mail Merge with data from Excel
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

 

[Guest]

If you get an answer to this, please send it to me. I can get the mail merge to make labels for about 28 names (1 page of the labels), but not for the entire database in the excel spreadsheet.

----- Wayfarer wrote: ----

Is there a way to export or create mailing labels from an Excel spreadsheet

I am trying to take about 400 names and address from the spreadsheet an
create mailing labels for a newsletter

Thanks

 

[Gord Dibben]

In addition to David's page...

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

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

Gord Dibben Excel MVP

 

[David McRitchie]

And what happens at 28 names, the most common mistake is
not having your "database" as the first worksheet (leftmost tab).
Of course the most common failure is probably just trying to
print directly from a spreadsheet to the printer.

 

[Wayfarer]

Thanks!

 

[Wayfarer]

Thanks! I am going to import into an Access database.