How do i retrieve the Company Name inside Email and forward the email to their email address?

Help Activities
,
1

image

I would like to use uipath to auto forward email i received from my supplier and automatically forward to my customer.

  1. How do i retrieve the company name from the Sold To table?
  2. How do i match the customer email address from the address book and forward the email to them??
2

Hey @Eric_Siew :wave:

Welcome to the community!

If you want to do this for multiple rows of data, you can go for a For Each Row activity, iterate through the data table and fetch the sold to information through the data row that is returned with each iteration like row("Sold to").ToString.Trim.

You can use the lookup to search for the customer email address from the address book.

How structured is your Excel? Could you share a screenshot so I could give you a proper solution?

Cheers!

3

The table is actually the email content… not from Excel file.
is it still possible to read the column like you mention??