Go to Top

How to create Outlook message from Access

Note: If you need to send out a massive amount of emails this code is not for you, instead we recommend FMS’s Total Access Emailer.

Note 2: You must add a reference to Outlook in your Access project in order for this code to work, if you need an alternate version that does not require it then look at the next section of this post below:

ADVERTISING
ACCESS SAFETY AND TRAINING DATABASE

Code without a reference to Outlook:

About Juan Soto

Juan Soto is a Senior Access Developer at IT Impact Inc. and a Microsoft Access MVP. He specializes in Access with SQL Server databases. His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, stable and efficient environment with SQL Server. He's a frequent speaker at Access user groups nationwide and recently spoke at the Orange County SQL Saturday # 73. If you wish to have Juan speak at your next group meeting you can contact him here.

2 Responses to "How to create Outlook message from Access"

  • John
    September 10, 2012 - 6:49 pm Reply

    If the e-mail is simple then its much lighter to use CDO.sys
    You can check it first if u have it in ur system and use it to send simple e-mails.

    • Juan Soto
      September 11, 2012 - 11:43 pm Reply

      Thanks for sharing!

Leave a Reply

Your email address will not be published. Required fields are marked *

 

Contact Us
  • This field is for validation purposes and should be left unchanged.