TechSpot

Sending an email from Access using data contained within queries/ tables

By cartera
Jun 22, 2011
Post New Reply
  1. I am trying to set up a database which on the click of a button can open outlook and have in it data from the database. So far i have managed to get it to open the e-mail with the data in but i am struggling to add more data. Here is my VB script below;

    After the 'Me.Description' field i would like to add more fields but when trying to do this using separators that i know i get a syntax error.
    Any help would be greatly appreciated and please forgive me but my knowledge of VB is fairly basic. The separator i have tried are '&', semi colons, commas and also below it on a different line.
    Many thanks,

    Alastair
     
  2. jobeard

    jobeard TS Ambassador Posts: 8,958   +587

    research the Outlook API, which has access to Outlook contents including
    Contacts, Calendar, and user Folders
     

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...