Use Outlook contacts as a data source for a mail merge If you know you'll be using Excel or Outlook as the source of your data, see: If you don't yet have a data source, you can even type it up in Word, as part of the mail merge process.Р”Р‡or details about data sources, see Data sources you can use for a mail merge. Excel spreadsheets and Outlook contact lists are the most common data sources, but any database that you can connect to Word will work. Hence, this helps you to save a lot of unproductive time which you can utilize in other productive activities.Your first step in setting up a mail merge is to pick the source of data you'll use for the personalized information. In a given few simple steps you can do hours of repetitive and tiresome work of sending mass email in a few minutes. РІР‚СљFromРІР‚Сњ: Define row number to send emails to a particular set of people.РІР‚СљCurrent RecordРІР‚Сњ: Email will be sent only to the current recipients which are selected.РІР‚СљAllРІР‚Сњ: This function allows you to send emails in one go.

There are three options in РІР‚Сљsend recordРІР‚СњР”Р„s mentioned below. The mail РІвЂ вЂ™ Select any one type from РІР‚Сљ send Step 7: Select the option in a pop-up tab which contains email address РІвЂ вЂ™ click on РІР‚Сљ okРІР‚Сњ 3. Number 12 option highlighted in the image allows you to review all the draft emails which you are going to send as a mass email and as a result, you can correct the data if there is any mistake. Click on finish РІвЂ вЂ™ Click on send email messages Recipients will change if you click on the arrow shown in box 12. Step 6: Here you can check by using the РІР‚Сљ preview resultРІР‚Сњ option. Click on РІР‚Сљ insert merge fieldРІР‚Сњ РІвЂ вЂ™ Select the unique data from the list which you want to change as per recipients Step 5: Insert merge field gets enabled after uploading the excel data source sheet. You have to select that particular sheet in which input data is present). Step 4: Select an Excel sheet where your data is stored and click on РІР‚СљokРІР‚Сњ (once you click on open, a new window will pop-up and it will show all the sheet of that excel file. Step3: Select a data source where you have saved the excel file with all the customer details РІвЂ вЂ™ Click on РІР‚СљopenРІР‚Сњ. Step2: Write a common mail body which you want to send to all customer РІвЂ вЂ™ click on select recipients РІвЂ вЂ™ click on use an existing List Step1: Open Microsoft word РІвЂ вЂ™ Go to mailing tab РІвЂ вЂ™ click on start mail merge РІвЂ вЂ™ click on E-email messages If the header is not there then it will be difficult for you to select the field. Hence, each column must contain header so that you can select from the list because in the РІР‚Сљinsert merge fieldРІР‚Сњ option you can only see column title or header. Note: Header row (title) must be there for each column, as in mail merge data is tracked according to the column title.

One sample format is shown in the below image. Prepare the data in an excel sheet (.xlsxР”Р‡ormat) which contain unique data and email address to whom you want to send anР”В®mail. Note: To send a mass email outlook should be installed on your laptop. Therefore, the mail merge allows you to send an email to all customers in just a few clicks. If you want to send the same email or letter to thousands of customers then it becomes a very tiresome activity to send emails to all customers one by one. Mail merge is a very important feature of Microsoft word which helps to send mass emails, create letters, create envelopes and labels.

How to do a mail merge word mac