Mailing from Access

[Knut]

Hi everybody,

I've got a little problem. I'm trying mail from access.
I've used the docmd.Sendobject and this works just fine but my problem is that I need to send multiple instances of a report. This is not possible with the .sendobject My problem now is that I can't get the Mapi running. Or better I can't get to the mapi.
Anyone got an idea ?

greetz

Kenneth

PS Excuse the somewaht crummy english I'm it has been a lang time since i wrote any english (I'm dutch you see)

 

[MattGilbert]

how about creating an instance of your mail server as an object.
e.g. CreateObject("Outlook.Application")
you can then use its methods and sctions such as
.Recipients.Add
.Type = 1, 2 or 3 (To, CC or BCC)
.Attachments.Add(path to attachment)
.Subject
.body
.Importance
.Resolve
.Send

etc. hope this helps! Matt

)