How to Use Mail Merge in Ms Word, Data from Ms Excel

  1. Should have a Ms Excel data file. for example see below:- 

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhE8xpugQlFxArm-jLU96ROFmYJxiPbPOpIX-PipqyyNLb0CncZAS6A0slZrmNhwq8v-0OCIr0O8btv84dLTi87pxP4DSBbyYI4NgNp69at12su14mhilhx65WUcunHX4lIqkFJvmdqBMw/s640/dummy+letter+excel1.png

2. Then create a Ms Word file an application or letter document and type header names. see below: –
https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4BLSH0VPcvNQ3ZBGZfvmPG4ztYX8PFD26PU1XQFAnw0kFj8ZZM05V8e4y0cWIfaKyxOF9mLQ-uN87bOk8fJM9eKJeVTmTbJz5i9iS05CqVyrD8iNS_YHgcxY1DYgyy6f31Ox28tm5FHY/s640/2.++dummy+letter.png

3. In Mailing Option on toolbar click select recipient and then click use existing list to open a saved document. see below:-

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEinz9JC6kMoPRycdfB7x4mq7QaoDyH7HFW6rTVTg5YgD9MKegIU9816edXVc1AmRxxpLI9vwI0QWsizHVNnKQU1sLf4yQMXQ6G7aRljyRSyl0Xmj4TOKRPx5xNnPPZONuBrKAH5PfzmjuA/s640/2.+dummy+letter.png

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdTLUBYNRS-G0gKGHezay_YiVNImLndVGEUKHoVd8zNCfjHQwIz0W3A9P9H41H3fAZlEM4gM9xDKXe4mWjX7Idx91q8suH8tVKh2z1eAE8idvVHqn3s4oWbVDmpcSJBzcJz14PPYmtTyc/s640/3.+dummy+letter6.png

4. Select the specific sheet which contain data. see below:-

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRJwYbbFz7qdMoqkW2mOHB_g948hCJjHiYVIo99wWuunh3a-SklosAQQ_BB_wmZlpPzDE9S5TRNUZyxljEBLVlDgrVM4xwbKuIHROb-T426dzMgnIEa2qWbpktln7USwHeXNj275EvzzI/s640/5.+dummy+letter.png

5.  In Mailing Option click on  Insert Merge Field then select fields one by one. the selected field will insert in the page where cursor blink. see below: –

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhg_-4xsQce9T2ZTVL_D_hGaxQOHabEbK47faAuOxq4fIDedhAvenkO6-hyXV2MYtqpVo7iviKxqHwt5VetXR_8xP-ocgKfhe6DDJgOM5u9aHUQ-66WJimPMDkBWienAj0aKfMRSMHs9Gc/s640/6.+dummy+letter.png

6. In Mailing Option click on Preview Result. see below: –

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLqzZh2zSj1-QQ72g4mKuiLG2IE4QfjWdbEhEIkxqwi2Ex35NJs2_otMoxV0PRZrWBAjNBUcaZNcThnPwHj0iiRNe68JoV9ORa375NKOQBkM7SR12PydkGwfFlnFKvZXus8AtWyEAjXV0/s640/7.+dummy+letter.png

7. In Mailing Option click on Finish & Merge then click Edit Individual Documents… to create separated files. see below :- 

8. After click Edit Individual Documents… Command Merge to New Document  will appeared select option. see below:- 

9. After selection option from 1 to 5 the following 5 pages new document will create from Mailing Option. Your Document is complete print it….

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjlsyHxLz8nHW3VHDiRIulX-Oxvdm-wXuOa6AXQUUuf3iGB2zIgLDZ9_MFbUfydSKd5jnSZ82hxduKobshfBg39aTPX0K1GBUfevAIGz784FN8tA9Fsadw-gPSmJDaJDMpWYPLfbM0Dqu0/s640/9.+dummy+letter.png

Process are completed data which existed in Ms Excel Document (Name/Father’s Name/Address) transfer to Ms Word through Mailing Option one-bye-one record.

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1KMfKDk1-Klk7L-lcsXYoP_w2ihYE5rkHuKeK-DoRCBPzCU-vNz267AGNSactNpiQRRjEmT5RXX0rx9PCSjeafu6ylKDfl4OUIdyOnf1I3nd-NSfS-m6yWcN4a0buLMCJJVTKx9wU9Os/s640/10.++dummy+letter+excel.png

Thanks…

Share on Google Plus

About services.com.pk

    Blogger Comment
    Facebook Comment

0 Comment:

Post a Comment