Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 478
  • Last Modified:

Attach File to Email Created With SendObject

How do you attach a file to an email created using SendObject command? File was created in an earlier "step" and has to be named with a .csv extension. Which is what's preventing me from using file attachment feature of SendObject (as far as I know, that's not an extension "supported" by SendObject).

Or if know of another way using VB code to achieve same results, I'm open to that.

1 Solution
SendObject can only attach a database object (such as a table or query) you simply cannot attach a file. Period.

To send attachements with emails you will need to use Office Automation to create an Outlook object and send messages with that.
fredstaleyAuthor Commented:
Thank you VERY much!! Was EXACTLY the solution I was looking for.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now