In Version 10 to create an excel list that I could use to mail merge into a letter template I would:
The new Current Constituency By List report in Version 11 is not user friendly when saving to an excel file as it adds a bunch of columns and rows making mail merging a pain. Does anyone else have a better way of doing this?
The Excel format in Reporting Services reports (the underlying engine that backs newer standard reports) is formatted to more closely resemble the report display. In order to get the underlying data (similar to the previous version) try saving the report as “CSV (comma delimited)”. You can then open this file directly from Excel, where the data will be loaded (with headers), but without the formatting.
+Ryan Creps
+Tessitura Network
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Anna Blanton Sent: Thursday, May 16, 2013 2:12 PM To: Ryan Creps Subject: [Tessitura Development Forum] V11 Renewals
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Thank you Ryan! This helped immensely!