Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Pulling Data from Outlook Email and Push to Access (http://www.outlookbanter.com/outlook-vba/77162-pulling-data-outlook-email-push.html)

Shellie August 18th 08 06:58 PM

Pulling Data from Outlook Email and Push to Access
 
I'm using Outlook 2003and need to run a script that pulls information from
received emails and then push data from the emails to an Access 2003
database. All emails will have set format with set elements that can be
keyed identified easily.

I am assuming that a macro needs to be built using Outlook/Macro/VBA;
however, that is all that I know so far. I have the Access database created,
but not the macro. I have searched for script examples and any other type of
help, but I cannot find anything close to what I need to do.

Any help that can be provided is greatly appreciated.



Ken Slovak - [MVP - Outlook] August 19th 08 02:43 PM

Pulling Data from Outlook Email and Push to Access
 
Have you looked at the database coding examples for Access at
www.outlookcode.com?

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Shellie" wrote in message
...
I'm using Outlook 2003and need to run a script that pulls information from
received emails and then push data from the emails to an Access 2003
database. All emails will have set format with set elements that can be
keyed identified easily.

I am assuming that a macro needs to be built using Outlook/Macro/VBA;
however, that is all that I know so far. I have the Access database
created,
but not the macro. I have searched for script examples and any other type
of
help, but I cannot find anything close to what I need to do.

Any help that can be provided is greatly appreciated.




Shellie August 19th 08 05:47 PM

Pulling Data from Outlook Email and Push to Access
 
Ken,

Thank you for responding in my plea for help.

Yes, I have gone to the site, but I was a bit overwhelmed. After over an
hour of perusing through the site, I ended up with more questions than
answers.

I have no experience with Outlook programming. I have a little experience
in VB. However, my office is desperate for an automated solution for this
task. They are currently keying all of the information in by hand once the
email is received.

Shellie


"Ken Slovak - [MVP - Outlook]" wrote:

Have you looked at the database coding examples for Access at
www.outlookcode.com?

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Shellie" wrote in message
...
I'm using Outlook 2003and need to run a script that pulls information from
received emails and then push data from the emails to an Access 2003
database. All emails will have set format with set elements that can be
keyed identified easily.

I am assuming that a macro needs to be built using Outlook/Macro/VBA;
however, that is all that I know so far. I have the Access database
created,
but not the macro. I have searched for script examples and any other type
of
help, but I cannot find anything close to what I need to do.

Any help that can be provided is greatly appreciated.





Ken Slovak - [MVP - Outlook] August 20th 08 03:05 PM

Pulling Data from Outlook Email and Push to Access
 
If what you found is beyond your experience then you can try putting things
together as best you can and post what you have in this group where others
might be able to help. Otherwise your company may just need to hire a
developer to do the code for you.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Shellie" wrote in message
...
Ken,

Thank you for responding in my plea for help.

Yes, I have gone to the site, but I was a bit overwhelmed. After over an
hour of perusing through the site, I ended up with more questions than
answers.

I have no experience with Outlook programming. I have a little experience
in VB. However, my office is desperate for an automated solution for this
task. They are currently keying all of the information in by hand once
the
email is received.

Shellie



Shellie August 21st 08 02:06 PM

Pulling Data from Outlook Email and Push to Access
 
Ken,

Thank you for responding to my post.

Shellie

"Ken Slovak - [MVP - Outlook]" wrote:

If what you found is beyond your experience then you can try putting things
together as best you can and post what you have in this group where others
might be able to help. Otherwise your company may just need to hire a
developer to do the code for you.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Shellie" wrote in message
...
Ken,

Thank you for responding in my plea for help.

Yes, I have gone to the site, but I was a bit overwhelmed. After over an
hour of perusing through the site, I ended up with more questions than
answers.

I have no experience with Outlook programming. I have a little experience
in VB. However, my office is desperate for an automated solution for this
task. They are currently keying all of the information in by hand once
the
email is received.

Shellie





All times are GMT +1. The time now is 05:06 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com