Exporting to Outlook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2003.

I am new to VBA and would appriciate any help. I am trying to create an
basic order entry system in Access that the user (me) can input customer
contact information and job address information. The form will have control
buttons that will fired and do the following: 1. create a new contact in
Outlook 2002 using information from the current record. 2) Add the job
information to my Outlook schedule 3) Create a folder in My Documents and
name it using the Job Number and Job Address, Job City and Job State (ie
0000099 - 999 Main Street, Anytown, PA). 4) Create a Folder in Outlook and
include a list of tasks (please note that each job has the same tasks so a
template my work).

I know this is a lot...well at least for me.

Thank You!!!
 
Ron Kuntz said:
I am using Access 2003.

I am new to VBA and would appriciate any help. I am trying to create an
basic order entry system in Access that the user (me) can input customer
contact information and job address information. The form will have control
buttons that will fired and do the following: 1. create a new contact in
Outlook 2002 using information from the current record. 2) Add the job
information to my Outlook schedule 3) Create a folder in My Documents and
name it using the Job Number and Job Address, Job City and Job State (ie
0000099 - 999 Main Street, Anytown, PA). 4) Create a Folder in Outlook and
include a list of tasks (please note that each job has the same tasks so a
template my work).

I know this is a lot...well at least for me.

Thank You!!!
Click to expand...

It sounds to me as though you are trying to create an Access front-end that
uses Outlook as the database engine. I'm no expert on Outlook, but
attempting such extensive integration of two very different products doesn't
sound sensible to me. Perhaps you could ask in an Outlook newsgroup for
someone to advise you on doing your entire project in Outlook.
 
Hi Ron,

These links should help you get started:

Accessing Microsoft Exchange and Outlook Data Using Visual Basic
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnout98/html/olexcoutlk.asp

Sample Procedure to Link a Microsoft Outlook Folder
http://support.microsoft.com/?id=209946

How to programmatically export Outlook items to Access
http://support.microsoft.com/?id=290792
http://support.microsoft.com/?id=253794

OL2000: How to Programmatically Import Outlook Items from Microsoft
Access
http://support.microsoft.com/?id=208232

Using Automation in Microsoft Office Access 2003 to Work with Microsoft
Office Outlook 2003
http://msdn.microsoft.com/library/d...ry/en-us/dno2k3ta/html/odc_ac_olauto.asp?_r=1

Finally, the best single place I know for information about outlook is
http://www.slipstick.com
 
Back
Top