#314 Mail Merge

A pretty fair number of times over the years I’ve been asked several different variations on the topic of how to do a Mail Merge in Microsoft Word. I also recently realized that I’ve never shared that information as one of my weekly tips. Knowing how to do this can save you a ton of time and has a pretty wide variety of uses.

Uses of mail merge:

  • Mailing labels
  • Form Letters
  • Envelopes
  • Personalized letters
  • Course Completion certificates
  • Name tags
  • Many more…

HOW IT WORKS:

  1. Set up the ‘Main Document’:
    The main document contains the text and graphics that are the same for each version of the merged document — for example, the return address in a form letter and is where you indicate what type of document you want. (i.e. mailing labels, envelopes, a letter, etc).
  2. Connect to a source of data
    A data source is a file that contains the information to be merged into a document. For example, the names and addresses of the recipients of a letter. You can use existing data or create a new one.Source-Data
  3. Add, arrange & format ‘place holders’ (mail merge fields)
    When you do the merge, these fields are filled with information from your data file. Depending on what type of document you are merging, this will be things like Name, Address, City, Course Name, etc.Main-Document
  4. Preview the results and complete the merge. 
    You can merge directly to a printer or into a new file so that you can save a copy of your results.Merged-Results

GET THE DETAILS FOR  YOUR VERSION OF OFFICE:

Have you ever attempted to do a mail merge like this? How did it work? Do you have any questions? Let me know!

Advertisements

One thought on “#314 Mail Merge

  1. What’s Going down i am new to this, I stumbled upon this I’ve found It positively helpful and it has aided me out loads.
    I’m hoping to give a contribution & help other customers like its helped me. Great job.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s