How to Address Wedding Invitations with Mail Merge?
October 31, 2009
If I have entered your guest information into Access Database or Excel, how do I do a mail merge to print addresses onto invitations.
UPDATE!!!!!!!!!
This is for Word 2003, it should be pretty similar if you’re using 2007.
1. Click Tools, then go down to Letters and Mailings, then click Mail Merge.
2. Click the type of document you are working on (letters, envelopes) on box that appears on the right side and click Next: Starting document at the bottom
3. Click what document you are going to use (the current one, one you already made, or a template) and click next at the bottom.
4. Select the "Use from an existing list" button and click browse in the area below it. Find the file that you have the information stored and say open.
5. Choose the recipients by putting checks next to them. Click OK. Click next on the bottom left.
6. Write the letter if you are using a regular document.
7. Once you’re done with that, click more items on the right side. Click the database fields button, and fields from the file that you created to put your guest information in should appear.
8. Double click each one as you would want it to appear like it was a persons name. For example:
<<FirstName>><<LastName>> would show JohnDoe without any spaces.
<<FirstName>> <<LastName>> would show John Doe with a space.
Be careful when you’re doing address stuff. Click next.
9. You’ll be able to preview it so you can see how it looks. Click the arrows at the top of the left to see everyones name. Once you’re ready, click next to complete the merge.
10. You can either print the merge, or edit them individually.
One Response to “How to Address Wedding Invitations with Mail Merge?”
UPDATE!!!!!!!!!
This is for Word 2003, it should be pretty similar if you’re using 2007.
1. Click Tools, then go down to Letters and Mailings, then click Mail Merge.
2. Click the type of document you are working on (letters, envelopes) on box that appears on the right side and click Next: Starting document at the bottom
3. Click what document you are going to use (the current one, one you already made, or a template) and click next at the bottom.
4. Select the "Use from an existing list" button and click browse in the area below it. Find the file that you have the information stored and say open.
5. Choose the recipients by putting checks next to them. Click OK. Click next on the bottom left.
6. Write the letter if you are using a regular document.
7. Once you’re done with that, click more items on the right side. Click the database fields button, and fields from the file that you created to put your guest information in should appear.
8. Double click each one as you would want it to appear like it was a persons name. For example:
<<FirstName>><<LastName>> would show JohnDoe without any spaces.
<<FirstName>> <<LastName>> would show John Doe with a space.
Be careful when you’re doing address stuff. Click next.
9. You’ll be able to preview it so you can see how it looks. Click the arrows at the top of the left to see everyones name. Once you’re ready, click next to complete the merge.
10. You can either print the merge, or edit them individually.
References :
By rascalflattsrule on Oct 31, 2009