vba send email by xloo, questions.

[francosueho82]

Dear, All,
I an newbie in Excel VBA. my question is :
I am going to use Excel VBA to send email.
I have a list of contact person with their corresponding email address. in my worksheet, and using xlookup to lookup the correct email address of each particular email contact.

My question is, whenever the contact who is not in my list (ctc) , VBA still use the previous found email address for that contact.

Here is my code (partial) :

Dim ctclist As Range
Dim Eaddress As Range
Dim ctcEMail As Range
Dim ctc as string

Set ctcEmail = Application.WorksheetFunction.XLookup( ctc , ctclist, Eaddress, "No Match", False)


Thank you very much for your kind help.

 

[Joe4]

Welcome to the Board!

Can you please post the entire VBA procedure (and be sure to use code tags, as directed here: How to Post Your VBA Code).

 

[francosueho82]

Welcome to the Board!

Can you please post the entire VBA procedure (and be sure to use code tags, as directed here: How to Post Your VBA Code).

hi Joe4,
i believe i have solved this by changing the object type to Variant for Eaddress, for example : Dim Eaddress As Variant , tks!