Unanswered: Access 2007 CDO - Attachments ( Hard one )
Good day everyone,
This is my very first forum post anywhere!
I am building a database to manage my every day work and projects. I have been trying so hard to be able to send Emails from access using a gmail account. I was successful on sending emails (subject, body, cc, bcc, to ). As I come to the attachment part, I can't figure out any lead on how to do it.
I have my attachments stored in my database as fields and in some cases each attachment field holds more than one attachment. I was proactive on making all these attachments be part of subforms (3 in total) and my plan is to have a way to include these subforms on the main form I am sending emails from. Reason for that is because on that main form, all of my CDO, Email attributes get inputted.
Now the big, big challenge is : How do I get to the point where I can select any attachment(s) so that they get added to my .Addattachment.
The challenge mostly goes into
1-How to have a unique link to every attachment, given that access stores multiple attachments in a single field.
2-I have 3 fields and each one of them can have many attachments. I assume that each attachment will have a checkbox to it, which when checked my code will eventually know that it is to be included in the Email.
If someone is comfortable in helping me out, I can surely be more descriptive and post my code or snapshots of what I am trying to do.
Yes, I agree that attachment fields must have only 1 attachment per field. However, Access allows db end users to be able to add multiple attachments, which is why I figured that it is a not so bad practice. I just can't think of a way to make my code
1-ask the user to chose which attachments they wish to include in the email (Given that they exist in 3 single sub-forms inside my main form)
2-attach selected ones.
If you know how to do that, it would be great to help me out even by writing a psuedocode, this way I can research and get it done.