For the mailmerge basics, see:
How to use the Mail Merge feature in Word to create and to print form letters that use the data from an Excel worksheet - Microsoft Support


Use mail merge for bulk email, letters, labels, and envelopes - Microsoft Support
To split the output into separate documents, see also Send Mailmerge Output to Individual Files and Run a Mailmerge from Excel, Sending the Output to Individual Files in the Mailmerge Tips & Tricks 'Sticky' thread (https://www.msofficeforums.com/mail-...ps-tricks.html) at the top of the Mailmerge forum.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

thank you very much

i am going ro read this add in of graham that you have sent me

i attach the doc in which the red data is the one i want to link with excel

in the case of being only one document, i would like to use vba code to link with excel instead of using the merge add in, how can i do it?

thanks

Attached Files

Aaa.docx (18.8 KB, 6 views)