E-mail attachments from local drive - Access 97

[OracleRenegade]

Hi,


I have a variety of files that I need to e-mail based on certain conditions.

i.e.

On C:\myfilesToSend directory I have

Case1.xls
Case2.xls
Case3.xls

I have some logic that sits in a module and determines which file should be sent and which e-mail to send it to - easy!

But I cannot find a way of attaching the external file to my mail and send it (without user interaction) for 3000+ e-mails.

Anyone give me a brief snippet of code for sending a mail with external attachment from Access 97?

 

[OracleRenegade]

BTW - We have groupwise - outlook is NOT an option

 

[ProgramError]

Take a look at the sendobject method.

DoCmd.SendObject acSendReport, REPORTNAME, FORMAT ,TO ,CC ,BCC ,SUBJECT ,MESSAGETEXT , EDITMESSAGE,

Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.

 

[OracleRenegade]

Hi ProgramError(!?),

I know all about DoCmd.SendObject - but you are missing my requirement - to send EXISTING files as an attachment - not ones that are generated from MS Access - ALSO - I have a problem with DoCmd.SendObject as when I try it with EDITMESSAGE = FALSE then it fails on various client machines (there is a 0 byte attachment) but I cannot seem to narrow down what is causing this as it works perfectly on other client machines with the same version of MS Access and groupwise....


OR

 

[PHV]

Have a look here:
thread705-1369407

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886