Sending PDF with Outlook email

[zplugger]

Have to working code that sends a workbook as PDF with outlook mail.I have a address book that it gets the name and email address from,problem is if
the person is not in address book I have problems. Is there a way to have a input box pop up to insert a email address if its not in main address book? Really
need to expert advice on this,not even sure if it can be done.
Thanks Z

Please Login or Register  to view this content.

[berlan]

Hi zplugger,

without going through the whole code in detail, I think what you are asking for is to add these lines (in red):

Please Login or Register  to view this content.

Cheers,
berlan

[zplugger]

OMG Berlan you are a Genius, works like a champ.Will run some more test tomorrow for any other bugs.

Thanks Z

[berlan]

Glad it worked, you're welcome!

[zplugger]

Morning All
Ran some test today and found a error. Everything works good except when you cancel the input box you get error.If I try and send a email without address in addressbook the
inputbox pops up and wants a email address.This is good if I know the address,but if I'm not sure of address I want to cancel and this is what I get.I guess want I need is if
I cancel just exit the sub?

Outlook Error.PNG
Thanks Z

[Vikas_Gautam]

You can use this line of code:-

after vEmailAddress = application.inputbox

[berlan]

Another example:

Please Login or Register  to view this content.

The line,

Please Login or Register  to view this content.

is the same as

Please Login or Register  to view this content.

Cheers,
berlan

[zplugger]

Real close but after I cancel it go's to my address book sheet.I want it to stay on the sheet I was on.The sheet I sent
the email from was proposal.

[zplugger]

Got, thanks guys for all the help on this.
Z

[berlan]

You're welcome! Thanks for the kind feedback and positive rep added!