Hello,
I have an extraction that I generated and am trying to extract the constituents to an excel file for light cleaning and de duping for a brochure mail file. When I extract to a file, the view log posted this in the final line: Comment: Error: BCP failed. Not sure what that comment refers to. Can anyone shed light? I then extracted to a list. But Tess won't let me export a list generated from extraction to an excel document. Is there a way to do this that I am missing?
Please help,
Doug
PlayMakers Repertory Company
The easiest way I’ve found to export a list into Excel is to use “User Defined Format from a List” under Labels and Letters in Report/Utility. I choose Standard Mailing Labels as the Output Format. Once the labels are generated I save that document as an Excel spreadsheet. It also gives you header columns as well should you need to do a mail merge.
Christopher Cuhel I Software Application Project Manager
John Michael Kohler Arts Center
ccuhel@jmkac.org
Direct 920-694-4551
From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Doug Coon Sent: Friday, April 25, 2014 12:30 PM To: Chris Cuhel Subject: RE: [Tessitura Marketing Forum] Exporting an extraction to an excel
No, I was using Generate a List in Reports and Utilities. I have not created an Output Set for this List. Is that a step I need to take?
From: Nicole Keating <bounce-nicolekeating9176@tessituranetwork.com> Sent: 4/25/2014 12:04:39 PM
Are you using “Execute an Output Set” in Reports and Utilities?
From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Doug Coon Sent: Friday, April 25, 2014 12:56 PM To: Nicole Keating Subject: [Tessitura Marketing Forum] Exporting an extraction to an excel
Eric Gerdts
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing 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!