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?

answerguru-ga

---

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

Correct?

---

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. http://www.elitedesignweb.com/SS9.html 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.

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

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
delete them EXCEPT FOR THE LAST LABEL.
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!

Cheers,
answerguru-ga