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

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