Consulting

Results 1 to 2 of 2

Thread: Auto Reply Notification

  1. #1

    Auto Reply Notification

    I apologize in advance, but I posted this question to the wrong forum I believe.

    I have a spreadsheet that has a button on it that sends an email attachment of the worksheet when the user clicks on it. Is there away to program an auto reply back to the sender from within Excel once the recipient receives the worksheet in their inbox? For example: In my code, is there another statement that I can include that will send a message back to the sender or does that have to be setup in Outlook? Here's my code:



    Code:
    ActiveWorkbook.SendMail theRecipient, theSub

  2. #2
    VBAX Expert JP2112's Avatar
    Joined
    Oct 2008
    Location
    Astoria, NY
    Posts
    590
    Location
    What about the third parameter of SendMail, ReturnReceipt, which you would set to True to request a return receipt?
    Regards,
    JP

    Read the FAQ
    Getting free help on the web
    My website
    Please use [vba][/vba] tags when posting code

Posting Permissions

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