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

ASKER CERTIFIED SOLUTION

Martin Liss

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Martin Liss

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.

Max Hersey

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.

Martin Liss

Are you saying that whenever Notify is changed to "Yes" that you want to send the email? And what about the changes I suggested?

Max Hersey

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."

Martin Liss

yes I like all the suggestions

So 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' topic

I posted that in the wrong thread.

Max Hersey

ASKER

"Dear employee12"

Martin Liss

Here's an update.

Max Hersey

ASKER

can you attach the new file.

Martin Liss

Sorry.
29131312a.xlsm

Max Hersey

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

Martin Liss

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Max Hersey

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