Answers.Body: <p>I ended up using the Custom Search: Price Set Export, then used Excel Formulas, and then a Microsoft Word Mail Merge. Ew!</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-11-09T23:12:48.610Z
Answers.LastActivityDate: 2016-11-09T23:12:48.610Z
Answers.UserDisplayName: Zachary
Body: <p>We would like to print name badges for our events using CiviCRM.</p>
  
  <p>However, we use complex price sets, and we use "Codes" printed on our name badges for access to certain events.</p>
  
  <p>Is there a way to use CiviCRM to merge price set options onto name tags?</p>
  
  <p>We ended up using Excel and a lot of complicated formulas.</p>
  
  <p>However, if every price set option could have a "Name Badge Code" field, and we could print those on the CiviCRM Name Badge, or even just export them in a price set report, that would substantially reduce our efforts.</p>
  
  <p>Anyone ever face this issue?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-10-07T00:41:06.860Z
Comments.Text: We have a similar need and want to include on each badge the attendees role, membership level, and a short code for their fee level. We have been doing an Excel export and mail merge, which is not too bad for advance registrations, but unworkable for on-site registrations. We would also like to be able to include static text fields and concatenate fields such as city and state. I looked for the PHP pages for badge formatting and did not find which files would need to be modified-- has anyone had success with customizing this?
Comments.UserDisplayName: Larry K.
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-10-07T20:57:50.243Z
Comments.Text: Welcome to StackExchange! You have posted this as an answer but it doesn't appear to answer the question.  You are more likely to get a response if you post a new question, with a reference to this question if relevant.
Comments.UserDisplayName: William Mortada
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-10-08T01:20:43.880Z
Comments.Text: For onsite registrations, we had two laptops with name-badge printers and just hand typed their name/codes and printed it out on the spot.
Comments.UserDisplayName: Zachary
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-10-08T03:00:03.720Z
Comments.Text: I imagine some really nifty-cool extension could add a field to the price set field options for inserting a "name badge code" then it could be exported somehow.
Comments.UserDisplayName: Zachary
Tags: <price-sets>
Title: Mail Merge Codes per Price Set Option (Name Badges)
ThreadText: # Mail Merge Codes per Price Set Option (Name Badges)
  
  (Asked by: username_0 on 2016-11-08)
  
  We would like to print name badges for our events using CiviCRM.
  
  However, we use complex price sets, and we use "Codes" printed on our name badges for access to certain events.
  
  Is there a way to use CiviCRM to merge price set options onto name tags?
  
  We ended up using Excel and a lot of complicated formulas.
  
  However, if every price set option could have a "Name Badge Code" field, and we could print those on the CiviCRM Name Badge, or even just export them in a price set report, that would substantially reduce our efforts.
  
  Anyone ever face this issue?
  
  **Tags:** price-sets
  
  > **Comments:**
  > **username_1**: We have a similar need and want to include on each badge the attendees role, membership level, and a short code for their fee level. We have been doing an Excel export and mail merge, which is not too bad for advance registrations, but unworkable for on-site registrations. We would also like to be able to include static text fields and concatenate fields such as city and state. I looked for the PHP pages for badge formatting and did not find which files would need to be modified-- has anyone had success with customizing this?  
  > **username_2**: Welcome to StackExchange! You have posted this as an answer but it doesn't appear to answer the question.  You are more likely to get a response if you post a new question, with a reference to this question if relevant.  
  > **username_0**: For onsite registrations, we had two laptops with name-badge printers and just hand typed their name/codes and printed it out on the spot.  
  > **username_0**: I imagine some really nifty-cool extension could add a field to the price set field options for inserting a "name badge code" then it could be exported somehow.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2016-11-09. Score: 1 | Accepted answer
  
  I ended up using the Custom Search: Price Set Export, then used Excel Formulas, and then a Microsoft Word Mail Merge. Ew!
  
  
  ---
  
  