email from access

[Jamie]

-- This is probably a simple procedure but my access knowledge is limited.
How do i open outlook on a new email with the address already in the to field
by clicking on an email address in a form
Jamie

 

[Albert D. Kallal]

You can go:

application.FollowHyperlink "mailto: (e-mail address removed) ?subject= overdue bill"

So, if you had a field on the form that was a email address, then


application.FollowHyperlink "mailto: " & me!Email & " ?subject= overdue
bill"

the above will launch your default email client with the email, and also the
subject in place....

 

[Jamie]

Thanks