Sende mail fra Access

"Problemet er at den henter filen fra en default folder i outlook"

Can you explain what you mean here?

Is it possible to see code you are using?

Public Sub SendEmail()
Dim appOutLook As Outlook.Application
  Dim MailOutLook As Outlook.MailItem
  Dim strPath As String
  Dim strFileName As String
  Set appOutLook = CreateObject("Outlook.Application")
  Set MailOutLook = appOutLook.CreateItem(olMailItem)
  With MailOutLook
    .BodyFormat = olFormatRichText
    .To = "XXX@YYY"
    .CC = " "
    .bcc = " "
    .Subject = "Some text"
    .HTMLBody = "This is an autogenerated message"
    'add all CSV files
    strPath = "W:\Data Collector, DWH.nodlt\QuickView\Report\"
    strFileName = Dir(strPath & "*.xlsm")
    While strFileName <> ""
      .Attachments.Add (strPath & strFileName)
      strFileName = Dir()
    Wend
    .Send
  End With

End Sub

Jeg prøver at kigge på din løsning, jeg vender tilbage.

Tak for hjælpen jeg det til at virke.