I am trying to automate mail merge from access to word and within Word use Acrobat PDFMaker Office COM addin to send emails with each record saved as a pdf and attached to an email. I am able to do it manually but I'd like to automate it,does this sound possible?
I tried to record a macro while doing it manually but that didn't come up with anything usable, which is why I wondered if I could actually control PDFMaker via vbscript.
Thanks to anyone that can give me some insight.
I tried to record a macro while doing it manually but that didn't come up with anything usable, which is why I wondered if I could actually control PDFMaker via vbscript.
Thanks to anyone that can give me some insight.