Use of Mail Merge
Mail merge Start a mail merge to create a form letter which you intend to print or email multiple times, sending each copy to a different recipient. You can insert fields, such as name or address, which word will replace automatically with information from a data base or contact list for each copy of the form letter. Mail merge is one of the very important application of any word processing software. Word has indeed made it very easy to operate, in mail merge you have the variable data coming from a data source which can be a database file spreadsheet, or even a text file with file marked in it.Then you have the document file whose text remains the same for all the subsequent merged files changing only the data which has been received from the source. So in fact you create multiple documents having the same text but having different fields depending upon the source.
That means mail merge option requires two documents to merge first address and other letter document. Well, one can think of various usages of the mail merge. The most important being sending the same letter to various parties, sending the same call letter to the various candidate. Sending call letter to inform candidate. Calling all the candidate to attend exam. In all these cases, the text would remain more or less the same but the name and address of the receiver would changes.
Here we are using same letter, which we had created earlier to various candidate.
Step :- 1. We will create data of candidate in excel file.
Windows key + R –>
The run command will be open on the screen.
Type here excel
Step :- 2. Open excel then select any sheet. Now fill all the information of candidate then save it.
Note:- For security reason i am not write any person name only i am giving you only a demo. That’s why i write these things in excel sheet.
Step :- 3. Now open office word by pressing windows key + R
The run command will be open on the screen. Type here “winword”.
Now click on OK
Step :- 4. Now write your letter whatever you want to send to candidate.
I am typing these word after that i use dot (……….).
Step :- 5. Put the cursor on first page of first line home. Now click on mailings tab.
Step :- 6. Now click on start mail merge. Now click on step by step mail merge wizard to open the mail merge task pane showing step 1 to 6 in the wizard. Here the pane asks you to point out which type of document you are working on
Step :- 7. Now select letters radio button.
Step :- 8. Click next : starting document at the bottom of the pane. To reach the next step.
Step :- 9. In the task pane, click the use the current document option.
Step :- 10. Then click next select recipients.
Step :- 11. In the task pane, click the use an existing list.
Step :- 12. Then click on Browse.
Step :- 13. Now select the location of file and then select the excel file where data is exist of candidate.
Step :- 14. Now click on open
Step :- 15. Now select the sheet where candidate data is exist.
Now click on OK button.
Step :- 16. Here you can see that the information of candidate.
Now click on OK button.
Step :- 17. Now click on next write your letter.
Step :- 18. Click on more items.
Step :- 19. A dialog box will be open of insert merge field. Now select your data type then insert one by one.
Step :- 20. Now close insert merge field dialog box. Now arrange data base field.
Step :- 21. Now click on Next: preview your letters.
Step :- 22. Now click on Next: complete the merge.
Step :- 23. Now click on Print or Edit individual letter. When you Click on edit individual letter to view separately or click on print for hard copy. When you click print or edit individual letter a dialog box will display. I will choose print for print the letter individual.
Step :- 24. Now choose as per as your required option. if you want to print all document of candidate the select “All” radio button.
Then click on OK button.
Step :- 25. Now click on ok to print.
I hope that you understand my post. if you like this post then share my post, and comment on my post if you have any suggestion or Queries related to MS Office or Mail Merge. Thank you!
I’ve been surfing online more than three hours these days, but I by no means found any attention-grabbing article like yours. It is lovely worth sufficient for me. In my opinion, if all site owners and bloggers made just right content material as you probably did, the net will be much more useful than ever before.
Hi, just required you to know I he added your site to my Google bookmarks due to your layout. But seriously, I believe your internet site has 1 in the freshest theme I??ve came across. It extremely helps make reading your blog significantly easier.
My developer is trying to convince me to move to .net from PHP.
I have always disliked the idea because of the expenses.
But he’s tryiong none the less. I’ve been using Movable-type on a number of websites for about a year and am nervous
about switching to another platform. I have heard very good things about blogengine.net.
Is there a way I can transfer all my wordpress posts into it?
Any kind of help would be really appreciated!
Hello There. I found your blog using msn. This is an extremely well
written article. I will be sure to bookmark it and return to read more of your useful info.
Thanks for the post. I will certainly return.
Greetings! Very helpful advice in this particular article!
It is the little changes that make the largest changes. Many thanks for sharing!
Hi there, just became alert to your blog through Google, and found that it’s truly informative.
I am gonna watch out for brussels. I will be grateful if you continue this in future.
A lot of people will be benefited from your writing.
Cheers!
It’s very trouble-free to find out any matter on net as compared to books, as I found
this post at this site.
Thanks in support of sharing such a fastidious thought, paragraph
is pleasant, thats why i have read it entirely
Pretty nice post. I just stumbled upon your weblog and
wished to say that I have really enjoyed browsing your blog
posts. In any case I will be subscribing to your feed and
I hope you write again soon!
It’s amazing to pay a quick visit this web page and reading the views of all mates on the topic of this paragraph, while I am also zealous of getting know-how.|
I used to be suggested this blog by means of my cousin. I’m now
not sure whether or not this publish is written through him as nobody
else recognize such detailed about my trouble. You are amazing!
Thank you!
What i do not understood is in reality how you are now not really much more smartly-favored than you may
be now. You are so intelligent. You realize therefore significantly
on the subject of this matter, produced me for my part consider it from
numerous varied angles. Its like men and women don’t seem to be involved until it is one thing to do with Lady gaga!
Your own stuffs great. All the time deal with it up!
I think the admin of this web site is genuinely working hard for
his site, since here every information is quality based data.
I blog quite often and I really appreciate your content. This great article has truly peaked my interest.
I am going to take a note of your site and keep
checking for new details about once a week. I subscribed to your Feed
as well.
I was very happy to discover this page. I need to to thank you for ones time
for this fantastic read!! I definitely liked every part of it and i
also have you book-marked to see new information in your
website.
Hello there! I know this is kinda off topic but I was wondering if you
knew where I could find a captcha plugin for my comment form?
I’m using the same blog platform as yours and I’m having
problems finding one? Thanks a lot!
Right here is the right website for anyone who wishes to find out about this topic.
You realize a whole lot its almost hard to argue with you (not that I
actually will need to…HaHa). You definitely put a new spin on a subject which has been discussed
for ages. Wonderful stuff, just great!
Yes! Finally something about plenty of fish dating site.
Hmm is anyone else experiencing problems with the pictures on this blog loading?
I’m trying to find out if its a problem on my end or if it’s
the blog. Any responses would be greatly appreciated.