Email multiple receipients

[k]

hi

i used the sample code and set up exactly as described
but get a compile error

sample from: www.support.microsoft.com/?id=318881
also how do i send this from a command button on my
form??

any help plse??

 

[Alex Dybenko]

did you add reference to outlook?
at what line you get compile error?
make sure you also have reference to DAO 3.60

 

[k]

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.

 

[Guest]

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??

 

[Alex Dybenko]

in references dialog - move DAO higher then ADO
or

replace
dim MyRS as Recordset
to
dim MyRS as DAO.Recordset

 

[k]

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

 

[Alex Dybenko]

well, the only idea is that you misstyped MainText control name
Alex

 

[k]

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??

 

[Alex Dybenko]

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

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