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: 13,446   +324

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


Add New Comment

TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...


Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.