S
Sean
I want to create a UserForm in VBA that will present my sales person
(singular) with an input area for custom quotes. I will have a MultiPage
Element for different types of items that will be quoted on. I will also
have a ComboBox that I will populate with his contact list email addresses
from Outlook, or allow him to manually type a new address that is not in his
contact list. I want to add a CommandButton that when he clicks it, it will
create a new mail message inserting any number of the user form results and
automatically mail it to the recipient.
Any help with this project would be greatly appreciated. I know a little VBA
from working in CorelDRAW and MS Word, but am yet unfamiliar with Outlook
(mainly because I don't use Outlook myself).
I guess the main question is, I need to figure out the code for the command
button click. I'm pretty sure that I can figure out how to do the body part.
The hard part is going to be populating the ComboBox and the actual SendTo
code, which I'm sure is not as simple as "SendTo" or "MailTo".
--
______________________________
Thank you, Sean
Artist/Production Manager
Please visit us at www.oatesflag.com
502-267-8200
502-267-8246 fax
(singular) with an input area for custom quotes. I will have a MultiPage
Element for different types of items that will be quoted on. I will also
have a ComboBox that I will populate with his contact list email addresses
from Outlook, or allow him to manually type a new address that is not in his
contact list. I want to add a CommandButton that when he clicks it, it will
create a new mail message inserting any number of the user form results and
automatically mail it to the recipient.
Any help with this project would be greatly appreciated. I know a little VBA
from working in CorelDRAW and MS Word, but am yet unfamiliar with Outlook
(mainly because I don't use Outlook myself).
I guess the main question is, I need to figure out the code for the command
button click. I'm pretty sure that I can figure out how to do the body part.
The hard part is going to be populating the ComboBox and the actual SendTo
code, which I'm sure is not as simple as "SendTo" or "MailTo".
--
______________________________
Thank you, Sean
Artist/Production Manager
Please visit us at www.oatesflag.com
502-267-8200
502-267-8246 fax