Max Hersey
asked on
Automatic email via Excel
On the AFL tab, for the notify column, Is it possible to have it automatically send an email via MS Outlook? The email will be on the staff tab and each staff will have their own email. I was going to make a mock email for each staff but the column seems to be locked somehow. So once all the information in the row is filled out (besides the confirmation column). a button will appear in the Notify column for that row. When you click it, it will send a generic email That will say:
(Column G cell),
Can you work a(n) (Column D cell) on (Column B cell) at (Column C cell)? This will bring your hours up to (Column I cell) before adjustments.
Please let me know at your earliest convenience.
Jan-1-2019--Autosaved-.xlsm
(Column G cell),
Can you work a(n) (Column D cell) on (Column B cell) at (Column C cell)? This will bring your hours up to (Column I cell) before adjustments.
Please let me know at your earliest convenience.
Jan-1-2019--Autosaved-.xlsm
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
I should also have mentioned that as it is now, the email will be displayed on your PC rather than actually sent. To change that, find the SendEmail sub in Module1 and change .display to .send.
ASKER
This is fantastic! Is there a way to make it so that the email sends before the confirmation is yes because the response from the email will be the confirmation. So the email should send once all the cells to the left of the notify column are filled.
Are you saying that whenever Notify is changed to "Yes" that you want to send the email? And what about the changes I suggested?
ASKER
Yes, before the confirmation is filled the email should be sent. And yes I like all the suggestions that you had. I just wasn't sure about "BTW, I removed your 'C' topic since this has nothing to do with the C programming language."
yes I like all the suggestionsSo should the greeting (I incorrectly said salutation before) be "employee12," or "Dear employee12," or "Dear colleague," or no greeting at all?
I removed your 'C' topicI posted that in the wrong thread.
ASKER
"Dear employee12"
Here's an update.
ASKER
can you attach the new file.
Sorry.
29131312a.xlsm
29131312a.xlsm
ASKER
that looks great! Any chance that the date can be in long date format? Also, is it possible to use "Yes" and "No" voting buttons for staff to respond with? If that is not possible then no worries.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Oh very cool! you can use my email to test the buttons if you would like?
I was thinking that we could put my email address in every row of the email column on the staff tab. that way we dont have to change any of your coding, but we can see if it is pulling the email via there and also check to see if the buttons work
I was thinking that we could put my email address in every row of the email column on the staff tab. that way we dont have to change any of your coding, but we can see if it is pulling the email via there and also check to see if the buttons work