A bunch of labels from a mailing list

Monsuco · External Since: Aug 09, 2007 Posts: 2

I need to build a lot of labels. I have an Excel file with a list of all the
businesses in the town I live in and I need to print out a label (or print to
a bunch of envelopes). How can I import data from this Excel files so that it
can make these thousands of labels. I Have one column for Name, one for
Address, one for City, one for state, one for zip. How do I do this?

Monsuco · External Since: Aug 09, 2007 Posts: 2

I have gotten it to import successfully sorta. When I use the mail/merge
wizard, it simply makes a page full of labels with the first company in the
list. How do I make it to make thousands of labels, one for each company,
without all the duplicates?

"Monsuco" wrote:

> I need to build a lot of labels. I have an Excel file with a list of all the
> businesses in the town I live in and I need to print out a label (or print to
> a bunch of envelopes). How can I import data from this Excel files so that it
> can make these thousands of labels. I Have one column for Name, one for
> Address, one for City, one for state, one for zip. How do I do this?

Mary Sauer · External Since: Mar 25, 2006 Posts: 3845

You can only have one label on your screen for a merge to be successful.

If you are looking at print preview it will show all the data being same on
every label. This is a Publisher bug.

If you are unsure, there is a test print in the print dialogue.

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"Monsuco" <Monsuco DeleteThis @discussions.microsoft.com> wrote in message
news:F584BBD5-1454-46F7-84BE-B492E69E63E2@microsoft.com...
>I have gotten it to import successfully sorta. When I use the mail/merge
> wizard, it simply makes a page full of labels with the first company in the
> list. How do I make it to make thousands of labels, one for each company,
> without all the duplicates?
>
> "Monsuco" wrote:
>
>> I need to build a lot of labels. I have an Excel file with a list of all the
>> businesses in the town I live in and I need to print out a label (or print to
>> a bunch of envelopes). How can I import data from this Excel files so that it
>> can make these thousands of labels. I Have one column for Name, one for
>> Address, one for City, one for state, one for zip. How do I do this?

dave · External Since: Aug 09, 2007 Posts: 3

Why don't you just use Microsoft Word to generate your mailing
labels? Here are some instructions on doing a mail merge using Excel
and Microsoft Word. Word makes generating mailing labels really easy!

http://www.onlinelabels.com/mail_merged_labels.htm

Dave Carmany
OnlineLabels.com
http://www.onlinelabels.com

On Aug 9, 2:36 pm, "Mary Sauer" <mary-sa....RemoveThis@mycolumbus.rr.com> wrote:
> You can only have one label on your screen for a merge to be successful.
>
> If you are looking at print preview it will show all the data being same on
> every label. This is a Publisher bug.
>
> If you are unsure, there is a test print in the print dialogue.
>
> --
> Mary Sauer MSFT MVPhttp://office.microsoft.com/http://msauer.mvps.org/
> news://msnews.microsoft.com
>
> "Monsuco" <Mons....RemoveThis@discussions.microsoft.com> wrote in message
>
> news:F584BBD5-1454-46F7-84BE-B492E69E63E2@microsoft.com...
>
>
>
> >I have gotten it to import successfully sorta. When I use the mail/merge
> > wizard, it simply makes a page full oflabelswith the first company in the
> > list. How do I make it to make thousands oflabels, one for each company,
> > without all the duplicates?
>
> > "Monsuco" wrote:
>
> >> I need to build a lot oflabels. I have an Excel file with a list of all the
> >> businesses in the town I live in and I need to print out a label (or print to
> >> a bunch of envelopes). How can I import data from this Excel files so that it
> >> can make these thousands oflabels. I Have one column for Name, one for
> >> Address, one for City, one for state, one for zip. How do I do this?- Hide quoted text -
>
> - Show quoted text -