combining multiple rows into 1 pdf

Hi All, 

I am trying to create a PDF from my clients table that will send me an email of all the clients who have "fountain removal" marked in their column "treatment schedule". I want it to be just a straight list of the client and contact information all in one PDF. 

The ways I've tried setting it up, it runs the actions on each row individually creating 80+ individual PDF's/emails. I want it to be all in 1. 

For context here is how the data is set up. 

Table: Client

Columns: Client Name, Main Contact, Main Phone, Main Email, Second Contact, Treatment Schedule 

 

Treatment schedule is a enum where the choices are months and "Fountain removal". 

Goal: get 1 PDF emailed to me with a list of the client names and contact information for all clients who have fountain removal as one of their treatment schedules. 

0 3 170
3 REPLIES 3
Top Labels in this Space