venkateshv46
New Member
- Joined
- Nov 24, 2017
- Messages
- 1
My project:
Sheet with two browse button and one run button,
1ne for Excel data - Data source for mail marge and
2:another for word data - word Template of my letter.
Once i click the run button , needs to run the mail merge in word and split the data into individual and save as doc and pdf format with name from datasource. (For Example: First name | Last name | or combination of both)
How to do Mail Merge and split into individual pdfs and doc with filename from the data.
How do I structure the VBA script to accomplish this? Kindly help me out with this! i have seen many post and i dont understand ! am beginner. or Explain me syntax or how to do it ?
Thank you in advance.
Sheet with two browse button and one run button,
1ne for Excel data - Data source for mail marge and
2:another for word data - word Template of my letter.
Once i click the run button , needs to run the mail merge in word and split the data into individual and save as doc and pdf format with name from datasource. (For Example: First name | Last name | or combination of both)
How to do Mail Merge and split into individual pdfs and doc with filename from the data.
How do I structure the VBA script to accomplish this? Kindly help me out with this! i have seen many post and i dont understand ! am beginner. or Explain me syntax or how to do it ?
Thank you in advance.