Friday , December 6 2019
Home / DCA / Use of Mail Merge

Use of Mail Merge

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.

Use of Mail Merge

Read :- About Input Devices

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

Use of Mail Merge

Step :- 2. Open excel then select any sheet. Now fill all the information of candidate then save it.

Use of Mail Merge

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

Use of Mail Merge

Step :- 4. Now write your letter whatever you want to send to candidate.

I am typing these word after that i use dot (……….).

Use of Mail Merge

Step :- 5. Put the cursor on first page of first line home. Now click on mailings tab.

Use of Mail Merge

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

Use of Mail Merge

Step :- 7. Now select letters radio button.

Use of Mail Merge

Step :- 8. Click next : starting document at the bottom of the pane. To reach the next step.

Use of Mail Merge

Step :- 9. In the task pane, click the use the current document option.

Use of Mail Merge

Step :- 10. Then click next select recipients.

Use of Mail Merge

Step :- 11. In the task pane, click the use an existing list.

Use of Mail Merge

Step :- 12. Then click on Browse.

Use of Mail Merge

Step :- 13. Now select the location of file and then select the excel file where data is exist of candidate.

Use of Mail Merge

Step :- 14. Now click on open

Step :- 15. Now select the sheet where candidate data is exist.

Now click on OK button.

Use of Mail Merge

Step :- 16. Here you can see that the information of candidate.

Now click on OK button.

Use of Mail Merge

Step :- 17. Now click on next write your letter.

Use of Mail Merge

Step :- 18. Click on more items.

Use of Mail Merge

Step :- 19. A dialog box will be open of insert merge field. Now select your data type then insert one by one.

Use of Mail Merge

Step :- 20. Now close insert merge field dialog box. Now arrange data base field.

Use of Mail Merge

Step :- 21. Now click on Next: preview your letters.

Use of Mail Merge

Step :- 22. Now click on Next: complete the merge.

Use of Mail 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.

Use of Mail Merge

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.

Use of Mail Merge

Step :- 25. Now click on ok to print.

Use of Mail Merge

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!

Check Also

Download And Activate Microsoft Office for lifetime

Download And Activate Microsoft Office for lifetime Microsoft Office is a family of client software, …

19 comments

  1. 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.

  2. 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.

  3. 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!

  4. 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.

  5. Greetings! Very helpful advice in this particular article!
    It is the little changes that make the largest changes. Many thanks for sharing!

  6. 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!

  7. It’s very trouble-free to find out any matter on net as compared to books, as I found
    this post at this site.

  8. Thanks in support of sharing such a fastidious thought, paragraph
    is pleasant, thats why i have read it entirely

  9. 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!

  10. 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.|

  11. 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!

  12. 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!

  13. I think the admin of this web site is genuinely working hard for
    his site, since here every information is quality based data.

  14. 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.

  15. 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.

  16. 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!

  17. 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!

  18. Yes! Finally something about plenty of fish dating site.

  19. 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.

Leave a Reply

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