themightyreds
Board Regular
- Joined
- May 3, 2007
- Messages
- 60
Hi all,
I have managed to create a UserForm using the great guide on Contextures. I now want to add an e-mail address to the form and then on a click of a command button and e-mail the contents of that entry to the recipient. I'm fine with the butons etc but have no idea about the VB for creating the e-mail and adding the e-mail address into the to box (Using Outlook 2003)....if at all possible. I have looked through the files but not quite found what I am after.
Context - An agent will call us and negotiate the price on a component. We complete the form to record the agreed rate and then bill accordingly. Due to some disputes over the vebal agreement we need to e-mail the the details to the agent and do not want to double enter the details into excel then Outlook.
Also how can I scroll through the existing details on the userform the same way I can on a standard form.
As always your expertise is greatly appreciated.
Matt
I have managed to create a UserForm using the great guide on Contextures. I now want to add an e-mail address to the form and then on a click of a command button and e-mail the contents of that entry to the recipient. I'm fine with the butons etc but have no idea about the VB for creating the e-mail and adding the e-mail address into the to box (Using Outlook 2003)....if at all possible. I have looked through the files but not quite found what I am after.
Context - An agent will call us and negotiate the price on a component. We complete the form to record the agreed rate and then bill accordingly. Due to some disputes over the vebal agreement we need to e-mail the the details to the agent and do not want to double enter the details into excel then Outlook.
Also how can I scroll through the existing details on the userform the same way I can on a standard form.
As always your expertise is greatly appreciated.
Matt
