Mail Merge with Attachments in Outlook or Gmail or Yahoo

How to send mail merge 

How to send bulk mail through Mail Merge in Ms word?

What is mail merge?

    Simple term “ Mail merge is sending bulk of mail at same time to reach group of people. It contains message along with various attachments or envelops or text message or images etc.

Requirements for using mail merge

•             Ms Excel : Spreadsheet contains person name and email address details
•        Ms Word : Text message has to typed for sending our users
•    Outlook : outlook email ID or Office 365 ID is required to send a mail to group of people

Where it's available mail merge option ?

     Mail merge open available in MS word document like Mailings

If it’s available only mailing option, we can send only mail and not possible to send any attachments.

If you want to send mail as well as attachments, you need Merge tools option in Ms word like below.

Normal word document that menu not available so you need to install merge tools Addin  otherwise I will give link below, in that available merge tool option available you can make use of it for sending attachments.

Mail merge Add in created by Doug Robbins : https://zee.gl/jQxyhba

Note: 1.File available in one drive so if you have one drive account only you can get this so keep one drive account.

2. once click above link ,then click get link,it will open another window that you can close and again click get link again one add window will open that too you have to close again click 3^rd time get link then file will be downloaded like below then click red rounded folder then choose word file.

Process of doing Mail Merge

Step 1: Generate Excel file contains user email id and attachment link.

I am sending payslip of 3 employees and you can send 10,000 or more employees like below you can send. Here I have given same email id for showing how it’s reach to their mail so you can type respective user mail id.

Generate link for payslip location :

Go to insert -> click links menu -> Then click insert link -> then choose path of saving file -> select file ->click ok then link generate like below

Step : 2  Generate body of letter

Click this link : https://zee.gl/jQxyhba -> how to get word document that procedure given above follow the procedure

  Ø  Open word document

  Ø  Type the message which you want to send like below

  Ø  Go to mailing  -> Start mail merge -> Click Letter 

  

  Ø  Go to mailing -> click select recipients ->use an existing list  ( because we already created excel file) - > select respective file and click ok

  Ø  Keep a cursor near by “Hi” then click insert merge filed menu -> Click first name

  Ø  Then below will be added near by “Hi”

Ø  Go to Merge Tools-> Click Merge with Attachments 

  Ø  Then below window will open -> close that window  and save your word file in desktop

  Ø  Again, click merge with attachments then below window will show -> then add payslip location into right side -> select like window showing below -> then click continue

  

  Ø  Then automatically text with attachment reach with respective user mail id same item like below

I think all will understand the process and here i have given the video if you need more clarification check this video and subscribe youtube channel to get all update. 

Kindly comment the view of blog and topic that will more helpful to improve the information in both channels.