Mail Merger Optimizatin?

[dayv2005]

I wrote a mail merger from an article in the KB i forget what exact article it was. But im running into issues of it taking forever to run. And when we runn a cuple hundred emails this thing can take some time.

I was wondering if anyone out there knows how i can optimize this .p file or have another alternitive for me to use?

 

[KnutHandsome]

I haven't done this (mail merge) operation before, so this advice may be incorrect - also, I can't spend much time considering it, but a couple of observations:

The pseudocode of your .p appears to be:

open a word document
replace the 'from words' with the 'to words'
save the changed document

This is presumably executed for each user/document (eg. 200ish?).

My understanding from a quick google, eg.
http://mistupid.com/technical/mailmerge/

is that you are doing in Progress what should really be done in Word/Office.

So my suggestion would be, if possible, change your code to:

Open Word
Supply Template
Supply MailMerge Data
Tell Word to Execute MailMerge [COLOR="Blue"]<< MS handles the 200ish operations here[/COLOR]
Close Word

ie. Move your Progress functionality to a higher-level; let MS handle the batch stuff.

I will leave more knowledgeable people to comment further.

 

[dayv2005]

Yeah that was my first attempt and then i had no idea on how to use my progress Db to supply all the information

Thanks for the quick response by the way