Mail Merge Excel And Word. Performing the mail merge. How to merge excel data into a word document 1 open the word document that you would like to use as template.
Now to watch the magic happen. The excel spreadsheet to be used in the mail merge is stored on your local machine. Changes or additions to your spreadsheet are completed before it s connected to your mail merge document in word.
This visual walkthrough guide has all the steps you need for a mail merge with microsoft word and excel.
Now from various options choose step by step mail merge wizard from the list as shown in the below screenshot. This can be a new document or an existing document. For more information see prepare your excel data source for mail merge in word. How to do a mail merge with word excel the components of a mail merge.