Google Answers Logo
View Question
Q: Mail Merge return address gifts. 500 addresses printed 30 times on 500 sheets ( Answered,   0 Comments )
Subject: Mail Merge return address gifts. 500 addresses printed 30 times on 500 sheets
Category: Computers
Asked by: scottkruse-ga
List Price: $15.00
Posted: 28 Nov 2005 10:18 PST
Expires: 28 Dec 2005 10:18 PST
Question ID: 598576
I have a small non-profit and I would like to give my donors a gift
this Christmas of self addressed return labels.

I want to mail merge my list so I get 500 sheets of labels with one
address printed 30 times on each. (different address on each sheet)
They can then use the labels to send cards and such. I would also like
to sort the list by zip code. Thought I am sure once I get the
formatting right I should have no trouble sorting them.

I would pay 15 bucks for a template or step by step directions
preferably in Microsoft Publisher.

Thank you!

Request for Question Clarification by answerguru-ga on 28 Nov 2005 11:10 PST
Would step-by-step directions in Word suffice as an answer?


Clarification of Question by scottkruse-ga on 28 Nov 2005 11:23 PST
as as long as I could include a graphic. Also I should note that I am
merging from outlook.

Request for Question Clarification by answerguru-ga on 28 Nov 2005 13:21 PST
Just to make sure, your template contains one page with 30 sections,
with each section having a graphic along with the person's contact


Clarification of Question by scottkruse-ga on 28 Nov 2005 16:02 PST
Yes, I am going to use A Christmas Picture. So it looks something like
this on at this address. Each
person would have 30 lables with their address on it. I am using Avery
5164. 500 pages with 30 identical lables per sheet. 500 people get 30
lables with their own address on it.
Subject: Re: Mail Merge return address gifts. 500 addresses printed 30 times on 500 sheets
Answered By: answerguru-ga on 28 Nov 2005 18:30 PST
Hi scottkruse-ga,

Here are the step by step instructions for creating a mail merge in
Word using Outlook as your data source so that you can repeat each
contact's information 30 times on a page for each of your 500

1. Open a new document in Word and select Tools > Letters and Mailings > Mail Merge
2. Select 'Labels' and the click the 'Next' link
3. Click on 'Label Options' and then select your Avery label 5164 from
the Label Options dialog, then click OK.
4. Click the 'Next' link to select recipients
5. Choose 'Select from Outlook Contacts', click 'Choose Contacts
folder' to select a folder, then click OK.
6. You can specify exactly which contacts should be included via the
'Edit Recipient List' option
7. Click Next to arrange your labels
8. Put your cursor in the first label, and insert your picture using
Insert > Picture menu item (either from file or clipart)
9. Click on 'More Items' and insert the fields you want to include
10. Arrange the layout of the first label as you desire, then click on
the Update All Labels option to apply that layout to the other labels.

If you leave it here, you will get one record per label - we need to
take it further.

11. Select each of the <<Next Record>> fields in the document and
12. For the last label, move the <<Next Record>> field (by cutting and
pasting)to the end of the label's contents.

What will happen here is that the merge will not be told to move to
the next record until it has repeatedly printed out the desired merge
information in each label. Once the entire sheet has been populated,
we are directing it to move to the next record so that the next sheet
will have a new contact's information listed.
13. Click 'Next' to Preview your labels
14. Click 'Next' to complete the merge to the printer
15. Select all records, then proceed to printing.
16. Save Mail Merge document for later if desired

You should now have a printed result as desired.

If any of the steps above are unclear, please post a clarification and
I will respond promptly.

Thanks for using Google Answers!

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy