About Us

Leendert

I think this problem is too difficult.

(Leendert) wrote in message . com...
(Leendert) wrote in message . com...
Hello,

Could somebody please help me with the following problem we are
experiencing since an Office update?

When I send an document as a MailItem from Excel with VBA (with the
VBA code Send), a safety alert sometimes comes behind the Excel
window: "A program is trying to automatically send e-mail on your
behalf. Do you want to allow this. If this is unexpected, it may be a
virus and you should choose "No"."

When this dialog is not displayed to the front, it is not possible to
respond, so after a view seconds comes another dialog box: "Microsoft
Excel is waiting for another application to complete an OLE action".

It is strange that this problem does not occur on all the computers we
use. What is the solution to get the alert always display to the
front?

We use Office 2000 and Office 2002 (Windows 2000 and Windows XP).

Here is the VBA code that I use:

Set myOlApp = CreateObject("Outlook.Application")
Set MyItem = myOlApp.CreateItem(olMailItem)
MyItem.To = ToVar
MyItem.Subject = "Afwezigheidsregistratie " & ActiveSheet.Range("A3")
Set myAttachments = MyItem.Attachments
myAttachments.Add Pad, , 1
MyItem.Send

With kind regards,

Leendert Meijer

Can nobody help me?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to delete the "Insert Function Dialog Box" (dialog box only)?	TBI''d biker	Excel Worksheet Functions	2	April 7th 07 09:18 PM
front end zero	Tdilly	Excel Discussion (Misc queries)	1	September 1st 05 06:56 PM
control of dialog macro dialog box. on open	Gerry Abbott	Excel Programming	0	July 22nd 04 05:41 PM
getting rif of apostrophe in front of ss#	jrh	Excel Programming	4	February 13th 04 02:08 AM
dialog box displayed when internet connection unavailable	nil	Excel Programming	2	January 28th 04 10:04 PM

Menu

About Us