Generate PDF from Excel & Attach to Email

Does any one have code to generate a PDF from Excel and attach to email. I would also like to pull the email address from the active sheet in excel.

Many Thanks

Bob

Hi Bob

There are third party programs thast you can use to print to a pdf file.
If you can run this with VBA (shell) you can add the file easily to a Outlook mail see

http://www.rondebruin.nl/sendmail.htm


> I would also like to pull the email address from the active sheet in
> excel.

You can use
..To = ThisWorkbook.Sheets("Sheet1").Range("C1").Value


--
Regards Ron de Bruin
http://www.rondebruin.nl


"bobwilson" <[email protected]> wrote in message
news:[email protected]...
>
> Does any one have code to generate a PDF from Excel and attach to email.
> I would also like to pull the email address from the active sheet in
> excel.
>
> Many Thanks
>
> Bob
>
>
> --
> bobwilson
> ------------------------------------------------------------------------
> bobwilson's Profile: http://www.excelforum.com/member.php...o&userid=33046
> View this thread: http://www.excelforum.com/showthread...hreadid=528941
>

Ron,

I was going to use Acrobat to generate the PDF. Do you know where I can get code to do this?

Bob

Hi Bob

I never try to make it automatic but I am sure it is possible when you use the full version of Acrobat
See David's site for more information
http://www.mvps.org/dmcritchie/excel/pdf.htm

I use the free PrimoPdf, but you have to make choices in a dialog when you use it

--
Regards Ron de Bruin
http://www.rondebruin.nl


"bobwilson" <[email protected]> wrote in message
news:[email protected]...
>
> Ron,
>
> I was going to use Acrobat to generate the PDF. Do you know where I can
> get code to do this?
>
> Bob
>
>
> --
> bobwilson
> ------------------------------------------------------------------------
> bobwilson's Profile: http://www.excelforum.com/member.php...o&userid=33046
> View this thread: http://www.excelforum.com/showthread...hreadid=528941
>