Sending email via Outlook from word 97/2000 
Author Message
 Sending email via Outlook from word 97/2000

'Lo All,

I am using code derived from code posted on MVPS :


My code will send multiple emails to an address taken from the contents of
multiple word documents (one email per document).

The code works if I have Outlook running before I run the macro.  However if
the macro opens Outlook itself (because Outlook isn't already running) not
all of the emails are sent all the time, sometimes all are sent sometimes
only one and any combination between.  When Outlook is ran manually any
emails that weren't sent are then sent.

Any suggestions as to how to ensure Outlook sends all the emails?  Looks
like a timing issue, is there any way to check Outlook has sent the previous
email before queueing another?

P.S. Is there some sort of pause/sleep/wait command in VBA.

Jonathan Leckie, Please remove the Z in my email address to reply

Mon, 03 May 2004 20:25:45 GMT  
 [ 1 post ] 

 Relevant Pages 

1. How do you send Outlook 2000 email using WORD 97 VBA Macro

2. Sending plain text email via Access 97 and Outlook

3. send email automatically from Filemaker via MS Outlook 2000

4. Call a Word 97 Macro from Outlook 2000

5. OlCalndr Template with Word 97 SR 2 And Outlook 2000

6. OlCalndr Template with Word 97 SR 2 And Outlook 2000

7. ACCESS 97 - Sending Word Documents by Email

8. Sending email in Word 97

9. Send/Receive email automation with Outlook 2000

10. re-sending emails automatically in outlook 2000

11. Delayed email send in Outlook 2000 - PLEASE HELP!

12. Sending Email without Outlook 2000


Powered by phpBB® Forum Software