Sending an email of a newly created PDF file through VBA

Hello I have the following code working great. It saves the first sheet of my workbook as a PDF file. Now I want this same code to Email this file (PDF file it created) to an email group. Any ideas on how i can accomplish this task?

Here is my Current code.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

You sir are a savage!

Is that a compliment these days?

I'm taking it!

daffodil-11, SAVAGELY PRETENDING TO KNOW HOW TO CODE!

Also, in case you were wondering, there's a lot of codey bits associated with an email.

Please Login or Register  to view this content.

Also, I struggled with copying a whole range of cells directly into the Body, but if you want you can Range("a1:A23").Copy before you open the email, and then after the End With of the email (assuming you don't Send but use .Display) you can then add

Please Login or Register  to view this content.

Which will force an adorable copy and paste directly into the email body as a table of the cells.



And of course, now that you got a nice Late Binding code for Outlook, you can even run hot little Loop macros that run through a 100 rows of A looking for a certain criteria, send an email to B, copied C, with subject D, etc, etc. Hundreds of emails in seconds.

http://www.rondebruin.nl/win/s1/outlook/bmail2.htm

Regards, TMS

That link was utterly savage.