Send an email using table - reporting

[Ultralightbeam]

Hello guys, I am pretty new to reporting and sending email.

I have a report which I now would like to automatically email to the listed recipients (Senior).

Ideally I would like recipient to only see the data (Staff,Items) for which the owner is a field within the data.

I have a table from csv file

Senior	Staff	StaffEmail	Items
Senior 1	Staff 1		Phone
Senior 2	Staff 2		Laptop
Senior 3	Staff 3		Laptop
Senior 2	Staff 2		Phone
Senior 1	Staff 2		Phone
Senior 1	Staff 1		Phone

So each senior will receive an email the list of their staff together with the items on a table

My issue is that each senior is not filtering based from their staff. 

[afv2688 · Accepted solution]

Hello @Ultralightbeam,

You could create a batch macro in which you filter the lines corresponding to each senior and send them with the email tool.

If you need any clarification please let me know.

Regards