Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Dec 2001
    Location
    Houston
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    E-mail with attachment (A2K)

    I have no problem using SendObject to send an e-mail. Question is, is it possible to have it automatically attach a file? If so, how? I see nothing in any documentation or reference material that addresses this subject one way or another.

    Dale Napier

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,538
    Thanks
    0
    Thanked 23 Times in 23 Posts

    Re: E-mail with attachment (A2K)

    Do a search for .attachment in this forum. You will find some good tips in here.
    Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: E-mail with attachment (A2K)

    I have the same problem. I generally send email use sendobject because I have quite a few projects for clients who don't use Outlook. Now someone wants to send an attachment which is coming from outside the database.
    I don't believe that sendobject will handle this.

    From Pat's suggestion, I can see two options:
    * One solution is to use Outlook.
    * Another is to use vbSendMail.dll
    I am not sure which solution to use yet. I will try out the vbsendmail option first. From looking at this, I imagine that there is no sent mail kept. If I wanted to have this, I would have to program the storing of sent mail in the db.
    Regards
    John



  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: E-mail with attachment (A2K)

    I just remembered another thought I had about this.
    In my case the attachments are likely to be Word files with no graphics. I was wondering if you could program the db to import the Word file, generate a report from it, then use sendobject to send the report.?
    Regards
    John



Posting Permissions

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