Sending multiple attachments with CDO

[Dirk Vinke]

I use an Attachments dialog box in MS Access. It contains multiple attachments. I want to send all file attachments with CDO email.

Does anyone have a VBA code sample for me?

 

[Uncle Gizmo]

It contains multiple attachments.

I did an example for sending email via Gmail here:

http://msaccesshintsandtips.ning.com/profiles/blogs/sending-google-mail-gmail-from

I don't think it does multiples, but it may offer you a good start...

 

[Dirk Vinke]

Uncle Gizmo,

Thanks for your answer.
But in your example is just one attachment attached. I use an Access 2007 attachment field containing multiple files. I want to add all these files as attachments to the e-mail to send.