Use the Mail Merge toolbar to access the advanced mail merge options. The Mail Merge toolbar looks like this and have the following buttons on it: Main Document SetupUse this button to select or change the mail merge document type. Open Data Source & Mail Merge Recipients – Use Mail Merge Recipients dialog to filter your data. Click the Email Merge Wizard button on the Ribbon. Follow the easy steps in the Wizard to create your email and to choose your Excel file from the previous step as you list source/ When you come to the following screen, select the main recipient’s details from the drop-down fields and then click Select fields Attachments/CC/BCC.
As you may know, the famous Mail Merge Outlook function that Microsoft introduced more than a decade ago has endured almost every iteration of the Microsoft Office family. Today, we are going to describe its use in Microsoft Office 2007.
Mail Merge in Outlook 2007 works the same as in other Microsoft Office family releases and targets the same goal: the creation of convenient and efficient mass mailings with some degree of personalization while drastically improving the work process for the people in the field. It allows creation of bulk email letters to each individual on a mailing list, using a single message / Word document, by employing “Macros”, which serve as placeholders for data taken from an external “data-source” and are replaced by the actual values when the messages are generated.
The resulting letter will contain only the recipient-related information, complete with his/her unique First and Last names, business addresses, job positions, specific date and/or time, and other information. The letters will also contain a recipient’s name and/or email address as the only one visible in the “TO:” field, protecting the privacy and anonymity of the rest of the recipients from each other and serving as a regardful and professional touch, which most people certainly appreciate.
In our previous articles on Mail Merge in Outlook, we mentioned that the feature offers multiple ways of achieving your mass mailing tasks, and Mail Merge in Outlook 2007 is not an exception. Mail Merge allows a user to create a mass personalized mailing using the standard Office 2007 interface; therefore, it is present in most task-specific Office applications: Word and Outlook.
To conduct a mass-mailing activity in Outlook, Mail Merge is accessed via the following routine:
1) While in Outlook, navigate to the “Contacts” tab and select any contacts you wish to include in your recipients list (it is recommended to switch the default “Current View” of the Contacts tab to the category mode by using the “View -> Current View -> By Category” menu; this allows selection of the contacts in a more convenient fashion.
2) Next, navigate to the “Tools -> Mail Merge…” menu to evoke the Outlook Mail Merge dialog window:
3) Since for this example we are using selected contacts only – you must specify the type of contact selection by choosing the “Only selected contacts” option rather than “All contacts in current view”.
4) Next, set the document type and merge type options to “Form letters” and “E-mail” respectively to conform with the default mail merge structure.
5) Type your subject text in the “Message subject line”.
6) Finally, press “Ok” and continue writing your text in the Word document, which is used as an external editor for the Outlook Mail Merge.
Once in Word, it would not be a bad idea to start with the greeting line for your Mail Merge Outlook mailing: navigate to the “Mailings” ribbon tab, and click “Greeting Line”. Note that you can freely modify the greeting text to suit your task.
Following the greeting line is the message itself – take your time and compose after the greeting line. You can also use macros with any field from the Contact information in your Address book with your Outlook Mail Merge mailing by clicking the “Insert Merge Field” button, located on the “Mailings” tab within the Word ribbon.
After all macros are inserted and your message is composed, you can preview the results prior to sending the actual letters by clicking the “Preview results” button located to the right of the “Write & Insert Fields” ribbon block that you previously used. Note that you can switch between the draft messages of every intended recipient by clicking the little arrow buttons beside the main one.
Now, you can send your electronic mailing! Locate the rightmost button on the “Mailings” ribbon tab named “Finish & Send”, click it once, and choose “Send E-mail Messages…”.
After that, you will see the “Merge to Email” window, which will allow you to modify your subject line. It is recommended to keep the default values for the mailing when using Mail Merge in Outlook for the first time.
Clicking “Ok” will transform your document into simple e-mail messages and send them using the standard Outlook message sending procedure – you can even track these letters in the “Outbox” and “Sent Items” folders.
Now you know how to perform a Mail Merge in Outlook 2007 using Word as an external document editor. Let’s see how to perform a Mail Merge using Word alone.
1) While in Word, locate the “Start Mail Merge” button on the “Mailings” ribbon tab, click it and select “Step by Step Mail Merge Wizard…”.
2) In the first step of the wizard, choose “E-mail messages”.
3) The second step is unnecessary if you wish to produce your text from the ground up, but you can choose to use an external document by selecting the given option.
How To Do Mail Merge In Outlook From Excel
4) In the third step, you can choose either to use Outlook Contacts folder as your contacts source, or to use an external data-source. An external source is more flexible than Outlook Contacts, because you can create your own fields with any kind of custom information about your recipients for mailings using Mail Merge in Outlook 2007.
Mail Merge In Outlook 2016
If you choose to use Outlook Contacts as your data-source, you will be able to sort (include or exclude) any recipients for this Outlook Mail Merge mailing in this step.
5) Step Four will allow you to include the Greeting Line you are now familiar with, as well as some other special fields – we will skip them this time to concentrate on the essential procedures.
6) Step Five will enable you to sort the list of your recipients once more before the final step.
7) Step 6 – here you can pull up the familiar Word “Merge To Email” window and proceed with generating your messages for Outlook and sending them to recipients.
When the Mail Merge Outlook 2007 feature came out, it was a worthwhile usability upgrade from its previous incarnation – Mail Merge in Outlook 2003, but it still was missing some things that were desired by professionals involved with the Office productivity tasks and mailings. Even the most recent Office family additions still lack much-needed features. That is why we at MAPILab have programmed them into our own Mail Merge Toolkit. This add-in “upgrades” Outlook Mail Merge with the addition of such features as the ability to include a custom subject line, custom attachments, the option to send a document as a PDF attachment (as well as avoiding an empty message body with the addition of Message Body Templates), and many others features.
Have you ever wished that you could do an email Mail Merge with PDF attachments as the merged results? There are a variety of reasons you may want to do this. Maybe you would like to send individual PDF letters to students via email attachment, or perhaps you want to have a partially completed PDF form that is personalized for each person you are emailing. The possibilities are endless! By the way, big thanks to Julie and Meghan for having an awesome question in last week’s Word session that has inspired this Byte!
Background
- Today I am going to be referencing an Add In that comes with the installationof Acrobat DC on a computer. Torequest Acrobat DC, or other Adobe CreativeCloud programs, contact the Help Desk at 4357.
- Also, for these exercises, I am assuming you have some experience with Mail Merge in Word. If you have never merged before, or are not comfortable with the process, please come attend my Microsoft Word Essentials training! You will be comfortable with it in no time.
Exercise Files
Here are a couple files for experimentation, if you would liketo follow along:
- Sample Letter Word Document: this is your file that you would like to turn into a merged PDF for recipients. This is a fictional letter for potential students.
- Mail Merge Database Excel File: this is a fictional database for linking to the merge document.
- Important: you should save these both to your desktop before starting, since you will have to browse to find the Excel file when merging.
Creating the Merge
You will start this merge like any other email merge:
1. Open the Sample Letter Word file.
2. Go to Mailings tab and select Start Mail Merge
3. Select Letters
4. Select Recipients and browse for the Excel file
5. Insert Merge Fields as desired. I am going to insert:
- Address block
- Greeting line, and
- Interest field
Work Offline
In real life, this is an optional step when doing an emailmerge, but I will ask you to do it this time, since we are working with fakeemail accounts, and you probably don’t want to receive a bunch of bounce backemails. When you work Offline in Outlook, it allows you the opportunity toreview your email merge before going back online and sending them.
Mail Merge In Outlook 2007
- In Outlook, go to the send/receive tab and select Work Offline.
Finish and Merge
1. Instead of going to Finish and Merge, like we usually do, we are going to select Merge to Adobe PDF.
2. In the popup screen:
- Specify a name for your PDF
- Check the box next to Automatically send Adobe PDF files by Email. Email data will populate by default, but that is something that could be changed if the wrong column is selected.
- Type in a special email Message, if desired.
- Press Ok
3. Select a location to save the merged PDF files. This creates separate PDFs for each of the merge results, for your records.
How To Create An Email Mail Merge
If there you don’t see a location that will work, notice you can also create a new folder in the lower left.
How To Do Mail Merge In Outlook Mac
Double Check Results
- Open your Outlook.
- Since you are working Offline, these files are going to be sitting in your Outbox. You should see a number on the left side of your screen next to Outbox. Click on the Outbox to access the folder.
How To Do Mail Merge In Outlook 2010
3. You will see a list of emails. Double click on any of them and take a look at the email that is set to send. You will see your message, subject line, and a PDF attachment.
4. Double click on the attachment. Here is the letter you wanted to send, as a PDF attachment.
5. The individual PDFs are also living wherever you chose to store them on the previous section, step 3.
Work Online
Don’t forget that you need to go back online again with yourOutlook! When you go back online, all of the emails in your outbox are going tosend automatically, and in this case (with our fake emails) is not a good idea.
- Click on the red X to the right of of each ofthe emails to delete them.
- When you are finished, revisit the Send/Receive tab and toggle off the Work Offline button to go back onlineagain.
Thoughts?
Will you use this in your area? I would love to hear how youplan to use this tool!
Congratulations, Power Users!
Congratulations to our newest Power Users! For the fullgallery, and more information about the WSU Microsoft Office Power UserProgram, please visit: wichita.edu/poweruser