Thanks for anwering my post.
Unfortunately, It does work. The value of the listbox is not paste into the
"JP" <email@example.com> wrote in message
In your listbox double click event:
Then somewhere else in your form class:
Function CreateEmail(emailAddr As String)
Dim Msg As Outlook.MailItem
Set Msg = Application.CreateItem(olMailItem)
Msg.To = emailAddr
Customize as needed.
On Mar 16, 9:54 am, "Bre-x" <cholot...@hotmail.com> wrote:
> I need the VBA code to put on my listbox double click event.
> So that the address will be paste on the "To" box on the new email form.
> "Michael Bauer " <m...@mvps.org> wrote in
> > What's your question?
> > > > Best regards
> > Michael Bauer
> > >
> > Am Mon, 15 Mar 2010 15:25:50 -0600 schrieb Bre-x:
> >> I have create a user form data connect to an ms access db
> >> My ListBox1 shows email address.
> >> I would like to double click on a record so that the email value
> >> will be paste on my New Email's To field.
> >> Thank you all
> >> Bre-x-