I have attached a clip that used last year to send out 200-300 email messages automatically.
It doesn't do exactly what you need to do but it might give you some ideas.
There's no comments in the text so I hope you can follow it.
I used this to send out scores from an international photography competition. All the scoring information was in an MS-Access database. We were to generate an html file for each entrant in the competition using the report functions in Access. This produced over 200 html files containing each contestant's address, email and scores. The htnl files were saved in one directory.
In Notetab Pro I could open all the html files at once then I ran the clip.
This clip searched each file for an email address and then switched to Outlook to create the email address. It opened a new message inserted the email address and subject. Then it flipped back to Notetab and copied the html and sent the message.
I had to put some timing delays in to make it work. If you have a faster computer you may be able to reduce the delays. I remember it running for a couple of hours on a Friday night to send the emails but I time to do other things.
I hope you find this helpful.
Halifax, Nova Scotia
----- Original Message -----
From: Brian Mailman
Sent: Friday, January 11, 2002 1:03 PM
Subject: [Clip] Mail Merge (was Printing an html file)
On a similar subject, I have a weekly chore for the yahoogroups list I
own; I check the bouncing pages and send out probes from my own
account. Usually about 30-40 "letters."
Right now, I'm doing it by downloading the list as an ASCII list, then
cutting-and-pasting into an email template I have in Netscape.
Reading this thread is giving me an idea--the idea of passing commands
to an external program. Is there a way to do a "mail merge" by
assembling the letters and mailing out the letters directly from NoteTab
(please note, I'm NOT wanting to discuss how to use Netscape or
yahoogroups' vagaries)? It only takes about 10 minutes or so but if I
can cut that down to about 30 seconds I'll be happier.
IF this is possible, is it possible to compare two lists (last weeks
bounces and this weeks) and delete those addresses NOT on "this week's"
Yahoo! Groups Sponsor
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
^!Continue Make Sure the Inbox is open!
^!Find "[A-Za-z_.-0-9]+@[a-z_.-0-9]+" RS
^!Keyboard Ctrl+N Ctrl+V Tab Tab #Great Eastern Canadian Results# Tab Ctrl+Tab
^!FocusApp Great Eastern*
^!Keyboard Ctrl+V Ctrl+Tab Ctrl+Tab Alt+S
^!If ^%CurrDoc%=^%NumDocs% Done
;^!Prompt Email address not found
^!Prompt All Done
[Non-text portions of this message have been removed]