mailing labels from Excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wayfarer - 31 Mar 2004 18:15 GMT

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!

Signature

Marta
(if you email me directly you need to remove the X )

Reply to this Message

David McRitchie - 31 Mar 2004 18:37 GMT

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

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> 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. -- Marta

Reply to this Message

Gord Dibben - 01 Apr 2004 00:21 GMT

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

>Hi Marta,
>See my page
[quoted text clipped - 11 lines]
>> I am trying to take about 400 names and address from the spreadsheet and
>> create mailing labels for a newsletter. -- Marta

Reply to this Message

Wayfarer - 02 Apr 2004 17:35 GMT

Thanks!

Signature

Marta
(if you email me directly you need to remove the X )

> In addition to David's page...
>
[quoted text clipped - 19 lines]
> >> I am trying to take about 400 names and address from the spreadsheet and
> >> create mailing labels for a newsletter. -- Marta

Reply to this Message

merkaufman - 31 Mar 2004 21:51 GMT

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

--
Mart
(if you email me directly you need to remove the X

Reply to this Message

David McRitchie - 01 Apr 2004 00:44 GMT

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.

> 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.

Reply to this Message

Wayfarer - 02 Apr 2004 17:44 GMT

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

Signature

Marta
(if you email me directly you need to remove the X )

> And what happens at 28 names, the most common mistake is
> not having your "database" as the first worksheet (leftmost tab).
[quoted text clipped - 4 lines]
> > merge to make labels for about 28 names (1 page of the labels), but
> > not for the entire database in the excel spreadsheet.

Reply to this Message