none
Need help to export a sheet as pdf and then attaching it to an email. RRS feed

  • Question

  • Hello!

    I use Excel 2007 and VBA.

    Lately I have been trying to fix a macro that can:

    1. Export an active sheet as a pdf (not a big deal).

    2. Attach this pdf to an email with the subject, body and receiver predefined (far to complicated for me!)

    3. Sending the email.

    I have been searching quite a bit but I'm not too good at puzzling different macros together and getting them to work :-)

    I'll be very thankful for any advice!

    /Ollall

    Wednesday, September 3, 2014 1:03 PM

Answers

  • I found http://www.rondebruin.nl/win/s1/outlook/amail2.htm which does what I want it to (apart from it being exported as a .xlsx)

    • Marked as answer by Ollall Friday, September 5, 2014 11:43 AM
    Friday, September 5, 2014 11:42 AM

All replies

  • As far as emailing I use a product from Codestone.

    http://www.codestone.co.uk/software/docs/csmail/csmail.html

    You need the SSL Edition.  I use it with both Gmail and Outlook.com

    It is simple to use and cheap.  The other techniques were complicated and didn't work consistently.  Plenty of VBA examples.   I have nothing to do with this company.


    • Edited by mogulman52 Wednesday, September 3, 2014 4:35 PM
    Wednesday, September 3, 2014 4:34 PM
  • OK Thanks!

    But as I'm going to distribute the excel to colleagues it won't work for them or?

    Thursday, September 4, 2014 3:03 PM
  • I found http://www.rondebruin.nl/win/s1/outlook/amail2.htm which does what I want it to (apart from it being exported as a .xlsx)

    • Marked as answer by Ollall Friday, September 5, 2014 11:43 AM
    Friday, September 5, 2014 11:42 AM
  • Ollall, csmail has a executable the you can embed in all your VBA programs.  Just request it with product purchase.  No extra cost.  It comes with an installer.  I do that for all the apps I distribute and need email.

    • Edited by mogulman52 Friday, September 5, 2014 4:33 PM
    Friday, September 5, 2014 4:32 PM