B
Bill Johnson
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?
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?