CDO emails to defined array of recipients

[SazzleTWG]

Hi,

I am trying to send emails using CDO to an array of recipients loaded from a query. I have made this work using Lotus Notes so i know the first part of my code is correct, and the current code I have works when I input an actual email address. But when I try to add the Array name into the 'To' field I get a data mismatch error. Can anyone shed any light on why this might be?

 

[pbaldy]

I don't know that you can do that. I'd build a string instead of an array:

StringVariable = StringVariable & rstRecip.Fields(0).Value & ";"

 

[SazzleTWG]

Many thanks for that, it works perfectly now.

 

[pbaldy]

Happy to help!