Copying Email Attachments into a Database Table

[GLT]

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.

 

[Milly Staples [MVP - Outlook]]

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

--
Milly Staples [MVP - Outlook]

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

After furious head scratching, GLT asked:

| 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.

 

[GLT]

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?

 

[John Blessing]

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.

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.


--
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