talytech
12-15-2009, 11:07 AM
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:
ActiveWorkbook.SendMail theRecipient, theSub
ActiveWorkbook.SendMail theRecipient, theSub