Re: [Clip] Mail Merge (was Printing an html file)
- Hi Brian,
Try the following for a basic Clip.
^!Keyboard [Keyboard keys]
>Reading this thread is giving me an idea--the idea of passingYou can set the Clipboard via ^!SetClipboard and then with
>commands to an external program.
^!Keyboard use Ctrl+V after Alt+ keys to get you in the correct
field you want.
>IF this is possible, is it possible to compare two lists (lastWith a Clip it could be done, but I do not have the time to do it.
>weeks bounces and this weeks) and delete those addresses NOT on
>"this week's" list?
Subscribe, UnSubscribe, Options
- Hi Brian,
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]
- Peter Steeper wrote:
First, Jody--thanks. That's the first step--just knowing if something
Peter--grrrreat. Wonderful. A digression about how great...
I know absolutely nothing about clip language (except that ^! prefaces a
command) and this gives me something to sink my teeth into. As an
ex-primary-school teacher and ex-teaching chef (as sous chef it was my
job to teach the line cooks, many of whom didn't know a saucepan from a
cake pan) I found everyone learns things differently.
My way is to learn what I need in a narrow focus and eventually it'll
fall together. I think now I know _which_ commands to examine and find
out _what_ they do, I can adapt this clip to my needs.