File Save w/email prompt

[Merlin54k]

How can I set up an excel file to prompt you to email that particular file to a specific email address or to just save the file?

Any thoughts? Suggestions? Ideas?

Many thanks........

[Merlin54k]

What I need is for when the person using the file presses saves to be prompted with two options:

1) Outlook email starts with recipitient and that file attached

2) Just save

[Carim]

Hi,

Sending email with Outlook, I remember Express Click Yes ...
all details are available from Ron ...

http://www.rondebruin.nl/mail/prevent.htm

HTH
Carim

[VBA Noob]

Hi,

The attached link should help with the e-mail part of the code.

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

and this code should help to call the dialog box if the user clicks no

Please Login or Register  to view this content.

http://www.ozgrid.com/VBA/send-email.htm

or this link on e-mail might help
VBA Noob

[Merlin54k]

Carim you are my hero!

You placed me in a perfect neighborhood!!!

The web site you provided has exactly what I need as listed below:
http://www.rondebruin.nl/sendmail.htm

Many thanks!!!

Merlin

[VBA Noob]

Same site but my link I think (:

VBA Noob

[Merlin54k]

VBAN, you are right. Your posting was 100% of what I needed.

Carim you were close at 80%

Hope everyone had a great weekend!!!


Merlin

[VBA Noob]

Good thanks. Role on the next one

PS.

If Carim a Hero with 80% I must be a super hero then

VBA Noob

[Merlin54k]

=IF(Carim@80%,Hero,VBAN@100%="Superhero"2,0)


Peace!!!

[Carim]

It is always the same ...

VBA Noob gets better marks ...!!!

lol

Carim

[VBA Noob]

but less posts then carim (:

Bryan is top poster for 2006.

Carim top poster in 2007 ??

VBA Noob

[Carim]

VBA Noob ...

You know very well that ...

Quantity is NEVER a substitute for QUALITY ... !!!

Cheers
Carim

[VBA Noob]

Is that what your wife tells you