Subject Field in Outlook

[maatman]

Hi,

With this code an e-mail is generated with the recipient name:

Application.Dialogs(xlDialogSendMail).Show "dennis@mtcbaits.nl"

Is it possible to also automatically fill the Subject Field of the e-mail?

Rgds

 

[Michael M]

Try this
You can delete the lines you DON"T need

With Mail_Object.CreateItem(o)
            .Subject = "Latest Information or Report "
            .To = "dennis@mtcbaits.nl"
            .Body = "The latest report is attached for your information and distribution ."
            .Attachments.Add "Path and filename"
            .Send
end with