SendObject function attaches report in the Wrong Format

G

Guest

What is puzzling, is this function was working up until Access crashed one
time. I performed the Database repair and now instead of attaching the
report in SNP format, it enters a default Naming Convention (like CDB35.XLS)
and an Excel extension.

DoCmd.SendObject acSendReport, stDocName, acFormatSNP, msgTo, msgCC, msgBCC,
msgSub, msgBod

I'm really confused because another report procedure in the same database
uses a procedure with very similar code that works perfectly, and if I run
this procedure from another workstation it works perfectly as well. I'm
sending the email and report to Lotus Notes. Have you seen this before?
 
G

Guest

I was able to fix this by changing the Report Caption (the name that Access
uses when attaching the report) in the Report Properties. It doesn't
explain why the problem began in the first place, or why it should work on
another workstation, but it is something I've noted in the VB code in case it
ever comes up again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top