Can't get row.tostring to copy multiple rows from excel and paste into outlook

Hello all,
I’m trying to set up an outlook mail automation can send an email with a few recipients at a time every 5 minutes. However I wasn’t able to get row.tostring to input multiple emails at a time. The error I’m getting is: Compiler error(s) encountered processing expression “Row(“MailAddress”).ToString.Take(2)”. Option Strict On disallows implicit conversions from ‘System.Collections.Generic.IEnumerable(Of Char)’ to ‘String’.Main.xaml

EmailAutomationError2

Thanks

Hi.
Can you explain the mean of ‘Take(2)’?

I wanted to take two email address from my excel at a time so i put a .take(2)

I think you have to add one more ‘to string’.
Like this.
Row(“Mail-Address”).ToString.Take(2).ToString

Thanks for the reply!

It managed to solve the compilation error but when i ran the code it gave me an error of: Send Outlook Mail Message: Outlook does not recognize one or more names.

I think the multiple name of mail address should write like that styles.
email.com; email2.com
So you may should insert semicolon beside the mail addresses.

Is there a way to automate inserting the semicolon between each email address?