I'm currently working on creating a vba that would send an email of the active workbook.
If possible, i need a button that says "Email Bid", and upon click to display a form that has a 'To:', 'From:', 'Subject:', and 'Message' box that will direct the workbook to its respective recipient.
Attached is something I've tried to accomplish.
Thank you very much in advance,
Cris
Here is the major part of the file....I changed a few things....
Naming the objects in your form. textbox1 is hard to remember so I changed it to txtTo and then txtFrom and so on....
You will have to change the smtp server object to your smtp server AND the from name must be valid user on the system....
another weird thing is the that this techique does NOT put an entry in the send items folders....so, give it a shot and let me know...
NOTE: I didn't notice that you are running 2003....there "MAY" be issue between 2010 (my version) and 2003---I hope not
Please Login or Register to view this content.
Last edited by judgeh59; 04-09-2015 at 12:50 PM. Reason: 2003 Issue
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks