Answers.Body: <p>A couple options:</p>
  
  <ul>
  <li><p>From the report you can export to CSV and use that as a data source for a merge outside of Civi. </p></li>
  <li><p>If you create a smart group with the same criteria as the report you can quickly search for those who meet the criteria and print mailing labels from the search results. You can also use this smart group as a recipient list in CiviMail if you want to go the email route.</p></li>
  </ul>
  
  <p>Hope this helps.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-06-24T03:38:26.230Z
Answers.Text: Your second option looks more like what we want. However, just to clarify...we would run the "Upcoming Birthdays Report", then save the list to a smart group. Then search for the smart group and generate the labels. Correct?
Answers.UserDisplayName: Sudesh
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-06-24T17:13:25.383Z
Answers.Text: You need to create the smart group via search results. There are details here: 
  
  https://docs.civicrm.org/user/en/latest/organising-your-data/smart-groups/
Answers.UserDisplayName: KilakwaBT
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-06-23T16:04:47.483Z
Answers.LastActivityDate: 2017-06-23T16:04:47.483Z
Answers.UserDisplayName: KilakwaBT
Answers.Body: <p>I found a way to print labels from the results generated by running the "Upcoming Birthdays Report" as follows:</p>
  
  <ol>
  <li>First I created a group and named it "Upcoming Birthdays". </li>
  <li>I then ran the Upcoming Birthdays Report".</li>
  <li>Added the results of the report to the "Upcoming Birthdays" group.</li>
  <li>Then went to Search->Find Contacts. Selected the "Upcoming Birthdays" group and clicked Search.</li>
  <li>Then from the search results, selected all records, and selected "Mailing labels - print" from the actions drop down.</li>
  </ol>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-06-25T19:17:33.760Z
Answers.LastActivityDate: 2017-06-25T19:17:33.760Z
Answers.UserDisplayName: Sudesh
Body: <p>Currently, reports do not have a way to print mailing labels. Our specific requirement is to make use of the "Upcoming Birthdays Report" to print mailing labels for donors so we can post them birthday cards and even just send them an email.</p>
  
Tags: <civireport><address-labels>
Title: Is there a way to print mailing labels from a report
ThreadText: # Is there a way to print mailing labels from a report
  
  (Asked by: username_0 on 2017-06-23)
  
  Currently, reports do not have a way to print mailing labels. Our specific requirement is to make use of the "Upcoming Birthdays Report" to print mailing labels for donors so we can post them birthday cards and even just send them an email.
  
  **Tags:** civireport, address-labels
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_0 on 2017-06-25. Score: 3 | Accepted answer
  
  I found a way to print labels from the results generated by running the "Upcoming Birthdays Report" as follows:
  
  1. First I created a group and named it "Upcoming Birthdays".
  2. I then ran the Upcoming Birthdays Report".
  3. Added the results of the report to the "Upcoming Birthdays" group.
  4. Then went to Search->Find Contacts. Selected the "Upcoming Birthdays" group and clicked Search.
  5. Then from the search results, selected all records, and selected "Mailing labels - print" from the actions drop down.
  
  
  ---
  
  ### Answer by username_1 on 2017-06-23. Score: 3
  
  A couple options:
  
  * From the report you can export to CSV and use that as a data source for a merge outside of Civi.
  * If you create a smart group with the same criteria as the report you can quickly search for those who meet the criteria and print mailing labels from the search results. You can also use this smart group as a recipient list in CiviMail if you want to go the email route.
  
  Hope this helps.
  
  > **Comments:**
  > **username_0**: Your second option looks more like what we want. However, just to clarify...we would run the "Upcoming Birthdays Report", then save the list to a smart group. Then search for the smart group and generate the labels. Correct?  
  > **username_1**: You need to create the smart group via search results. There are details here:   https://docs.civicrm.org/user/en/latest/organising-your-data/smart-groups/  
  
  ---
  
  