Command Button/Form-Pulling email from field in a table

R

RecruiterI

I have created a form for business purposed. On the form I have contact
information from a combo box that as I type it in populates the managers name
from my table on managers. Also stored in the manager table is personal info
as well as their email address. Mind you the email address is just text in
the field.

I want to create a button on the form that once I put in the proper manager
as my contact I can hit a button and window opens in Outlook that has the
managers email address already displayed in the To: section. I have no need
of attaching other items from the database.

Please help, I'm about to go crazy. I have no visual basic experience.
 
D

DevalilaJohn

If you have no programming experience, you might be better off just having
the eMail address appear on your form, and then do a copy, switch to Outlook,
create a new note and paste.

The alternatives are to gain some level of VBA knowledge, hire a programmer
(contract of permanent) to do that work or find a friend who will help you
out. What you want to do isn't terribly difficult for someone who is
familiar with VBA
 
Top