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