I'm trying to use this article to send a 2000 Word
document as an attachment with 2000 Outlook. I've coded
in the third option. After the ".Send" line, Outlook
displays a modal form. Its caption is "Microsoft
Outlook." The label instructs the user that another
application is attempting to use Outlook to send an email
and should this continue? There are three
controls, "Yes, No, and Help." I notice the modal form
will not accept input for five seconds. So, I coded into
the VBA macro a five second delay, then a SendKeys "y"
for Yes. But since the form is modal the VBA code will
not read the next lines until either, "Yes or No" is
clicked.
Is there a way I can by-pass this unnecessary user
keystroke? Is there anOutlook value I can add to
the "Send" method?
Thanks...
Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 19 Dec 2003 03:00 GMT
Hi Bob,
You will find a way around this in the article "Mail Merge to E-mail with
Attachments" at:
http://www.mvps.org/word/FAQs/MailMerge/MergeWithAttachments.htm
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP
> I'm trying to use this article to send a 2000 Word
> document as an attachment with 2000 Outlook. I've coded
[quoted text clipped - 15 lines]
>
> Thanks...