View Single Post
 
Old 09-04-2022, 01:53 PM
Logit Logit is offline Windows 10 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 587
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

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.
Reply With Quote