Access "link table" to Microsoft Outlook

[Craig]

Hi folks,
I like the idea of being able to link an Access database to Microsoft
Outlook, but I'm wondering:

1.) If I do this, what happens to the e-mail attachments (I'll bet they
get dropped)? If so...

2.) Is there any way to "strip" the attachment, and save it to a
pre-designated location?

Thank you,
Craig

[pietlinden]

Craig wrote:

Hi folks,
I like the idea of being able to link an Access database to Microsoft
Outlook, but I'm wondering:

1.) If I do this, what happens to the e-mail attachments (I'll bet they
get dropped)? If so...

2.) Is there any way to "strip" the attachment, and save it to a
pre-designated location?

Thank you,
Craig

Access doesn't actually do anything to your Outlook containers, it just
reads the contents. There's no need to strip the attachments or
anything else. You can if you want, but none of it is necessary.

[Craig]

Thank you, Pietlin.

Is there any way, that you're aware of, to "programatically" (I assume
by VBScript) strip off the attachment and store it somewhere else (that
can be backed up, etc.).

Craig
[e-mail] wrote:

Craig wrote:

Hi folks,
I like the idea of being able to link an Access database to Microsoft
Outlook, but I'm wondering:

1.) If I do this, what happens to the e-mail attachments (I'll bet they
get dropped)? If so...

2.) Is there any way to "strip" the attachment, and save it to a
pre-designated location?

Thank you,
Craig

Access doesn't actually do anything to your Outlook containers, it just
reads the contents. There's no need to strip the attachments or
anything else. You can if you want, but none of it is necessary.

[Terry Kreft]

Why would you use VBScript if your already working in Access, use VBA to do
this.
--

Terry Kreft
"Craig" <cr***********@gmail.comwrote in message
news:11**********************@s13g2000cwa.googlegr oups.com...

Thank you, Pietlin.

Is there any way, that you're aware of, to "programatically" (I assume
by VBScript) strip off the attachment and store it somewhere else (that
can be backed up, etc.).

Craig
[e-mail] wrote:

Craig wrote:

Hi folks,
I like the idea of being able to link an Access database to Microsoft
Outlook, but I'm wondering:
>
1.) If I do this, what happens to the e-mail attachments (I'll bet

they

get dropped)? If so...
>
2.) Is there any way to "strip" the attachment, and save it to a
pre-designated location?
>
Thank you,
Craig

Access doesn't actually do anything to your Outlook containers, it just
reads the contents. There's no need to strip the attachments or
anything else. You can if you want, but none of it is necessary.

[Craig]

Oh, right. Duh.

Have you seen any examples of how this might be done using VBA?

Craig
Terry Kreft wrote:

Why would you use VBScript if your already working in Access, use VBA to do
this.
--

Terry Kreft
"Craig" <cr***********@gmail.comwrote in message
news:11**********************@s13g2000cwa.googlegr oups.com...

Thank you, Pietlin.

Is there any way, that you're aware of, to "programatically" (I assume
by VBScript) strip off the attachment and store it somewhere else (that
can be backed up, etc.).

Craig
[e-mail] wrote:

Craig wrote:
Hi folks,
I like the idea of being able to link an Access database to Microsoft
Outlook, but I'm wondering:

1.) If I do this, what happens to the e-mail attachments (I'll bet

they

get dropped)? If so...

2.) Is there any way to "strip" the attachment, and save it to a
pre-designated location?

Thank you,
Craig
>
Access doesn't actually do anything to your Outlook containers, it just
reads the contents. There's no need to strip the attachments or
anything else. You can if you want, but none of it is necessary.

[pietlinden]

did you try searching the NG? In all seriousness, there's a ridiculous
amount of code here that's free for the taking. if it doesn't work for
you, feel free to adapt it so it does...

http://groups.google.com/group/micro...9ea0c416cb98d5