Copying Email Attachments into a Database Table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GLT - 11 Mar 2008 03:25 GMT

Hi,

I have a bunch of emails that have .txt file attachments attached to them.

I am trying to figure out how to copy the contents of these email
attachments (via vba) into an Access Database memo field.

Is there a way to reference the contents of these attachments?

Any help or pointers would be greatly appreciated...

Cheers,
GLT.

Reply to this Message

Milly Staples [MVP - Outlook] - 11 Mar 2008 07:13 GMT

You will have better luck getting an answer if you post to microsoft.public.outlook.programming_vba

Signature

Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact.

After furious head scratching, GLT asked:

| Hi,
|
[quoted text clipped - 10 lines]
| Cheers,
| GLT.

Reply to this Message

GLT - 11 Mar 2008 11:09 GMT

Hi Milly,

Thanks for your reply - I tried typing that address into my web browser but
the address cant be found - is it a google group?

> You will have better luck getting an answer if you post to microsoft.public.outlook.programming_vba
>
[quoted text clipped - 12 lines]
> | Cheers,
> | GLT.

Reply to this Message

John Blessing - 11 Mar 2008 11:22 GMT

> Hi,
>
[quoted text clipped - 10 lines]
> Cheers,
> GLT.

IME, Access database is not sufficiently robust to store large binary
objects.

And that is not just because our attachment stripper
(http://www.lbetoolbox.com/attachstrip.htm) can store the attachments as
files and put a link to them in the original message, but because it is I
think the most secure method.

Signature

John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses

http://www.room-booking-software.com - Schedule rooms & equipment
bookings for your meeting/class over the web.

http://www.lbetoolbox.com - Remove Duplicates from MS Outlook,
find/replace, send newsletters

http://www.repeatmail.com - Send individual emails, scheduled or
one-off, plain or html

Reply to this Message