How to mail a range of worksheet as PDF attachment

[chrismeeky]

I want to be able to mail part of a workseet as PDF. The range to be mailed as PDF is from D8:J25.
Subject is located on A1
"TO" is located on B1
"CC" on C1
Body on D1

File name on E1.

When I click on the Send mail button, I do not want outlook's prompt to allow email sending. In otherwords, I'd like the emai to be sent without giving the user the option to cancel it.


Is it possible for the email to be delivered on Internet re-connection in case of network failure?
Thanks!

[sintek]

Something like this...

Please Login or Register  to view this content.

Is it possible for the email to be delivered on Internet re-connection in case of network failure?

Not to sure on this...

[chrismeeky]

Thanks @ sintek. It worked! Is it possible to modify the code to send email without outlook cause it seems to be very sluggish?

[sintek]

modify the code to send email without outlook

What you mean...What Email provider do you want to use...

Add

Please Login or Register  to view this content.

at beginning of code and

Please Login or Register  to view this content.

at end...Should speed up

[chrismeeky]

What you mean...What Email provider do you want to use...

I learned that CDO is an alternative

[sintek]

See link...I have used before...very easy to adapt code...
http://www.exceltrainingvideos.com/t...automatically/

[chrismeeky]

@ sintek the code returns this error: User-defined type not defined and highlights this code>> Dim myMail As CDO.Message

[bakerman2]

Set Reference to Microsoft CDO for Windows 2000 Library

[chrismeeky]

Thanks to @ sintek and @ bakerman2. After I set the reference, the code is running smoothly

[bakerman2]

Glad to help and thanks for rep+.