[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Re: Mail Merge/Word/Form Letters


I write the letter as an include file which the sqr program includes and merges 
with the list of names and addresses supplied by a database query.  This way, 
the letter body is isolated from the program logic and can be modified by 
someone who isn't a programmer using a text editor whenever necessary.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: Robert Foster [mailto:robert.foster@radiology.msu.edu]
Sent: Monday, November 11, 2002 11:52 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Re: Mail Merge/Word/Form Letters


Perhaps I'm misunderstanding the question but we generate form letters
all the time which combine information from the database with a
pre-written letter. The letter of course has to be hard coded into the
sqr report using begin-document, end-document or using simple print
statements. I haven't done this with a pdf document which would probably
produce a better looking letter. I assume your idea is to use SQR to
merge two files, one with data and one with a pdf letter?

I'd be interested what others have done.

Bob.

sqr-users-request@sqrug.org wrote:
> Subject: 
>         [sqr-users] Mail Merge/Word/Form Letters
>     Date: 
>         Mon, 11 Nov 2002 08:54:27 -0000
>     From: 
>         andrew_spiers@safeway.co.uk
> 
> Hi,
>  
> Has anyone ever come up with an alternative to using Mail Merge / Word /
> Form Letters ? The reason we are looking into this is that our users don't
> have access to Word so we can't use the supplied SQRs then do a mail merge
> to generate the Form Letters.
>  
> The way we were thinking of doing it, is to do a 'mail merge' from a text
> file holding the letter template to generate a PDF.
>  
> Anyone else have any other ideas ?
>  
> TIA,
>  
> Andrew Spiers

===
Bob Foster
I/S Coordinator
Mid-Michigan MRI, Inc.
Direct Line: (517) 364-2673
mailto:rkf@radiology.msu.edu

_______________________________________________
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