Multiple attachments with docmd.sendobject

Discussion in 'Access Macros' started by Russ, Feb 6, 2004.

  1. Russ

    Russ Guest

    Hi all

    I have a simple problem I'm using the docmd.sendobject to send a report as an rtf file attachment to email addresses ... It send the email fine ... But some times it will send Muliple attachments ie 3 rtf's that had quite different data on them.. This is not good.

    Does anyone know why ... It;s access 2000 on winxp pr

    Thanks in advance Russ
     
    Russ, Feb 6, 2004
    #1
    1. Advertisements

  2. I have a simple problem I'm using the docmd.sendobject to
    send a report as an rtf file attachment to email addresses ... It send the
    email fine ... But some times it will send Muliple attachments ie 3 rtf's that
    had quite different data on them.. This is not good.
    In order to attach multiple documents to an email message using VBA, you will
    need to implement some form of automation - the SendObject method only supports
    a single filename being passed as an argument. Depending on what email software
    is being used, you might be able to use Outlook automation or, if the email
    client software is not Outlook or may vary from workstation to workstation, you
    may need to use MAPI which is a little more complicated.

    See the following page at Tony Toews' web site for some information and links
    that might get you started:

    Microsoft Access Email FAQ
    http://www.granite.ab.ca/access/email.htm
     
    Bruce M. Thompson, Feb 6, 2004
    #2
    1. Advertisements

  3. Russ

    Russ Guest

    Hi Bruce

    Thanks for the reply.. My problem is that 'I am' getting multiple attachments being sent from time to time with different data on them...

    What I want is sendobject to only send the one attachment as it should do

    As you can imagine it doing my nut. because it should not screw up like this.

    Any ideas why it is doing it

    Thanks in advance Russ
     
    Russ, Feb 7, 2004
    #3
  4. Russ

    tambrocio Guest

    I do not know the answer to your problem, but I am in dire straits about a small problem with Access 97

    One of the things I am trying to do is to create an e-mail after certain actions have been done
    I need to talk with someone about this. Would you be able to help me
     
    tambrocio, Feb 7, 2004
    #4
  5. Thanks for the reply.. My problem is that 'I am' getting
    multiple attachments being sent from time to time with different data on them...
    Are you saying that you are getting multiple documents being attached to the
    same email message or that some of the messages have a document attached with
    different information in it when they should all be the same? With SendObject, I
    can only imagine the latter being the case. You must keep in mind that the same
    report must be "run" each time you use the SendObject method, so if the data or
    any criteria affecting the contents of the report changes during the course of
    generating your mailing, the data in the report is apt to change also.
     
    Bruce M. Thompson, Feb 9, 2004
    #5
  6. Russ

    konveyance Guest

    Russ wrote on 02/06/2004 10:36 ET
    He is obviously saying that he has ONE sendObject command in the macro
    and ONE attachment is expected. but MS-ACCESS is attaching multiple version o
    the query with varying results in them. and there are no criteria changes

    We are getting the same issue happening where I work
    It started yesterday. There were no changes to the beforehand
    Well, automatic updates is turned on. so obviously this is Microsoft messin
    up
    I have ONE SendObject command. One Macro and am expecting ONE attachment
    That's not what I get... and it varies... some macros setup like that get tw
    attachments, some get more. I expect more than just a run around answer lik
    that VP gave.
     
    konveyance, Aug 27, 2011
    #6
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.