PDA

View Full Version : Auto Reply Notification



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

geekgirlau
12-22-2009, 07:34 PM
Send Mail (in Excel 2007 at least!) has a return receipt parameter, so you could use


ActiveWorkbook.SendMail theRecipient, theSub, True


If you want to do anything more complicated though you'll need to refer to the Outlook object model rather than using SendMail.