Selecting Email Contacts Address To Sending Email From Form

[Guest]

I'm working with a database, where a user complete a form and upon
submitting, a email notice is sent to several people. Those people are
hardcoded into the form. Is it possible before the user submits the
information, that can choose who to send the form to using their Outlook
contacts? Is there a way to link their contacts to the form and database, so
they can select who is going to received the information? Is there way so
they can select multiple contacts, if required?

 

[Guest]

This is a little quirky but very affective. You could just click on the To:
field in the email before sending. But here is another way. It works for me
on my machine but I am not sure how it will work if deployed.

Linking to you Outlook Contacts folder
File/get external data/Link tables
change files of type to Outlook
expand address book folder
select contacts subfolder
Open the linked table contacts and you will see all the contacts and email
addresses.

In a form
Add a combo box using the email addresses from the contacts linked table
Add an unbound text box. name it "EmailAdd"

In the after update event of you combo box put
Me.emailadd = Me.Comboboxname & ";" & vbCrLf & Me.Emailadd

Every time you click on the combo box and select an email address the
unbound text box will be updated with the contents of what's in it and the
new email address just selected.

Use the "Emailadd" field in the To: field in your email.

If you need more inf respond.

 

[Guest]

I did a test on another machine and the contacts table needs to be on the
front end and linked to each users contacts(If you want to see that users
contacts). Unless you created a global contacts table for everyone to use.

I use Access 2000, Outlook 2000 and POP 3 mail server.

 

[Guest]

Thanks for the quick response. I'll give it a try.