+ Reply to Thread
Results 1 to 13 of 13

File Save w/email prompt

  1. #1
    Forum Contributor
    Join Date
    06-07-2006
    Posts
    121

    Talking File Save w/email prompt

    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........

  2. #2
    Forum Contributor
    Join Date
    06-07-2006
    Posts
    121

    further description

    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

  3. #3
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    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

  4. #4
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    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
    Last edited by VBA Noob; 12-12-2006 at 05:04 PM.
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  5. #5
    Forum Contributor
    Join Date
    06-07-2006
    Posts
    121

    In the neighborhood.......

    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

  6. #6
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Same site but my link I think (:

    VBA Noob

  7. #7
    Forum Contributor
    Join Date
    06-07-2006
    Posts
    121

    Gracias!!!

    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

  8. #8
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Good thanks. Role on the next one

    PS.

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

    VBA Noob

  9. #9
    Forum Contributor
    Join Date
    06-07-2006
    Posts
    121

    Red face This looks right...........

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


    Peace!!!

  10. #10
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    It is always the same ...

    VBA Noob gets better marks ...!!!

    lol

    Carim

  11. #11
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    but less posts then carim (:

    Bryan is top poster for 2006.

    Carim top poster in 2007 ??

    VBA Noob

  12. #12
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    VBA Noob ...

    You know very well that ...

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

    Cheers
    Carim

  13. #13
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Is that what your wife tells you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1