Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Mail merging to MS Word

Re: Mail merging to MS Word

From: Jenda Krynicky <Jenda_at_Krynicky.cz>
Date: Wed, 28 Jul 1999 17:32:28 GMT
Message-ID: <1104_933183148@prague_main>


On Mon, 26 Jul 1999 14:48:10 +0100, Claire Moore <claire.moore_at_capgemini.co.uk> wrote:
> Hi
>
> I am trying to create some mail merge letters in MS Word & need to find
> out if there is any easy way to do this. Ideally we would like to create
> the mail merge letters automatically without the user seeing any of the
> nasty stuff.
>
> At the moment, I am doing a mail merge by creating a text file from
> Oracle & then opening Word & using an Autonew Word macro to open up the
> text file & do the merge. This is fine when the text files etc are
> stored locally, but now I am having to create multiple letters on a
> shared drive & will have problems with file naming if I use the same
> approach. Does anyone have any ideas ?? Are there any Microsoft or
> Oracle built-in tools that allow mail merging??
>
> Thanks in advance
>
> Claire

I don't know if this is an option for you, but there is a Perl module that allows you to process RTF templates. It was made for things like this. And it doesn't require Word on the machine.

It was made with Win32::ODBC in mind, it has some predefined statements for this, but since it allows ordinary perl code you may use any other way to get to your data.

And of course there are modules for sending mails with attachments.

See http://jenda.krynicky.cz/#Template::RTF and http://jenda.krynicky.cz/#Mail::Sender

Jenda
http://Jenda.Krynicky.cz Received on Wed Jul 28 1999 - 12:32:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US