How to attach excel in email using automation

AppSheet AppSheet Q&A
1

I have 4 worksheets in my workbook.

And I want to send a copy of one worksheet as an everyday emailer using automation. How do I do that?

Also, how to customize the excel to send only selective fields.

Thanks in advance.

2

To automate sending a daily email with one worksheet, use VBA (Visual Basic for Applications). Create a macro to copy the desired sheet and use Outlook or another email application to send it daily. Customize by selecting specific cells or ranges in the VBA code to send only relevant data. Don’t forget to set up a scheduled task for daily execution.

3

Appreciate it, Shanza. I was looking for settings within the appsheet to do so and looks like this does the job.

RupeshDew_0-1704715844653.png
RupeshDew_0-1704715844653.png479×530 28.5 KB

But still figuring it out to select only relevant columns to be includes and if formatting can be applied. Looking forward to solution.

Thanks.