Email Excel file from Access

[Appelq]

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

 

[Tony Toews [MVP]]

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/

 

[Appelq]

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...

 

[pietlinden]

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...







- 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.