How To Perform A Mail Merge – Finish

How To Perform A Mail Merge – Finish

Step 4: Previewing the mail merge

After you insert the merge fields you want you can now preview the results to confirm that the document is set-up the way you want.

On the Mailings tab, choose ‘Preview Results’. The merge fields will be populated with the data on the first row of your excel document.

How To Mail Merge_4

To move through the records in your data source and view how they will appear in the document choose the right arrow to advance or the left arrow for the previous record.

Step 5: Merging your documents

On the Mailings tab, choose the ‘Finish & Merge’ button, a list of different types of merges will drop down (i.e. Edit Individual Documents, Print Documents and Send Email Messages) choose ‘Edit Individual Documents’. A ‘Merge to New Document’ pop-up box will appear, choose ‘OK’.

How To Mail Merge_5

How To Mail Merge_6

You will now have a separate letter for each of the rows on the excel document which you can print, email, etc.

Step 6: Saving your mail merge template

When you are done working with your merged documents, save and close it as you would any other Word document. Once closed the mail merge template will still be open. If you plan to reuse it in the future, save it and it will stay connected to your data source.

Now that you know how to perform a mail merge in Word from Excel you have a powerful tool to help you with your commercial real estate marketing efforts.

In ClientLook CRM you can set-up custom Groups to categorize your contacts (for example: Holiday Cards, Investors, Brokers, etc.) and quickly pull up a list of them which can then be exported into Excel to then use as your source document in a mail merge.

Congratulations, you’re done!

« Previous Restart

Related posts

About the Author

Michael Griffin

Michael Griffin - ClientLook, Founder

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.