Great community. Great ideas.
Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.
November 6th, 2012, 08:56 AM
VB code to get data from outlook to access
I'm new to develope databases in Access. I would be grateful if somebody could help me out with a little problem I have. I am using Access 2010 64bit and Outlook 2010.
The data I want to get in my database (only for use in my computer, no internet etc) has this format in the mail I recive in Outlook:
X Y 06/11, Z nr
X Y 06/11, Z nr
It differes how many rows of data I get in each mail.
X=1,2 or 3 words
06/11 date (I want to transform it to swedish date format yyyy-mm-dd)
Z=1 word (always same word)
I want to get:
X to table one field A
Y to table two field A
yyyy-mm-dd to table two field B
Automatically calculate day of week to table two field C
Z do nothing
nr to table three field A
somehow register that the mail has been stored in the database to avoid duplicates.
By RSS_News_User in forum Technology News
Last Post: May 24th, 2010, 07:00 PM
By chandru_india in forum Microsoft Access Help
Last Post: January 6th, 2010, 01:23 AM
By DevAdmin in forum Development Articles
Last Post: October 3rd, 2006, 08:00 AM
By jcordiera in forum .NET Development
Last Post: October 5th, 2004, 08:42 AM
By kpsga in forum ASP Free Lounge
Last Post: September 23rd, 2003, 11:23 AM