#MAILINGS IN EXCEL HOW TO#

Go to the bottom of the Wizard and click on Next: Preview your letters.You can choose long formal names or shorter, more personal name formats. Here you can explore the different types of greetings you want. Now click on the Greeting line in your Mail Merge wizard.Now you can press enter a few times so that your letter looks clean.

Once you have selected everything according to your needs, click on OK. You can check out the different options available such as company name or different displays for address as well. Choose the format in which you want to display the name of your recipient.Here you will manage the contents of your letter. Now that you have imported your list of recipients, you need to write your letter. Go to the bottom of the Wizard and click on Next: Write your letter.It will show you a preview of your data.You will get a small window showing the name of the worksheet where all of your data is. Navigate to the file you want and double-click on it. You can even choose the Type a new list and manually create a new list for your contacts. You can choose Select from Outlook contacts if you want to use your contacts on Outlook. Under the Select recipients’ list, Choose the method that you want.You can use an existing list or you could alternatively use Outlook contacts, or manually create your own list. Now you must decide where you will obtain your list of addresses. Go to the bottom of the Wizard and click on Next: Select recipients.Choose whichever option you want under Select starting document list. You can either use the current document or a template or an existing document as the basis for the mail merge.Now that the wizard has advanced, the next step is to select or create a starting document.

Go to the bottom of the Wizard and click on Next: Starting Document.

Under the Select document type list, choose the type of document that you want.

Now it is a simple step-by-step process that you need to follow. This will open up the Mail Merge Wizard on your screen.

Click on the Start Mail Merge > Step-by-Step Mail Merge Wizard option.

#MAILINGS IN EXCEL HOW TO#

You can also download your contacts from different email programs and use that file as your data source.įollow the steps below to know how to use Mail merge in MS Word: This can be from various sources like MS Excel, a CSV, or even your contacts in Microsoft Outlook. A data source from where you will get all the information about your recipients.A document that contains the content of your letter.A Mail Merge function requires basically two things:

Mailings in excel