Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access SendObject (VBA and Macro get same error)

Status
Not open for further replies.

sstump

Technical User
Oct 29, 2003
56
US
I recently ran into an DLL issue and our IT department repaired Windows, as well as reinstalled Office Premium. Before this I had several reports that would run and send on they're own. Now since the Repair of Windows and reinstall of Office I am unable to run these processes and I get the message:
"Microsoft Access can't send a message for the reason stated in the preceding alert. Resolve that problem, and then send the message again."
However there is no preceding alert. I get this same message when I do a simple sendobject via Macro or VBA.

Is there something I'm missing? A Registry entry? Something??

P.S.
This isn't related to the security updated that required me to install 'ClickYes' about 6-9 months ago.

Thanks in advance!
 
As an additional note...When I mark the 'Sendobject', 'edit message' to "YES" it opens the email with the attachment and allows me to send it that way...however that requires intervention I'd rather not have.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top