VBA used to retrict emails to contacts

[wedd]

Hi, I would like to create a button an email to sender from an ms access 2007 form. In other words I would like to be able to only send emails to my contacts who are only stored in ms outlook via MS Access 2007. Have you any ideas of code I can use to achieve this?


Thanks for your contributions :friends:

[JP2112]

It depends on how you are sending the email.

If you are using the Outlook object model, then use the ItemSend Event to compare your recipients against your contact list after the message is sent.