Send Mailmerge Output to Individual Files

[vicky6615]

Hello Friends,

Please refer to the attached files, where i am trying to Mail Merge the data source to Individual PDF Files, but when ever i try to run the code it gives runtime error 5941 "The requested member of the collection doesn't exist". I have no clue where the mistake is

I originally referred the VBA code from #msofficeforums, and made changes according to my requirement.

I have predefined the Data Source as (Cell Reference) named "Data_Table" in the excel Sheet and then selected the same as data source in mail merge document.

Therefore i need help with your expertise.

Also i want to append the code to send the generated PDF files through mail (Outlook) to the email id's mentioned in the excel sheet.