Open New Email From Access Form
Create a new email message from a Microsoft Access form with a simple click of a button. This downloadable Access example provides you with the code needed to open up an Outlook email and populate the address field with the data from a table field in your database.You can further modify this example to populate the other components of the email message, such as Subject, CC list, and even the body of the email. These additional features are demonstrated in ourAccess Send Email example.
This download demo contains the simplest method for opening up an Outlook email – the DoCmd.SendObject Visual Basic command. We’ve added a little trick to the send object command in that we use the NoObject option to not really send anything to Outlook. The result is an empty email with the To: field populated from the database. Get started by downloading our Open New Email From Access Form downloadable Microsoft Access example.