Latest Updates

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

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

http://4.bp.blogspot.com/-3LQJWrTETzA/VnOMt1o18QI/AAAAAAAABWU/_OcVP5Wp8Kw/s640/dummy%2Bletter%2Bexcel1.png

2. Then create a Ms Word file an application or letter document and type header names. see below: –
http://1.bp.blogspot.com/-QnymfWZIELQ/VnOQxiLC7NI/AAAAAAAABXg/cfqT54xcUB8/s640/2.%2B%2Bdummy%2Bletter.png

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

http://3.bp.blogspot.com/-wbEkT2l8YKE/VnOQ2waNQyI/AAAAAAAABXo/nPCUXWGuoz8/s640/2.%2Bdummy%2Bletter.png

http://1.bp.blogspot.com/-T73QTS6ZzUI/VnORDlEk6sI/AAAAAAAABXw/9wl0I3ZIkg8/s640/3.%2Bdummy%2Bletter6.png

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

http://3.bp.blogspot.com/-elFWfCMX-Bg/VnORJQBtaMI/AAAAAAAABX4/MkWpkfqxC40/s640/5.%2Bdummy%2Bletter.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: –

http://2.bp.blogspot.com/-ip20lALymeQ/VnORNqPVX3I/AAAAAAAABYA/YBvN7Rq-QQg/s640/6.%2Bdummy%2Bletter.png

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

http://4.bp.blogspot.com/-pIElWjsscyo/VnORdfkpxaI/AAAAAAAABYI/Rve3f4UFKYo/s640/7.%2Bdummy%2Bletter.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….

http://4.bp.blogspot.com/-FZYDuKkCkp0/VnORkANoyzI/AAAAAAAABYQ/VbPz0k2snz8/s640/9.%2Bdummy%2Bletter.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.

http://2.bp.blogspot.com/-0dOVtAVjRvI/VnORoI4W38I/AAAAAAAABYY/4iHv5SMBGk4/s640/10.%2B%2Bdummy%2Bletter%2Bexcel.png

Thanks…

loading...

About The Author

Related posts