I have an Excel spreadsheet/form that once completed by user, they click a button to send an email to a help desk, with the form.
I would also want the person who is filling out the form to receive an email.
How can I add to the below code??
>>>>>>>>>>>>>>>>>>>>>>>
Please Login or Register to view this content.
Last edited by Leith Ross; 11-07-2007 at 12:53 AM.
Why would you want the sender to receive an email? You notify that it has been sent with the messagebox.
Also, you use the variable MyVar without declaring it or giving it a value:
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Hello Novice_704,
The recipients are added as an Array (see the code) with the names separated by commas. I have run the macro with only names that were in my address book. I haven't tested it using an email address in the Recipients.
If you have any problems with this code, please let me know.Please Login or Register to view this content.
Sincerely,
Leith Ross
All I am working on something similar.
I have a sheet that needs to be "approved" by multiple people.
What I need is this to be sent to one "approver" at a time.
Approvers name (recipient) are in cells B29, B31, B33 and B35. And sometimes not all 4 will be populated.
So I would create the sheet put the "recipients" in and hit the Button "ROUTE"
Then it will go to the firts person. There are drop downs that they will have to mark "approved" then hit a "ROUTE" button to send to the next person.
This macro goes to the first person and then sends it back to them.
Please help.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks