Custom report email | Community
Skip to main content
My_Nguyen
New Participant
December 18, 2020
Question

Custom report email

  • December 18, 2020
  • 1 reply
  • 1277 views

I have an email template I want to use to send out a weekly report of people who've filled out a form. I created a Smart List for this, but I want it to be automatically sent in a nice email format. Is there email scripting that can do this?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

SanfordWhiteman
New Participant
December 19, 2020

You can't customize the standard report/Smart List subscription format.

 

You can create a custom way of reporting on forms, where you first log the form fillouts to a Google Sheet (this is really to get them in the same place, the fact that it's a sheet isn't important as it could be any temporary db) and then bring that weeks fillouts into a Textarea field on a "resource lead" or "reporting lead" you create in Marketo for this purpose. And then you could use Velocity scripting to create a custom layout within an email.

 

Naturally the 2nd option takes some experience.