How to send multiple emails at once from outlook by using ms-excel?

 

For example if you want send your cover letter to multiple recipient (Containing the recipient name, company):

 

Create Excel sheet with the following fields:  Column A : Recipient Name , Column B : Company Name, Column C : email address

 

Open a new word document

 

Switch to Mailing Ribbon, Click on the Start Mail Merge menu and select the Step by Stem mail wizard

 

Follow the easy6 steps in the task pane

 

Open a new word document

 

Switch to Mailing Ribbon, Click on the Start Mail Merge menu and select the Step by Stem mail wizard

in the wizard you will be abel to create address list for the recepiants .

 

 

To do this, click the Options tab, and in the Show Fields section, click Bcc. The Bcc field is added to the Message window. Add the email addresses for all the people you want to receive this email either by clicking the Bcc button and selecting them, or by entering them manually in the Bcc field.

Make an Email contact list in Ms Excel then in Outlook perform the mail merge action and by completing mail merging then email messages can be sent to multiple receivers.

CLICK START MAILMERG MENU THEN STEP BY STEM MAIL THEN CREAT ADDRESS

By attaching the file to be sent, or you can attach multiple files and put the consignee address you can put more than one title in a single email