Email Excel file from Access - ADO DAO RDO RDS

This is a discussion on Email Excel file from Access - ADO DAO RDO RDS ; I have an Access 2003 application that creates data and writes it to specific cells in an existing Excel spreadsheet. (I got the code to do that from other posts in this forum - work GREAT!) Now, I want to ...

+ Reply to Thread
Results 1 to 4 of 4

Email Excel file from Access

  1. Default Email Excel file from Access

    I have an Access 2003 application that creates data and writes it to specific
    cells in an existing Excel spreadsheet.
    (I got the code to do that from other posts in this forum - work GREAT!)

    Now, I want to have that spreadsheet emailed as an attachment to a list of
    people.
    Note: I know how to send a query in access to an email address with the
    macro SendObject method and I've also done the same thing in VBA.

    But in this case, access has merely added additional rows of data to an
    existing spreadsheet, and saved the results.

    I would like access to be able take the Excel file and email that to my users.

    Any ideas on how to accomplish that?

    My ultimate goal will be to set up the access application to kick off on a
    timer at night and send the updated spreadsheet out to an email group without
    human interraction.

    thanks,
    Chuck


  2. Default Re: Email Excel file from Access

    Appelq <Appelq@discussions.microsoft.com> wrote:

    >I would like access to be able take the Excel file and email that to my users.
    >
    >Any ideas on how to accomplish that?


    Depends greatly on your means of sending emails.
    Microsoft Access Email FAQ
    http://www.granite.ab.ca/access/email.htm

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
    Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

  3. Default Re: Email Excel file from Access

    Thanks for the link. I will read through that for ideas.
    We use Exchange 2003 and the PC's all have outlook 2003.

    Ideally I would set this up on a server to run, and it may not have Outlook,
    or any mail client.

    I know somone else in our office has written a report with SQL server's
    reporting services and it emails from the server I wouod have this run on,
    but I suspect that the reporting services has it's own SMTP client built in
    just for thsi purpose.

    I'm open to ideas...

    "Tony Toews [MVP]" wrote:

    > Appelq <Appelq@discussions.microsoft.com> wrote:
    >
    > >I would like access to be able take the Excel file and email that to my users.
    > >
    > >Any ideas on how to accomplish that?

    >
    > Depends greatly on your means of sending emails.
    > Microsoft Access Email FAQ
    > http://www.granite.ab.ca/access/email.htm
    >
    > Tony
    > --
    > Tony Toews, Microsoft Access MVP
    > Please respond only in the newsgroups so that others can
    > read the entire thread of messages.
    > Microsoft Access Links, Hints, Tips & Accounting Systems at
    > http://www.granite.ab.ca/accsmstr.htm
    > Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
    >


  4. Default Re: Email Excel file from Access

    On Jul 1, 2:45 pm, Appelq <App...@discussions.microsoft.com> wrote:
    > Thanks for the link. I will read through that for ideas.
    > We use Exchange 2003 and the PC's all have outlook 2003.
    >
    > Ideally I would set this up on a server to run, and it may not have Outlook,
    > or any mail client.
    >
    > I know somone else in our office has written a report with SQL server's
    > reporting services and it emails from the server I wouod have this run on,
    > but I suspect that the reporting services has it's own SMTP client built in
    > just for thsi purpose.
    >
    > I'm open to ideas...
    >
    >
    >
    > "Tony Toews [MVP]" wrote:
    > > Appelq <App...@discussions.microsoft.com> wrote:

    >
    > > >I would like access to be able take the Excel file and email that to myusers.

    >
    > > >Any ideas on how to accomplish that?  

    >
    > > Depends greatly on your means of sending emails.  
    > > Microsoft Access Email FAQ
    > >http://www.granite.ab.ca/access/email.htm

    >
    > > Tony
    > > --
    > > Tony Toews, Microsoft Access MVP
    > >    Please respond only in the newsgroups so that others can
    > > read the entire thread of messages.
    > >    Microsoft Access Links, Hints, Tips & Accounting Systems at
    > >http://www.granite.ab.ca/accsmstr.htm
    > >    Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/- Hide quoted text -

    >
    > - Show quoted text -


    if you have CDOSys (you can download it from Microsoft), you can use
    that. It's a wrapper for MAPI and is really simple to use. You can
    add as many recipients as you want etc. add attachments... etc etc.

+ Reply to Thread