Get cell value to outlook mail body

Hi,

In this excel sheet I need to get B2 cell value and copy in the outlook mail body. (In B2 cell value will be changed depending on the total values. The value position not change).

Refer the attached excel sheet.
sample.xlsx (7.8 KB)

Kindly advise me on this.

Thank you.

Hi @Udesheyy
You can use de Read Cell Activity, but make sure the variable where you store the read value es of type Double. Then you can use it as you need.

@GersonTun

I need to pass this cell value using assign activity. And I want to know the VB expression for it. (Because I need to copy this value into mail body)

Thank you

@Udesheyy
There’s no need to use an assign activity, the output property from the activity itself does the assign.
Then you can convert it into string, just like B2Value.ToString. See the XAML attached.

B2Value.xaml (4.3 KB)

@GersonTun

Thank you so much. It’s work

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.