Mail Merge return address gifts. 500 addresses printed 30 times on 500 sheets
-
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!
-
Answer:
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
scottkruse-ga at Google Answers Visit the source
Related Q & A:
- Is there any way to forward a folder from my Yahoo mail to another address?Best solution by Yahoo! Answers
- Is there any way to set my account to forward all incoming mail to another address?Best solution by Quora
- How can I correct sent emails from showing a wrong return address?Best solution by Yahoo! Answers
- Do you have to have a return address when you ship a package?Best solution by Yahoo! Answers
- How do I get my mail from an old yahoo mail address to my new yahoo mail address?Best solution by webapps.stackexchange.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.