Creating a Text List to Email from Grouped Collection Bundles

Questions & Answers
,
1

Hello!

I ultimately want to create an automatic email that is sent to employees that notifies them of missing receipts that they need to upload. The data is a list of transactions from a Google Sheet and I’m able to aggregate the transactions based on the user. However, I’m struggling on how to aggregate each bundle into a long table to import into Outlook.
Here is the aggregation of each transaction based on the user.

image
image769×949 71.4 KB

Depending on who the user is, one person will receive the email:
image
image802×749 52.7 KB

Then created into a table:
image
image598×898 61.6 KB

But instead of having different operations list out the transactions from each user, I would like to get one list of Dave’s and Julie’s transactions sent to one person in one email. I hope this explanation makes sense! Please let me know any solutions.
image
image461×917 34.8 KB

2

What format does Outlook accept? HTML?

If Yes, you’ll have to Text aggregate to a table row.

For an example, see Formatting issues with ChatGPT and Google docs/Email sending - #2 by samliew

2 Likes
3

Yes Outlook can format HTML. However, after some research, I simplified the scenario and was able to get what I was looking for!
This video helped me with the solution:

2 Likes
4

Hey there @Ben_Simpson :wave:

Just wanted to step in and pat you on the back for the great job you did while searching for the right solution, which happened to be one of the videos from @andyoneil!

Also thank you very much for updating this thread and sharing your final thoughts with us. We appreciate you keeping our community tidy. :broom:

Keep up the good job!

1 Like