Kør macro i Outlook fra Access 2000

Hi sailor
Dont know much about Outlook but I would think you should use Automation to start your macro.

This might get you on the right track even though it doesnt start a macro
Before you can use Outlook Automation you need to have a reference to the MS Outlook object library
Tools/References.....

Dim OutL As Outlook.Application
Dim Item As MailItem
Dim Receiver As Recipient

    Set OutL = New Outlook.Application

    Set Item = OutL.CreateItem(olMailItem)
   
   
    With Item
        .Subject = \"Mail subject\"
        .Body = \"What a body!!!\"
        .FlagStatus = olFlagMarked
        \'.Attachments.Add \"My test\"
        \'Set Receiver = .Recipients.Add(\"some email address\")
       
        If Not Receiver.Resolve Then
            .Display
        Else
            .Send
        End If
    End With
   
    Set Item = Nothing

Hi Terry

It worked. I didn\'t know about the Outlook object library.

Thanks for your advice

Sailor