In Excel I'm working on a macro that uses the ActiveWorkbook.SendMail feature and having some trouble finding the answers I'm looking for in the help file or in the archives.
*****
Question 1) Using the basic ActiveWorkbook.SendMail can you send the e-mail to different people depending on the input?
For Example if "11" is entered in Cell B3 is there a way to send the message to Joe Bob and Billy Bob, but if "21" is entered Send it to Jane Doe and John Doe?
I'm probably not looking for the correct phrase when I search...
*****
Question 2) Probably very similar answer to question 1. How do you make the subject line dynamic?
For Example: Thank your for XYZ where XYZ is the value of Cell A22?
*****
Any tips, hints, or points in a good direction are much appriciated. Thanks!
***************************************
Have a problem with my spelling or grammar? Please refer all complaints to my English teacher:
Ralphy "Me fail English? That's unpossible." Wiggum
*****
Question 1) Using the basic ActiveWorkbook.SendMail can you send the e-mail to different people depending on the input?
For Example if "11" is entered in Cell B3 is there a way to send the message to Joe Bob and Billy Bob, but if "21" is entered Send it to Jane Doe and John Doe?
I'm probably not looking for the correct phrase when I search...
*****
Question 2) Probably very similar answer to question 1. How do you make the subject line dynamic?
For Example: Thank your for XYZ where XYZ is the value of Cell A22?
*****
Any tips, hints, or points in a good direction are much appriciated. Thanks!
***************************************
Have a problem with my spelling or grammar? Please refer all complaints to my English teacher:
Ralphy "Me fail English? That's unpossible." Wiggum