How get copy data into a spreadsheet and email

Hi,

We would like to copy data from a database and paste into an excel spreadsheet (failed data which didn’t complete in a process). The spreadsheet then needs to be emailed as an attachment as an exception - what would be the best way to do this please?

Thanks,
Tony

  1. You can use data base activities to read the data from the database.
  2. Export the data to the excel (Excel Application Scope Activity).
  3. Use Mail activities to send excel as an attachment.

Regards,
Karthik Byggari

Hi,

Thanks for the response. Would it be possible for anyone to assist with the attached process please? The area I am stuck on is getting the data to copy from the Access table, saving it in a spreadsheet and then emailing the spreadsheet off to me. Any help would be much appreciated!

Thanks,
Tony

Process.xaml (49.6 KB)