Odd error dialog

  • Thread starter Thread starter Maury Markowitz
  • Start date Start date
M

Maury Markowitz

I have an Access app that uses Excel to format up and send short e-
mails. This process is fraught with peril, because if Excel puts up a
dialog box you're pretty much rebooting. I've managed to find most of
the problem cases that would do this and eliminate them over time.

However, on ONE USERS machine I'm getting an "error" I have never seen
before. On MailEnvelope.Item.Send a dialog appears saying something
like (sorry, no screen shot) "This document contains hidden columns
that the recipient may be able to view. Send anyway?" There are no
hidden columns. In fact, the line right above the .Send is an autofit
the ensures this is the case.

Does anyone have any idea what might be triggering this?

Any suggestions? Perhaps turning off dialogs in excel? Is there a
downside to that approach?
 
The first thing to try is to set DisplayAlerts to False. This prevents
most (but not all) dialogs from being displayed and the code continues
to execute as if the user clicked the default button on the dialog. In
Excel/VBA, this would be

Application.DisplayAlerts = False
' your code here
Application.DisplayAlerts = True

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Just wondering if you actually looked for hidden columns--maybe in hidden
worksheets, too?
 
Back
Top