If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Collecting Data Via Email Form with Outlook 2003
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 |
#2
|
|||
|
|||
Collecting Data Via Email Form with Outlook 2003
The email feature is a feature of Outlook/Access 2007. I think your 2003
users will need to upgrade. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com wrote in message ... 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 |
#3
|
|||
|
|||
Collecting Data Via Email Form with Outlook 2003
-- Jeff C Live Well .. Be Happy In All You Do " wrote: 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 he 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 |
#4
|
|||
|
|||
Collecting Data Via Email Form with Outlook 2003
-- Jeff C Live Well .. Be Happy In All You Do " wrote: 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. Todd |
#5
|
|||
|
|||
Collecting Data Via Email Form with Outlook 2003
On Oct 30, 4:02*am, Jeff C wrote:
-- Jeff C Live Well .. Be Happy In All You Do " wrote: 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. Todd- Hide quoted text - - 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}") /============================================= |
Thread Tools | |
Display Modes | |
|
|