Creating a VBA Code to print then send as an email attachment

[bcfd_110]

Hello,

In am relatively inexperienced a VBA but eager to learn more. What I am trying to accomplish is create a command button at the end of a letter template in word that will not only automatically print the letter but will also save as a PDF then open a new message in outlook with said PDF as an attachment. I've been looking through the forums and have found bits and pieces of coding but I'm just not sure how to put it all together. Would anyone be willing to provide any assistance on what the coding would look like (if it's even possible to do all this)?



Thanks in advance!

[Logit]

What you are describing is several different macros that are run, one after another.
The first macro will print your document (as you have already described); the next saves that document as a PDF and the last macro will attach the PDF to an email and send via Outlook.


Understandably it all appears to be Greek to you at this point but truly the process is rather straight forward.


Yes ... there are tons of examples for each of the macros you describe, on the internet for the taking.


If you have never written a macro before, I suggest looking at a few YouTube videos "How to write a VBA macro". Once you get the hang of that, 'google' for 'VBA print Word Doc' ... then 'google' for 'VBA Save Word as PDF'. Finally, 'google' for 'VBA Email with attachment'.


You can also look for 'VBA run several macros' so you can learn how to "call" one macro after another.


Come on back when you run into trouble ... but give it your best shot first.