Compare mail IDs with database values

datatable
database

#1

Hi all,

I’m trying to compare values retrieved using get outlook mail messages to values in the database. For example, I’m retrieving the mail IDs using the message.from function. I’m trying to compare this with the mail IDs present as a column in the database. I tried string.compare ,but the problem is that the database values are of the type datarow. Can anyone help me with a few other functions i can try with?

Regards,
Amitha


#2

Try to use the For Each Row activity to run through your datatable and compare the column (using the get row item activity) with the email ID from the Outlook Mail Messages. For the compare you can use If activity.

To help you to understand better, follow below an example.

compareEmail_Example.xaml (10.6 KB)

Hope It Helps!

Regards,


#3

Thank you!