SEO

Mail Merge and Bulk Email in MS Word

This presentation exhibits bulk electronic mail recipients from MS Word utilizing information from an exterior one-table database. Each recipient will obtain a customized message through electronic mail.
Objective:
To ship an electronic mail to every gross sales individual exhibiting how a lot product they’ve offered and a quick remark summarising their efficiency. Each electronic mail is to be customised.
Step 1.
Set up a one desk database. Each row is a file apart from the primary row, which accommodates the column headers or area names. Each column is a area. For the needs of this presentation, the desk has been created in MS Excel, on a sheet named Main.
The Excel file, named MyData.xlsx, serves as an exterior database file.
Step 2.
From the MS Word file, a connection is established between Word and the exterior database. The message is created from inside Word and fields are inserted from the exterior database into the Word doc.
Step 3.
The “If … then… else” rule is utilized to supply particular feedback relying on a specific area worth. The “Skip record if” rule is utilized to exclude sure data (i.e. people) from the mail merge or bulk electronic mail.
Step 4.
The emails are generated and despatched to recipients recognized within the exterior database. The emails are despatched by the default electronic mail shopper, which on this case was MS Outlook.

Your Opinion Matters

Quality - 10

10

Total Score

Your feedback is important to us to improve our services. We constantly seek feedback to improve and evolve our service, whilst identifying opportunities to assist clients in realising their business objectives.

User Rating: 5 ( 6 votes)

Tags

Related Articles

50 Comments

  1. Wow! Thanks for sharing wonderful tutorials. Just to know in Rules If…Then..Else is there any way we can send different letters? For example if the total is less than X amount then separate letter should go.

  2. Shortly after watching this video, I try exercising it in MS word 2010. For your information, it works well, and I will say BRAVO to you for this nice peice of lesson. God bless you and your family.

  3. shit it would have been good to know that once I hit okay at the end that the emails would be sent…I was trying to do a test and ended up sending out a bunch of emails…

  4. can we choose which email we want the merged email to send out from? I tried and it always send out from one particular email which I am trying to change to other email accounts.

  5. I have a large number of e-mails that I want to use that are hard copy and must be typed into my email account. Before I begin this tedious work is there another app I should be typing these email into before I do an email merge? I have a yahoo account I'll be using. Thanks for making such a clear and easy to understand tutorial.

  6. I often sent MS word files vai gmail. but afrer opening the files received from me, some receivers observe that the words and sentences of the MS word file merge together one word with other. what is that?

  7. sir let me know that can we make table headings in rows instead of columns..i means to say can we make table row wise instead of columns wise.. likewise main heading will be in rows (in single column) and their data will be in next one column???????

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button
Close
Close