Send Mail Script Step Unexpected Behavior

[dwatson]

I been having some odd behavior using the Send Mail script step. Basically I have some scripts that automatically generate reports, turn them PDF files, re-name them, move them, and then email the reports as attachments to a group of manangers. This has all been working fine for a few years now.

Lately however, I'm finding that Send Mail is adding the recepient name into the To: field in Outlook Express as many times as there were records found for the report. If ten records were found, the each name appears 10 times in To: or cc:. The message still only gets sent once to each recepient. It is like it does not recognize that the global field holding the email recepient's names is in fact a global field and pulls the same information from each record in the found set.

This is only happening in newly-created databases; the old ones still work just fine.

Any insight into this and how to fix it is welcome. Thanks.

[josephkola]

I am actually interested in the script you are running to rename your pdf files. I am looking to have them automatically named based on a field. (Invoice # 0001.pdf rather than the default databasename.pdf) Any info you could lend is greatly appreciated.

Thanks,

Joseph

[dwatson]

Joseph,

I use the Troi File Plug-in (www.troi.com, $59US) to do the move and re-name of the PDF files. I also use it to delete the previous version of the PDF file before doing the rename and move. The data I'm dealing with has a very short shelf life (about 8 hours) so I just delete the previous day's report, which allows the attachment name to always be the same for the Send Mail step. There are actually about seven different reports created from the same data set; three get emailed, the others are available from a web page.

DKW

PS: to anyone who might have thoughts about my problem, I'm going to be gone for the next ten days or so, so if I fail to reply to a post, I'm not being ungracious, I'm just not here.