How to write excel data in outlook mail?

Help
,
2

Hi @igul,
Try this solution and change according to yours.
Just change the fields as per your column index and i have used outlook here. This is just a rough solution you can try exceptions and make the code more reliable.

How to:

  1. Read the whole data to a data table using Read Range Activity.
  2. Use For each row activity and read in loop.
  3. Assign to variables the fields by row index.
  4. Attach email app(outlook) then use selectors for the To,Subject and message fields.
  5. Type Into and click on send.

Note: Just check the property Add Headers while using Read Range activity otherwise first the header will be coming.

Hope this helpes. :slight_smile:

Main.xaml (17.4 KB)

1 Like