My users want to send an email from Civi that will have a particular group of contacts embedded in it or as an attachment. The group is featured in a report, so emailing the report seems like the solution, but they want to preface the report with some words. How to embed or attach the contact list or report into an email sent from Civi? This is using Drupal so perhaps Views is an option?
Sounds like you're looking for CiviCRM Views Token.
This is a Drupal module which allows you to place a token in your CiviMail that will be replaced with the output of a Drupal View.
To use it:
- Install and enable CiviCRM Views Token
- Build your view of contacts in Drupal - keep the output simple, eg a table or an unformatted list.
- In your CiviMail edit screen, look for "Configured Drupal View" in the token selector.
- Place the desired view in your email, eg