Send automatisk mail fra Access - gerne via DOS

Måske du kan bruge http://www.blat.net/

"Access kan ikke klare det selv uden jeg skal acceptere det manuelt"
Can you explain what you mean here, if Access has to start to make the report then why cant it also send?

supportsiden: har set blat.net. Det virker som en gammel side, som så måske også har gamle, outdatede, programmer. Dem "tør" jeg ikke bruge.
terry: det skal ske fuldautomatisk. Hvis jeg bruger Access' send-funktioner, skal jeg manuelt vælge "Send".

You can make some VBA code to send your mails after the report is generated. No need to click anything

terry> ..which I can't, so I ask for help :-/. Which command should I use?

Using Outlook. You will need a reference to Outlook in tools+references.

Function SendMail()
Dim objOl As Outlook.Application
Dim objPost As MailItem
Dim vedhæftet As Attachments
   
    Set objOl = New Outlook.Application
    Set objPost = objOl.CreateItem(olMailItem)
   
    Set vedhæftet = objPost.Attachments
    vedhæftet.Add "f:\txt1.txt"
   
    With objPost
        .Subject = "Subject goes here"
        .To = "somemailaddress@goeshere.dk"
        .BCC = "somemailaddress@goeshere.dk"
        .Body = "Hej med Dig" & .Body 'Just in case we are using an autosignature
                       
        .Send
       
    End With
 
  Set objPost = Nothing
  Set vedhæftet = Nothing
  Set objOl = Nothing
   
End Function

Nice - but it says "User-defined type not defined" for "Outlook.Application"

Arrh, got it. I never worked with references before. It helped checking "microsoft outlook...".

IT WORKS!!! Thnx. Læg et svar.

:-)

Thanks