A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Automated merge from Word 2000 to Outlook 2000



 
 
Thread Tools Display Modes
  #1  
Old April 25th, 2005, 07:51 PM
sayling
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 12:52 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.