Gadgets

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/AVvXsEj0zJ8v3fPxi5_GmhIbieWG6Wfk8BxAjjtc3lWD88utg0UtqmW1ftNMvGJvddfmdLjr8eLreQA0duNibF1UkjbWzovt6oiaeRJzttT4kcvyEkLSXPR-TZCCDQK1H4L9CFude7WB9GDftuQ/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/AVvXsEiCh3ZUdeLsoCRzhxE1S8ToqP6o6A5Qb4VQe1rSFZPvi-UcSjb34vl2ATIGEonFgHZW2jPSh1rgoNQdETWMmmlgkO5fhdhczcDMa9Ai0xqydf_NoaIr_aQGKY9znEByU55yiwTwqqLmDIc/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/AVvXsEh8r76Va27LlnQnVHnqYQIzKqSN6o5Bjrx_aIySAlo7-KMQJ7wgGu9ETXug_jXEqPSz7WCcebM80Fm68tYKvYhtaMSBlD08dta1S0Npz9SN-2gcyQYCl3EioL2v-jOgZzsVoiGWNYq2Kps/s640/2.+dummy+letter.png

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjUWPzu9b2P5lAEkxA6q9f-C5U1grARuQFbwg7bnBY1rstTtGJ6h8NyNiDXtxBoTLhmmLMsU3jkztmhcE2OiuVMNlnWpoLDXugMJZ-_vrFDog2Q4JFTIFV15nlL1xAdv-YQp6ePEsjNlGA/s640/3.+dummy+letter6.png

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

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgeHs1uisuEhM-GinyxAmaqCa_Vc2AHRPZoDJ3MwcbDa0qpOHaEoJCFH8I2j36jKKwJSS8MarGof_WF-Mm5YwIV_OlrC-C2ftuuZuJOzoaXtTJpvlKKPBDtWkEaNvvxwtb7B3PWdgCllmY/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/AVvXsEjrSJFveDrBFL_IeSVsE-NpZVStNialSaGFK6WeUW-ms0Oqhq5a6ddEvJ51Vx4eC6cGHUBiFPNkoxM8i9YC5xUynvxkFwxYfc5Ty0qi2kVGuCldLw9nfQPw8dXnPgug697GPdyoKzDyw0M/s640/6.+dummy+letter.png

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

https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSFZY0Ut9R0OL5zLnKBqu3mfk5fDpuXkJ0xEcSrFQb02qziny87eYjwhPTlbqWLBwsK5oNLBbk0caVLTLpmnepxAa2UPBRefU2VJ20vhMm47nElTaHu1M7yeraE1Y8ESCFivfUmoflYl8/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/AVvXsEgIx8SptUoJ6BPSZ7_AZY2Jrf9SoI2W179x3UEv7eFYhO9JvDaPLMLw_4dSJjvcgB1DX0FQDl-eHUKPKnk0efxXzbgh-yEmAq8MOJSHmbR6QIcj05k2bNsB4uT1JAzMnh2rhdHHxesSRP4/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/AVvXsEgBf90zvAp-ufcQN5CWAvrPZPl0f_ncpvoIsc8tFlaGAiHLQVQHoSk9f8_Qhf25jKo3jUEofpPDby1hWCFtzhZ2ZLsrnNvL9qPCSEYQdS0AjywN75GzEsZ4vgE_lMeYQm02eCnYBOzCMuE/s640/10.++dummy+letter+excel.png

Thanks…

SHARE

services.com.pk

  • Image
  • Image
  • Image
  • Image
  • Image
    Blogger Comment
    Facebook Comment

0 Comments:

Post a Comment