how can i create labels for many different addresses?

B

Big Chris

Trying to set up a bunch of labels that show many different addresses, not
just a whole page with my name and address on, figured it'd be quite useful
around Christmas!
I can't see how you could arrange 20 or so on a page with different
addresses, anyone got any ideas?
 
E

Ed.

You use access first to make a database of your addresses.
The use Word. I use Word 2003 so this is for that.
Start a blank document.
Go up to Tools.
Go to Letters and Mailings.
Select Mail Merge.
Follow the wizard.
Select Labels.
Next Select Label Options.
Select your Label size under Options.
Next select recipients.
When it comes to select recipients, click on Browse and go to your database
you created for the addresses.
Next arrange your recipients.
Click on More Items.
Insert the fields you want from your database.
You can like select first name, last name, address, city, state, zip code if
you named your fields that.
After they are inserted, you can put a space between the names, a coma after
city and a couple spaces between state and zip code if you want.
When you that is done, click on Update All Labels Button.
Now click Preview your Labels.
If they look good like you want them, click on Complete the Merge.
Then print or edit.

I only know cause I had to figure it out yesterday and this is how I found
how to do it and it worked great.

Good Luck,
Ed.

Start a blank document.
 
B

Beth Melton

Hi Chris,

If you are using Word then in the Envelopes and Labels dialog box
leave the Address text box blank and click "New Document". The result
is a blank page of labels to type on.
--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
M

Milly Staples [MVP - Outlook]

If you use Outlook to store your contacts, you can use a mail merge and
select labels as the output. Look in F1 help or ask the Office Assistant.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.

After searching google.groups.com and finding no answer, Big Chris asked:

| Trying to set up a bunch of labels that show many different
| addresses, not just a whole page with my name and address on, figured
| it'd be quite useful around Christmas!
| I can't see how you could arrange 20 or so on a page with different
| addresses, anyone got any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top