Member Avatar for JaceDBN
JaceDBN 0 Newbie Poster

Hi,

I have a access 2007 database which makes use of attachments. I cannot seem to find a way to sent the attachments by e-mail.

My table structure is simular to:

ID: Autonumber
Att: Attachment
Send: Yes/No

Eg:

ID Attachment Send
1 xyz Yes
2 xyz No
3 xyz Yes


If I run a query to filter only those that should be sent, thus only records 1 and 3 should be sent.

I want to be able to E-mail the attachments as attachments to a recipient,

If I use the sendobject meathod, it tablulates the query or table or form, but the attachment is not there, but is represented by a "1".

Is there any method that I can use to send the attachments as files, whether pdf, doc, xls or jpg?

  • 1 Contributor
  • 0 Replies
  • 63 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.