create emails based on data in a table

[Ben]

Hi...i want to be able to create emails in MS outlook based on information in
a table...thanks

 

[Robert Morley]

Okay, so now that we know what you want to do, maybe you can tell us what
you've tried so far, or what the problem you're having is.


Rob

 

[Ben]

I've tried quite a number of things. the DoCmd.SendObject seems to do what i
need to do but can't workout how to extract the data from the table to create
the multiple emails that i need to send (only around 30 actually)...i'm sure
its a pretty easy thing to do!!!

The other option was for it to be sent directly from access and bypasing
outlook alltogether...but i think i would rather be able to to the first
option.

Ben

 

[pietlinden]

I've tried quite a number of things. the DoCmd.SendObject seems to do whati
need to do but can't workout how to extract the data from the table to create
the multiple emails that i need to send (only around 30 actually)...i'm sure
its a pretty easy thing to do!!!

The other option was for it to be sent directly from access and bypasing
outlook alltogether...but i think i would rather be able to to the first
option.

Ben





- Show quoted text -

there's an example of how to send an e-mail through Outlook at
www.amazecreations.com/downloads (I think)... then you just do
something like this:

dim rs as dao.recordset
set rs=DBEngine(0)(0).OpenRecordset("Mytable",dbopensnapshot)

do until rs.EOF
olkMsg.Recipients.Add(rs.fields("EMailAddress")
rs.MoveNext
loop

olkMsg.Display