PDA

View Full Version : Gopher Training Class, Using Mail Merge


Team Gopher
11-19-2004, 12:01 PM
http://www.gophergraphics.com/forum/iB_html/uploads/post-2-99255-mail_merge_class.gif

Welcome everyone to the Gopher training class. Our topic is using Gopher along with the mail merge feature in Microsoft Word. Although this shows how to use Gopher with mail merge, you could easily use this knowledge with other programs as well. You can review other previous Gopher Classes here. (http://www.gophergraphics.com/forum/cgi-bin/ikonboard.cgi?act=ST;f=2;t=1040)

You can use Mail Merge to create customized letters, flyers or create envelopes. Please note that your Gopher invoices are designed to be used with cleared windowed envelopes, so this procedure would not be needed for invoices.

In this example we will create envelopes to send out flyers or newsletters.

All are welcomed to ask questions or post answers. Please share with us how you use mail merge.

Step 1. At the top left of your screen in Gopher, click on File then Export Customer List.
http://www.gophergraphics.com/forum/iB_html/uploads/post-2-99551-step_1.gif

Step 2. Choose where you want to save your customer list exported txt file. Save it somewhere you can easily find it.
http://www.gophergraphics.com/forum/iB_html/uploads/post-2-99617-step_2.gif

Step 3. In Microsoft Word, click File at the top left of the screen then New.
http://www.gophergraphics.com/forum/iB_html/uploads/post-2-99670-step_3.gif

Step 4. Choose Envelope Wizard.
http://www.gophergraphics.com/forum/iB_html/uploads/post-2-99716-step_4.gif

Step 5. Choose create envelopes for a mailing list.
http://www.gophergraphics.com/forum/iB_html/uploads/post-2-99763-step_5.gif

Step 6. Choose Get Data.
http://www.gophergraphics.com/forum/iB_html/uploads/post-2-99824-step_6.gif

Step 7. Choose open data source.
http://www.gophergraphics.com/forum/iB_html/uploads/post-2-99855-step_7.gif

Step 8. Choose to open the txt file you had created from Gopher.
http://www.gophergraphics.com/forum/iB_html/uploads/post-2-99910-step_8.gif

Step 9. Click on Set Up Main Document.
http://www.gophergraphics.com/forum/iB_html/uploads/post-2-99951-step_9.gif

Step 10. Choose appropriate settings and click ok. For our example, we didn't need to change any settings.
http://www.gophergraphics.com/forum/iB_html/uploads/post-2-00008-step_10.gif

Step 11. Click on the button Insert Merge Field.
http://www.gophergraphics.com/forum/iB_html/uploads/post-2-00131-step_11.gif

Step 12. Add the fields you want displayed in your address. The first will be Display Name.
http://www.gophergraphics.com/forum/iB_html/uploads/post-2-00190-step_12.gif

Step 13. You will then see the display name tag appear.
http://www.gophergraphics.com/forum/iB_html/uploads/post-2-00240-step_13.gif

Step 14. Continue to add fields, use the enter key to create a new line for Street 1. Use the comma key to insert a comma after the city tag. When you are completed, your's should look like this example.
http://www.gophergraphics.com/forum/iB_html/uploads/post-2-00329-step_14.gif

Step 15. When you are completed, your envelope will look like this.
http://www.gophergraphics.com/forum/iB_html/uploads/post-2-00399-step_15.gif

Step 16. Click on the View Merged Data button to see your envelopes with actual data.
http://www.gophergraphics.com/forum/iB_html/uploads/post-2-00487-step_16.gif

Step 17. You will see your data appear.
http://www.gophergraphics.com/forum/iB_html/uploads/post-2-00536-step_17.gif

Step 18. You can use the arrow buttons to view the data before and after the current record shown.
http://www.gophergraphics.com/forum/iB_html/uploads/post-2-00599-step_18.gif

Step 19. When you are satisfied with your results, print your envelopes.
http://www.gophergraphics.com/forum/iB_html/uploads/post-2-00680-step_19.gif