Results 1 to 2 of 2
  1. #1
    Join Date
    May 2009
    Posts
    29

    Unanswered: Access CDO Mail Message Attachement Issue

    Hello All,

    I have been using CDO to send mass emails out to a group of people based on tables of contacts.

    What I need to do now is include 3 different File Attachements.

    I know that the VB is as follows:
    objMessage.AddAttachment "Attachment"

    What I need to figure out is how to add a file that is stored in a table.

    I have a table called "Attachements" There are 2 Columns and 3 rows

    Columns = FileID and File
    FileID has the following Row names:
    UserGUide
    Template
    Bulletin

    What I want to do is add the File when the FileID = UserGuide for the first attachement.

    I thought doing a SELECT Command would work, but its erroring out.

    I tried
    ("SELECT * FROM Attachments WHERE FileID= '" & UserGuide & "'")

    But that is not working.


    Any thoughts on how to reference a File stored in a table as an attachement?

    Many Thanks!

  2. #2
    Join Date
    Jul 2004
    Location
    South Dakota
    Posts
    267
    Never tried actually storing the file in a table. You might need to save the file to the hard drive and then pass the path to the AddAttachment method.

    C

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •