VBA to mail merge multiple documents from one data set
Posted on 2016-08-24
I need some guidance on the mail merge to create multiple pdf documents using vba. Example: From the below sample table i need to create letters in PDF ( if possible with password protection) based on the country column. The result should be 2 PDF seperate documents USA file will have 5 and UK 4 letters ( based on number of records in each country).
First Name Title city Country
Davolio Sales Representative Seattle USA
Andrew Vice President, Sales Tacoma USA
Janet Sales Representative Kirkland USA
Margaret Sales Representative Redmond USA
Steven Sales Manager London UK
Michael Sales Representative London UK
Robert Sales Representative London UK
Laura Coordinator Seattle USA
Anne Sales Representative London UK
Appreciate your help.