If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Automated merge from Word 2000 to Outlook 2000
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
The WordPerfect "Reveal Codes" method is so much easier to use. | Torden | General Discussion | 6 | April 19th, 2010 07:50 PM |
Outlook 2003 & Word 2000 | Mr B | General Discussion | 3 | June 16th, 2005 07:52 PM |
is word perfect compatible with office word? | Noreen | General Discussion | 1 | May 11th, 2005 11:17 PM |
How to run word and pass a mail merge values and fax it to the recipient | Belinda | Mailmerge | 2 | June 13th, 2004 12:49 AM |
Merge to Fax with SBS/Exchange? | Tom | Mailmerge | 3 | May 18th, 2004 11:22 PM |