Using VBA to send email based on form response
Hi Jeff,
Excel can send e-mail (an account needs to be active on the box). I'm
not going to post the code here, look on the net/newsgroups/macro
recored.
I would make the follow suggestions.
I would ask the user to enter an e-mail, and then use this. It would
make the code a whole lot easier, and i think it is a better way to go
anyway, as the user can control which e-mail account is to be used.
If you use the out look address book, you'll have to code to get the
address based on the name, and say there are 2 folks with the same
name, the user may need to look it up etc, he may need to do this
anyway.
If i was you i'd ask them for there e-mail address and be done with
it, sometimes it's just better to keep things simple!
anyway
good luck
Ross
|