Question Outlook

[gctsundar]

hi can anybody give me the syntax with explanation for opening an outlook mail from access.

my requirment is like this.

on clicking a button i have to fetch a set of emails from msaccessdb which veries with time and i have to put them in TO field and in CC i have to put another, with a subject and also with a body content.

 

[pl456]

Have a look for the SendObject VBA method.

DoCmd.SendObject

You may be able to achieve what you want with just a macro, that has a sendobject.