Email multiple receipients

  • Thread starter Thread starter k
  • Start date Start date
did you add reference to outlook?
at what line you get compile error?
make sure you also have reference to DAO 3.60
 
i added ref. to outlook as described.
get compile error at line 1....Dim MyDB As Database
how do i do DAO 3.6.. i presume from the ref.tools
menu..will check that.

thks.
 
i referenced DAO 3.6, now i get a differnet type mismatch
error on:

Set MyRS = MyDB.OpenRecordset("tblMailingList")

evrything is identical as described on the sample layout.

help plse??
 
in references dialog - move DAO higher then ADO
or

replace
dim MyRS as Recordset
to
dim MyRS as DAO.Recordset
 
its work better, but still get errors,
i'm not sure how this is supposed to work? i have the
form built, i put in a CCAddress, Subject and a body
message and then, how do run the code, put a button and
call what? is outlook meant to open and insert all my
address's in the ToAddress...? i'm testing from the CTL-G
type Sendmessages and it says, Outlook is trying to
access outlook adress's but nothing happens....I press
yes and get error at.

Body = Forms!frmMail!MainText
 
i got it working now, but how do i run the code from a
button on my form, i also have to push yes on a box that
comes up to every email address its sending too, that
takes ages....is this right?? ms outlook does not open,
but i am running it from VB editor.

any ideas??
 
create a new button on a form, in it click event procedure write:
SendMessages

thats all, when you click it - SendMessages proc will run
 
Back
Top