[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] reading a word doc
- Subject: RE: [sqr-users] reading a word doc
- From: "Beller, Jay" <jbeller@lbisoftware.com>
- Date: Thu, 11 Jan 2007 09:05:20 -0500
- Delivery-date: Thu, 11 Jan 2007 09:12:19 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
- Thread-index: Acc1PWdOJ4p2pceoRt2yRPU8dYX+PgASn2Yg
- Thread-topic: [sqr-users] reading a word doc
Here's a suggestion if this is only one style of letter with multiple output
using SQR-retrieved mailing address (i.e., mail merge).
Use an existing output file of the letter as a template (print-to-file from
windows). You'll need at least a two page letter. Examine the postscript file
in a text editor. Place the pre-address portion of the first letter into one
file and the post-address portion, including page-break commands, into another
file. Also, look at any postscript formatting that may be embedded within the
address lines.
In your SQR program, read the pre-address file into one array and the
post-address file into a second array. For every address that your SQR program
retrieves: dump the pre-address array; write the address (with any embedded
postscript noted previously); dump the post-address array.
Not as simple as George's suggestion to use WORD's mail merge (i.e., let your
SQR program generate the addresses that are then used by WORD in a mail merge),
but it should work.
Jay
-----Original Message-----
From: sqr-users-bounces+jbeller=lbisoftware.com@sqrug.org
[mailto:sqr-users-bounces+jbeller=lbisoftware.com@sqrug.org]On Behalf Of
Noah Panayotis
Sent: Wednesday, January 10, 2007 11:59 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] reading a word doc
Hi, I was wondering if anyone knows how to create letters dynamically using a
source file as an input in SQR. The source file usually will contain graphics
and the actual letter. The sqr program is supposed to read this source file and
generate a postscript letter by adding mailing address on the header.
Any comment , suggestion is welcome
Thanks
---------------------------------
Have a burning question? Go to Yahoo! Answers and get answers from real people
who know.
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users