How to create mail merge from excel how to#
How to create mail merge from excel code#

How to create mail merge from excel code#

Once youвЂ™re done writing the letter, then look to the right of your screen and you will see five options where you can insert information вЂ“ the five main options are: Address block, Greeting Line, Electronic Postage, Postal Bar Code and More Items.

In this step, go ahead and actually write the standard letter and leave blank the areas that you want to insert from the Excel file вЂ“ in this case, the addresses data.

And click вЂњNext: Write your letterвЂќ to move to the following step. Delete the check marks from any piece of data that you donвЂ™t want to include and hit OK.

Now you will see the list of the mail merge addresses.

Now the вЂњSelect TableвЂќ pop up window box appears, and in here click on the specific Excel sheet or range that has the address information, and click OK to move to the next step.

Next, look through the options and when you find the Excel file with the address information, click it to select it.

Hit Browse and you will see the вЂњSelect Data SourceвЂќ pop window box. Next, click on вЂњcreate mail merge from the current Word documentвЂќ and you also have the option to click on вЂњfrom another existing word document.вЂќ And hit вЂњNext: Select RecipientsвЂќ and click on вЂњUse an Existing List OptionвЂќ вЂ“ now weвЂ™re going to search for the Excel Workbook with the Address information. Under вЂњSelect document type,вЂќ click on вЂњLettersвЂќ and hit вЂњNext: Starting DocumentвЂќ to move to next step.Open Microsoft Word 2007 and go to Mailings>Start Mail Merge>Step by Step Mail Wizard, and the вЂњStep by Step Mail MergeвЂќ wizard will open up to the right hand side of your screen. First, ensure you have the Excel workbook where you have all the address data securely saved and accessible, although, you donвЂ™t need to have it open to create the mail merge.Follow these steps and you will look like a star in front of your peers. DonвЂ™t worry, I will show you how simple and quick it is in this short tutorial. Perhaps you did it once, or you saw someone do it and thought you would remember, but you donвЂ™t.

How to create mail merge from excel how to#

Have you ever been asked at work вЂњHey, do you know how to do a mail merge?вЂќ and you think to yourself, I know how to merge columns, yes I have done it but now I canвЂ™t remember for the life of me.