|
- Subject: Re: Copy an Outlook Email through Access
- Author: Sue Mosher [MVP-Outlook]
- Date: 18 Apr 2008
- References: 1
This isn't a simple operation, because there's no easy way to present the data for the selection. You'd have to use the Outlook View Control, which has problems in Access 2007, or iterate the Inbox's Items collection and fill your own list box.
Once you figure out how you want to get over that hurdle, to copy a message to a local folder, you'd use the MailItem.SaveAs method.
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
"Peter" <Peter@discussions.microsoft.com> wrote in message news:FB10A15E-9E49-4886-9D12-69B36D703D26@microsoft.com...
> Hi, I am trying to manage some of my emails using a form in Access. So, what
> I need is to open my Access form, click a button, choose a message in my
> Outlook Inbox folder and copy it to a predefined folder on my computer. Does
> somebody know some piece of VBA code which can achieve this goal?
| 10 Apr 2008 | Copy an Outlook Email through Access | .Peter |
| 18 Apr 2008 |  Re: Copy an Outlook Email through Access | .Sue Mosher [MVP-Outlook] |
| 18 Apr 2008 |  Re: Copy an Outlook Email through Access | .Peter |
| 18 Apr 2008 | Re: Copy an Outlook Email through Access | .Sue Mosher [MVP-Outlook] |
All times are in (US) Eastern Daylight Time (GMT -4:00)