Collecting Data Via Email Form with Outlook 2003

[tshillam]

I have an Access 2003 database with a simple table. Using Office
Outlook 2007 I created an email form (saved as a .msg file). When I
get messages from Outlook 07 users, messages automatically process as
configured. However, if I get an email from an Outlook 03 user, the
message moves to the data processing folder, but it does not get
processed automatically. Anyone know how to get the Outlook 03
messages to process automatically?

Thanks,

Todd

 

[Arvin Meyer [MVP]]

The email feature is a feature of Outlook/Access 2007. I think your 2003
users will need to upgrade.

 

[Jeff C]

--
Jeff C
Live Well .. Be Happy In All You Do

I have an Access 2003 database with a simple table. Using Office
Outlook 2007 I created an email form (saved as a .msg file). When I
get messages from Outlook 07 users, messages automatically process as
configured. However, if I get an email from an Outlook 03 user, the
message moves to the data processing folder, but it does not get
processed automatically. Anyone know how to get the Outlook 03
messages to process automatically?

Thanks,

Todd

Arvin is correct in that version 2007 has a built in intuitive interface to
collect and process data. It would be easiest to move up to 2007, however
there are ways with VBA to collect data from Outlook 2003. Check out and
research OutlookCode.com starting here:

Sue Mosher 07-Sep-2006 06:27
Yes. These pages should help you get started:

http://www.outlookcode.com/d/vbabasics.htm
http://www.outlookcode.com/d/code/zaphtml.htm
http://www.outlookcode.com/codedetail.aspx?id=89
http://www.outlookcode.com/d/customimport.htm

 

[Jeff C]

--
Jeff C
Live Well .. Be Happy In All You Do

I have an Access 2003 database with a simple table. Using Office
Outlook 2007 I created an email form (saved as a .msg file). When I
get messages from Outlook 07 users, messages automatically process as
configured. However, if I get an email from an Outlook 03 user, the
message moves to the data processing folder, but it does not get
processed automatically. Anyone know how to get the Outlook 03
messages to process automatically?

Thanks,

Sorry - forgot another method. In an Access Database go to file-get
external data-link-choose Exchange

You will link to your Outlook inbox. Once you have the link established you
can built queries with the data. Once you locate the message field you can
append the data to a new table. You will probably need to build additional
queries to parse the text of the message the way you want but it is do-able.
Place your action queries into a macro and schedule you macro to run daily
and you can collect the data.

 

[tshillam]

--
Jeff C
Live Well .. Be Happy In All You Do




Sorry - forgot another method.  In an Access Database go to file-get
external data-link-choose Exchange

You will link to your Outlook inbox.  Once you have the link established you
can built queries with the data.  Once you locate the message field youcan
append the data to a new table.  You will probably need to build additional
queries to parse the text of the message the way you want but it is do-able.  
Place your action queries into a macro and schedule you macro to run daily
and you can collect the data.






- Show quoted text -

My workaround will be a simple approach. Using a developer tool,
called Auto-It (www.autoitscript.com), I will right a function to
perform the same process a user would perform upon reciept of a 2003
message to manually export to Access.

Basically, I will create an email form specifically for 2003 OUtlook
users and direct to an Outlook folder that is different than 2007
users. Using a mail rule, I will run a script (.exe) upon reciept of
the 2003 message. This script will use sendkeys() method to do all the
clicking to make the process autonomous (as the old adage goes...where
there's a will, there's a way). Here's the initial Auto-It script:

/==========================================
WinActivate("Microsoft Outlook", "")

Send("!g")

Sleep (500)

Send("!m")

Sleep (500)


Send("+{F10}")

/=============================================