Use sendobject and use table with email address

[Rogier]

I want to make a macro within the sendobject. By To: i use a table within the
email addresses that should get the mails. But the first email address in the
table is the only one who gets the mail and the others don't get an email.
Is someone who can help me?

Thanks.
I'm from the netherlands so my english is not that good, my excuses for that.

 

[Wolfgang Kais]

Hello Rogier.

I want to make a macro within the sendobject. By To: i use a table
within the email addresses that should get the mails. But the first
email address in the table is the only one who gets the mail and the
others don't get an email. Is someone who can help me?

Thanks.
I'm from the netherlands so my english is not that good, my excuses
for that.

Perhaps you should tell us how the email addresses get into the macro
argument. I guess that you use something like
=DLookup(...)
This will not collect data from multiplerecords.
What sees the first recipient in the "To" line when he/she receives the
email?

 

[Rogier]

It's an Excel Worksheet.