create emails based on data in a table

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

Hi...i want to be able to create emails in MS outlook based on information in
a table...thanks
 
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
 
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
 
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 -
Click to expand...

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
 
Back
Top