form auto email question

[vanwhyjr]

Hello Everyone,

New to the forum.
I have been asked by the boss to set up a sheet that has a list of our active jobs. One of the columns will have the customers email and one will have a column with a drag down list (In-process, on hold, complete).
I would like the spreadsheet to automatically send a customer survey to the email in the row that is changed to complete.
Is that something possible with a Macro? I have some basic macro knowledge. Not real good with the VBA code.

Thank you for any recommendations.

The nube!
George V.

 

[vanwhyjr]

Here is what I get.

 

[mumps]

Since sending emails automatically can pose a security risk, your system may be disabling the "send" command. You may have to use "Display" and then send the email manually.

 

[vanwhyjr]

ok, I was thinking that as well. Display will be a big improvement over what we have been doing. Thank you for all the assistance.

 

[mumps]

You are very welcome.