asked on

Auto Email Excel Form MS Excel 2003

When clicking this buton, I want to do the following.

See the attacked file:

Validation: I want the Name and Address fields to be filled out. If the name and address fields are left NULL, I want a message to pop up saying that the form cannot be sent until these fields are filled out.

Once these field are completed, upon clicking the Submit button,
I want the form to automically go to a desginated email address..not open in dialog mode. For this task, lets says its test@email.com.
After the email is sent, I want a the option to Close and Save the form to appear with a yes or no option.

Any takers? :)
Email-Form.xls

ASKER CERTIFIED SOLUTION

game-master

membership

This solution is only available to members.

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

Start Free Trial

Patrick Matthews

Hello game-master,

With respect, posting your email address in the clear like that is a very bad idea. I suggest you use the 'request
attention' link to ask the Mods to obfuscate it.

Regards,

Patrick

ctownsen80

ASKER

When I input the code and fill out all of the fields, I clicked the button. When I do that the following message pops up: "Unable to Send the File. Unexpected Error Occured !"

After filling in all of the fields and clicking "Submit" the email should autosend to the recipient.

Thanks,
Chris

game-master

good morning!

patrick,

Thanks for the concern... my fault...

game-master