Word - Letter mailmerge

Hi Guys,

i have 2 page word doc, and 30 data in excel, save as each pdf, and sent mail

when i try it convert 1st data only, rest of the pdf files are same 1st data

kindly support this


Pls elaborate a bit lot on the requirements
Cheers @yaser

  1. I have 2 page word doc
  2. and Excel have 30 Data’s (Name, Address 1, Address 2, State, E-mail, etc,.)
  3. Find “Name” Replace from Excel “Name1” (“add1” to “Address1”, “add2” to "Address2)
  4. Save As PDF as each document (2 Page)

This RPA like MS word Mailmerge, but ineed save as pdf in each doc and sent mail