Access send as an attachment errors out

K

K E Bitner

I have been trying to take a report in Access 2000 and send it as an
attachment through Outlook 2002. After I click the "Send to recipient as an
attachment", Access spools the report to the message body. Then after a few
second delay, I get an Access Error that has 2 lines. Line 1 says:
"Microsoft Access can't send a message for the reason stated in the Preceding
Alert". Line 2 says: "Resolve that problem, and send the message again".
There was no preceding messageor alert, so I don't know what is wrong. Can
anyone point me in the right direction to solve this problem?
 
T

Tom Wickerath

Try this KB article:
http://support.microsoft.com/?id=263084


Tom
_____________________________________________

:

I have been trying to take a report in Access 2000 and send it as an
attachment through Outlook 2002. After I click the "Send to recipient as an
attachment", Access spools the report to the message body. Then after a few
second delay, I get an Access Error that has 2 lines. Line 1 says:
"Microsoft Access can't send a message for the reason stated in the Preceding
Alert". Line 2 says: "Resolve that problem, and send the message again".
There was no preceding messageor alert, so I don't know what is wrong. Can
anyone point me in the right direction to solve this problem?
 
K

K E Bitner

I tried the Security Settings and followed the Instructions. It had no
impact. Are there any other ideas?
 
K

K E Bitner

I also found out that Word and Excel work fine when trying to "Send To -
Recipient as an attachment". It is only Access that won't work and gives me
the error.
 
T

Tom Wickerath

The KB article I pointed to includes the following note in the Work Around
section:

"You can customize the behavior only if you are running Outlook
in a Microsoft Exchange Server environment, and your e-mail
messages are delivered to a server-based mailbox."

It's not clear to me whether this situation applies to your set-up.
Are there any other ideas?
Click to expand...
Yes. Are you using a macro? If so, try removing all e-mail addresses
specified on the To, CC and BCC lines in the lower window. You may need to
resort to filling these in manually, or picking them from your address book,
instead of hard-coding these values into the macro. What output format have
you specified? Have you tried a different output format setting?
I also found out that Word and Excel work fine when trying to "Send To -
Recipient as an attachment". It is only Access that won't work and gives me
the error.
Click to expand...

That's kind of comparing apples and oranges. The "Send To - Recipient as an
attachment" functionality in Word and Excel sends the file. The SendObject
action in macro is designed to send an object within the .mdb file, not the
entire file itself.


Tom
_______________________________________

:

I tried the Security Settings and followed the Instructions. It had no
impact. Are there any other ideas?

I also found out that Word and Excel work fine when trying to "Send To -
Recipient as an attachment". It is only Access that won't work and gives me
the error.
_______________________________________

:

Try this KB article:
http://support.microsoft.com/?id=263084


Tom
_____________________________________________

:

I have been trying to take a report in Access 2000 and send it as an
attachment through Outlook 2002. After I click the "Send to recipient as an
attachment", Access spools the report to the message body. Then after a few
second delay, I get an Access Error that has 2 lines. Line 1 says:
"Microsoft Access can't send a message for the reason stated in the Preceding
Alert". Line 2 says: "Resolve that problem, and send the message again".
There was no preceding messageor alert, so I don't know what is wrong. Can
anyone point me in the right direction to solve this problem?
 
K

K E Bitner

Yes it does. We have a WIndows 2000 server as a PDC and a Windows 2000
server for Exchange. All workstation Outlooks uses the Exchnage server for
storage (no PSTs) . All Workstations have Office 2000 Professional. The
Word and Excel programs can do a "File", "Send To" and "Mail Recipient (As
Attachment)". However, the Access program CAN NOT use this same function.

This seems to be happening on one machine only. On the other machines the
security works OK and I can send through Access. I also noticed that someone
must have tried this before because there are four different forms in the
"Outlook Security Settings" public folder, but I don't know how to deete the
ones we don't use. This may be why they gave me the project to get this to
work.

I think my last option is to uninstall Outlook and uninstall all of Office
and then re-install Office 2000 and re-install Outlook 2002 and then reapply
the Outlook Security Settings.
 
Top