Hello,
I'm still pretty new to VBA, and would like some assistance if anyone is willing to offer it... I do not have any code written as i don't even know where to start...
What I currently Do:
I have an excel sheet that has the exact same column data every single time. I use this data to do a simple mail merge, and from here i would just print out all of the paper forms and mail them out as a normal person would do...
What I'm asking:
Is there a way that I could have VBA do the mail merge and instead of printing them all out to a paper printer, to print each merged document to its own PDF file to a specified location and name it as a cell value already in excel? (if it helps, i use PrimoPDF currently to create pdf's, but if necessary, can probably get something else to do so)
General List size and information:
Basically, i have a list of about 150-1200 people depending on the month. I would virtually like to e-mail these pre-filled forms in pdf format as an attachment to these 150-1200 people along with mailing, but what is stopping me is i do not know how to create individual files for each merge in bulk. My List data has a file number for each person, so everyone file would have a unique identifier, there would never be any duplicates. (I already have the capability to run a macro that auto e-mails to the agents and can pull a file from a directory, the mail merge section is the only part stopping me).
Thank you for your help in advance, let me know if you have questions - i am pretty decent at manipulating a code to work to my needs if someone has a template already made.
I'm still pretty new to VBA, and would like some assistance if anyone is willing to offer it... I do not have any code written as i don't even know where to start...
What I currently Do:
I have an excel sheet that has the exact same column data every single time. I use this data to do a simple mail merge, and from here i would just print out all of the paper forms and mail them out as a normal person would do...
What I'm asking:
Is there a way that I could have VBA do the mail merge and instead of printing them all out to a paper printer, to print each merged document to its own PDF file to a specified location and name it as a cell value already in excel? (if it helps, i use PrimoPDF currently to create pdf's, but if necessary, can probably get something else to do so)
General List size and information:
Basically, i have a list of about 150-1200 people depending on the month. I would virtually like to e-mail these pre-filled forms in pdf format as an attachment to these 150-1200 people along with mailing, but what is stopping me is i do not know how to create individual files for each merge in bulk. My List data has a file number for each person, so everyone file would have a unique identifier, there would never be any duplicates. (I already have the capability to run a macro that auto e-mails to the agents and can pull a file from a directory, the mail merge section is the only part stopping me).
Thank you for your help in advance, let me know if you have questions - i am pretty decent at manipulating a code to work to my needs if someone has a template already made.
