**SendObject Parameters Help**

[vanvure4]

I am attempting to send emails to people in a query by pulling the cell data and inputting it into the send object module. What I am running into is getting a silent error because of the "To:" field has members in it I have never sent an email to before. According to the access module for SendObject,

"If the recipient names aren't recognized by the Email application, the message isn't sent and an error occurs."

How do I work around this? I have a bout 50 different persons to send this too and this list is dynamic as our recipiants change often.

 

[PHV]

What is your actual code ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[vanvure4]

Set rs1 = db.OpenRecordset("SR")

Loop through rs1 to grab vendor emails
salesrep = rs1![RepEMail] 'isolates the rep email field


DoCmd.SendObject acSendTable, "ExpSRout", acFormatXLS, salesrep, , , "Specif.....

I can send it to an email in my own contact list through outlook. However when I try to send it to an email not on my list it does not send the email.

 

[madonnac]

unfortunately, I only have lotus notes, but I was wondering if a "example@example.com <Salesman name>;" format would work