A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Automating folder export from Outlook to Access



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old March 4th 06, 02:47 PM posted to microsoft.public.outlook.program_vba
[email protected]
external usenet poster
 
Posts: 1
Default Automating folder export from Outlook to Access

I have a custom Access database that is a bulk mailing program for my
small business to send emails to my customers (not spam!). Before
sending mail, I export a folder in Outlook to an Access MDB file and
then open the custom database which runs a VB subroutine that iterates
through the exported MDB file and loads in new Senders of email. I'd
like to automate this further by eliminating the need to open Outlook
and export the folder first.

I tried reading from the Outlook PST file directly, but this doesn't
access to the Sender field which is available in the exported MDB file.
So, I'd like a script or some other method to automate the export from
within Access. In other words, open Access and click a button which
first exports the folder in Outlook to the MDB file and then runs the
function which reads through the emails in the MDB file.


Is it possible to automate exporting the Outlook folder from within
Access?


Thanks,
Rich

Ads
  #2  
Old March 6th 06, 07:15 PM posted to microsoft.public.outlook.program_vba
Eric Legault [MVP - Outlook]
external usenet poster
 
Posts: 830
Default Automating folder export from Outlook to Access

Instead of importing your Outlook data into Access, have you tried linking
the folders directly from Access? When you use the "Link Tables" feature,
you have Outlook() and Exchange() as possible selections in the 'Files of
Type' combo box. However, you may find that these linked tables (even
imported Outlook folders) do not list the SMTP address for e-mail senders.
If you need the addresses, then you'd most definitely need to code the import
and it makes sense to code this in Access rather than Outlook.

Automating Outlook from a Visual Basic Applications:
http://msdn.microsoft.com/library/en...asp?frame=true

--
Eric Legault (Outlook MVP, MCDBA, old school WOSA MCSD, B.A.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


" wrote:

I have a custom Access database that is a bulk mailing program for my
small business to send emails to my customers (not spam!). Before
sending mail, I export a folder in Outlook to an Access MDB file and
then open the custom database which runs a VB subroutine that iterates
through the exported MDB file and loads in new Senders of email. I'd
like to automate this further by eliminating the need to open Outlook
and export the folder first.

I tried reading from the Outlook PST file directly, but this doesn't
access to the Sender field which is available in the exported MDB file.
So, I'd like a script or some other method to automate the export from
within Access. In other words, open Access and click a button which
first exports the folder in Outlook to the MDB file and then runs the
function which reads through the emails in the MDB file.


Is it possible to automate exporting the Outlook folder from within
Access?


Thanks,
Rich


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
export pst folder Question for Brian Tillman Outlook - General Queries 2 February 14th 06 08:41 PM
Automating Profile Creation for Outlook 2000 David Outlook - Installation 2 January 27th 06 01:33 AM
export a public contact folder to excel? mjb Outlook - Using Contacts 1 January 20th 06 06:44 AM
Can't Access OE File Folder When Importing into Outlook cnysteve Outlook - Installation 2 January 14th 06 08:26 PM
Why can't outlook 2003 access specified folder location for calend morrocos Outlook - Calandaring 0 January 10th 06 03:41 PM


All times are GMT +1. The time now is 08:46 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-2025 Outlook Banter.
The comments are property of their posters.