![]() |
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 | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
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 |