How to transfer E-Mail-Adress from UserForm to message header/to-field?

  • Thread starter Thread starter Steffen Grellmann
  • Start date Start date
S

Steffen Grellmann

Hi newsgroup,

what I have so far is a small Outlook / vba-form which is integrated
in my Outlook and which is connected to our database server where all
our contacts are stored.

But how can I deliver/transfer an e-mail-adress from that UserForm
right to the "To:" field in the message header?

Any suggestions are welcome.

Kind regards,

Steffen
 
Presumably the email address appears in some control on the userform? If so and if you've already created the MailItem, it's simply a matter of setting the To property to the control's value:

myMailItem.To = Form1.MyControl.Value
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top