I've perused a large number of the posts to this newsgroup for a while,
lurking around and grabbing lots of helpful snippets, but I wonder if anyone
can help witha specific issue I have, that seems to almost be solved by many
of the answers to some of the topics posted, please?

Specifically, I have a PC that is always on and gets a file created from
another program. It is a tab delimited text file that gets used as the source
doc for the mail merge. The Task Scheduler is set to run (at 2.00 AM) the
following:

"C:\Program Files\Microsoft Office\Office\WINWORD.EXE" /mmacro3

Macro3 basically opens up the mail merge document, merges to email with the
source, then shuts word down.

But, as previously stated elsewhere, the mail subject can only get set to a
single value using this method. Ideally, I would like it to be set to a
string, on the basis of:

Site Visit Report yyyymmdd Task Client

where the date, task and client are all variables within each record in the
source.

Now it occurs to me that, if the email subject is not predefined in the
macro that launches the mail merge, it would pick up the name of the document
by default as the subject, which is fine, but then the problem is that the
document name doesn't change with each email. So the next step would seem to
be to merge to separate documents, for which the 'splitter' macro seems
ideal, but I'd then need to automatically (on completion of the initial mail
- split documents) email the various split documents, and probably delete
the split documents after they have been emailed. Otherwise I will end up
with an ever-increasing folder and I expect it may be more complicated to
just email those that are new since the last merge-'n'-mail.

To complicate things even further, sometimes the source file is empty, and
the whole thing locks up on launching Word (unable to find source records -
though the file always exists), so whatever solution someone can come up with
would be even better if it could include some form of 'don't execute if there
are no records in xxxx.txt

Really, really hoping someone can help and thanks in advance

Simon