#How to do mail merge in office 2016 pdf#
#How to do mail merge in office 2016 Offline#

Email data will populate by default, but that is something that could be changed if the wrong column is selected.

#How to do mail merge in office 2016 pdf#

Check the box next to Automatically send Adobe PDF files by Email.Instead of going to Finish and Merge, like we usually do, we are going to select Merge to Adobe PDF. In Outlook, go to the send/receive tab and select Work Offline.Р В РІР‚СњР В Р вЂ№.Review your email merge before going back online and sending them.

#How to do mail merge in office 2016 Offline#

When you work Offline in Outlook, it allows you the opportunity to Merge, but I will ask you to do it this time, since we are working with fakeР В РІР‚СњР вЂ™Р’В®mail accounts, and you probably donР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС›t want to receive a bunch of bounce backР В РІР‚СњР вЂ™Р’В®mails. In real life, this is an optional step when doing an email Select Recipients and browse for the Excel fileР В РІР‚СњР СћРЎвЂ™. Go to Mailings tab and select Start Mail MergeР В РІР‚СњР вЂ™Р’В¤. You will start this merge like any other email merge:Р В РІР‚СњР РЋРЎвЂє.

Important: you should save these both to your desktop before starting, since you will have to browse to find the Excel file when merging.

Mail Merge Database Excel File: this is a fictional database for linking to the merge document.

This is a fictional letter for potential students.

Sample Letter Word Document: this is your file that you would like to turn into a merged PDF for recipients.

Here are a couple files for experimentation, if you would like 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.

Also, for these exercises, I am assuming you have some experience with Mail Merge in Word.

Request Acrobat DC, or other Adobe CreativeР В РІР‚СњР вЂ™Р’В¬loud programs, contact the Help Desk at 4357.

Today I am going to be referencing an Add In that comes with the installation.

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 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. 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.