pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres to MS-Word? (Kind of off topic)
4+ messages / 4 participants
[nested] [flat]
* Postgres to MS-Word? (Kind of off topic)
@ 1999-03-03 21:04 Matthew Hagerty <matthew@venux.net>
1999-03-03 21:16 ` Re: [INTERFACES] Postgres to MS-Word? (Kind of off topic) Byron Nikolaidis <byronn@insightdist.com>
1999-03-03 21:47 ` Re: [INTERFACES] Postgres to MS-Word? (Kind of off topic) Brett W. McCoy <bmccoy@lan2wan.com>
0 siblings, 2 replies; 4+ messages in thread
From: Matthew Hagerty @ 1999-03-03 21:04 UTC (permalink / raw)
To: pgsql-interfaces
Greetings,
Sorry, maybe a little off topic, but seems like an interface issue to me. :)
My client has a database of customers. My client also wants to be able to
pull up a record on a client and sent a letter to that client. The letter
would be canned except for the header and greeting. Does anyone know of a
way to get field info into a word.doc file and print it from the same UN*X
server running PostgreSQL? Any one ever do something like this?
I cannot seem to find a good solution.
Thanks,
Matthew
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] Postgres to MS-Word? (Kind of off topic)
1999-03-03 21:04 Postgres to MS-Word? (Kind of off topic) Matthew Hagerty <matthew@venux.net>
@ 1999-03-03 21:16 ` Byron Nikolaidis <byronn@insightdist.com>
1 sibling, 0 replies; 4+ messages in thread
From: Byron Nikolaidis @ 1999-03-03 21:16 UTC (permalink / raw)
To: Matthew Hagerty <matthew@venux.net>; +Cc: pgsql-interfaces
Matthew Hagerty wrote:
> Greetings,
>
> Sorry, maybe a little off topic, but seems like an interface issue to me. :)
>
> My client has a database of customers. My client also wants to be able to
> pull up a record on a client and sent a letter to that client. The letter
> would be canned except for the header and greeting. Does anyone know of a
> way to get field info into a word.doc file and print it from the same UN*X
> server running PostgreSQL? Any one ever do something like this?
>
I think you can put odbc queries into word documents. I'm not sure of the exact
details, but it seems like it would work.
Byron
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] Postgres to MS-Word? (Kind of off topic)
1999-03-03 21:04 Postgres to MS-Word? (Kind of off topic) Matthew Hagerty <matthew@venux.net>
@ 1999-03-03 21:47 ` Brett W. McCoy <bmccoy@lan2wan.com>
1 sibling, 0 replies; 4+ messages in thread
From: Brett W. McCoy @ 1999-03-03 21:47 UTC (permalink / raw)
To: Matthew Hagerty <matthew@venux.net>; +Cc: pgsql-interfaces
On Wed, 3 Mar 1999, Matthew Hagerty wrote:
> Sorry, maybe a little off topic, but seems like an interface issue to me. :)
>
> My client has a database of customers. My client also wants to be able to
> pull up a record on a client and sent a letter to that client. The letter
> would be canned except for the header and greeting. Does anyone know of a
> way to get field info into a word.doc file and print it from the same UN*X
> server running PostgreSQL? Any one ever do something like this?
>
> I cannot seem to find a good solution.
Doesn't Word's mail merge tool let you connect to ODBC databases?
Brett W. McCoy
http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
The best prophet of the future is the past.
-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GAT dpu s:-- a C++++ UL++++$ P+ L+++ E W++ N+ o K- w--- O@ M@ !V PS+++
PE Y+ PGP- t++ 5- X+ R+@ tv b+++ DI+++ D+ G++ e>++ h+(---) r++ y++++
------END GEEK CODE BLOCK------
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: [INTERFACES] Postgres to MS-Word? (Kind of off topic)
@ 1999-03-03 21:51 Michael Davis <michael.davis@prevuenet.com>
0 siblings, 0 replies; 4+ messages in thread
From: Michael Davis @ 1999-03-03 21:51 UTC (permalink / raw)
To: 'Matthew Hagerty' <matthew@venux.net>; pgsql-interfaces
Use postgres to great a mail merge file (a text file containing the name
formatted for word mail merge). A view and/or stored procedure is a good
candidate for creating this text file. You can create an example of this
file using word so you can see the format. This mail merge file needs to be
accessible on the windows machine that will be running word (SAMBA could be
used for this). Create a document template based on this mail merge file.
Open word using the newly created document template, let the user add their
text and print their letter. The trick will be initiating this process on
windows. I do this sort of thing with Access using ODBC.
-----Original Message-----
From: Matthew Hagerty [SMTP:matthew@venux.net]
Sent: Wednesday, March 03, 1999 2:05 PM
To: pgsql-interfaces@postgreSQL.org
Subject: [INTERFACES] Postgres to MS-Word? (Kind of off
topic)
Greetings,
Sorry, maybe a little off topic, but seems like an interface issue
to me. :)
My client has a database of customers. My client also wants to be
able to
pull up a record on a client and sent a letter to that client. The
letter
would be canned except for the header and greeting. Does anyone
know of a
way to get field info into a word.doc file and print it from the
same UN*X
server running PostgreSQL? Any one ever do something like this?
I cannot seem to find a good solution.
Thanks,
Matthew
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1999-03-03 21:51 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-03-03 21:04 Postgres to MS-Word? (Kind of off topic) Matthew Hagerty <matthew@venux.net>
1999-03-03 21:16 ` Byron Nikolaidis <byronn@insightdist.com>
1999-03-03 21:47 ` Brett W. McCoy <bmccoy@lan2wan.com>
1999-03-03 21:51 RE: [INTERFACES] Postgres to MS-Word? (Kind of off topic) Michael Davis <michael.davis@prevuenet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox