A
Andrew Smith
I need to circulate a particular via email on a regular basis, and have used
the DoCmd.SendObject method to send the report via email in Snapshot format.
However, the attachment produced has the wrong name (five apparently random
characters rather than the name of the report), and a .xls extension rather
than .snp.
The obviously means that the file opens in Excel rather than the Snapshot
viewer. However the file is actually a snapshot format file, and can be
opened in the viewer if it is detached and renamed with a .snp extension.
I have used the code with several reports, and it functions correctly with
most of them. Unfortunately the one that fails is the one that I need to
send. I did a compact and repair on the database, and renamed the report.
After this the routine worked correctly - once - after that it reverted to
its normal behaviour.
Using DoCmd.OutputTo to create a saved snapshot file works correctly with
this report. Currently this is the workround that I'm using, but I'd rather
have the mail message created correctly with a single click.
I have searched for this problem on Google Groups and on the Microsoft web
site. I found two references to this identical problem on the groups search,
but no satisfactory answer could be provided in either case.
This is happening with Access 2000, Windows NT 4.0 and Lotus Notes email.
I've not yet tried to see if the same problem happens with another OS or
mail system.
I'd like to know if anyone can suggest what I should do next, or if there is
a known fix to this bug. (I guess I could write code to save the file and
then use automation to create the email message, but I'm not sure the effort
would be justified, especially as I know nothing about Notes automation).
the DoCmd.SendObject method to send the report via email in Snapshot format.
However, the attachment produced has the wrong name (five apparently random
characters rather than the name of the report), and a .xls extension rather
than .snp.
The obviously means that the file opens in Excel rather than the Snapshot
viewer. However the file is actually a snapshot format file, and can be
opened in the viewer if it is detached and renamed with a .snp extension.
I have used the code with several reports, and it functions correctly with
most of them. Unfortunately the one that fails is the one that I need to
send. I did a compact and repair on the database, and renamed the report.
After this the routine worked correctly - once - after that it reverted to
its normal behaviour.
Using DoCmd.OutputTo to create a saved snapshot file works correctly with
this report. Currently this is the workround that I'm using, but I'd rather
have the mail message created correctly with a single click.
I have searched for this problem on Google Groups and on the Microsoft web
site. I found two references to this identical problem on the groups search,
but no satisfactory answer could be provided in either case.
This is happening with Access 2000, Windows NT 4.0 and Lotus Notes email.
I've not yet tried to see if the same problem happens with another OS or
mail system.
I'd like to know if anyone can suggest what I should do next, or if there is
a known fix to this bug. (I guess I could write code to save the file and
then use automation to create the email message, but I'm not sure the effort
would be justified, especially as I know nothing about Notes automation).