Macro for mail merge in excel

[shaikhstonevilla]

Hi,

I have 2 excel sheets. (Say "Data" & ""Payment Reminder Letter")

Data excel sheet contains sheet 1, sheet 2, sheet 3....


I want copy and paste particular data from data excel sheet to payment reminder letter for each client.

Please help me.

Thanks,
Sam.

 

[paddydive]

All you need is Mail Merge in Word

Explore here and on Google

Mail merge using an Excel spreadsheet - Word - Office.com