2nd POST - Snapshot files sent by email with SendObject have wrong name and .xls extension

[Andrew Smith]

I posted this a few days ago and have had no replies. Do I take it from this
that there is no know solution to this problem?
---

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).

 

[Guest]

Andrew

I am working on finding a solution to the same problem. I will let you know if I stumble upon anything, please let me know if you find any info as well. I could not find your email to reply directly

Thanks

Mary Ann

 

[Andrew Smith]

Thanks Mary Ann.

I'm still no further on with this. Which email client are you using?

Andy

Andrew,

I am working on finding a solution to the same problem. I will let you

know if I stumble upon anything, please let me know if you find any info as
well. I could not find your email to reply directly.

 

[Larry Jones]

I am using Office XP on Windows XP and this seems to be working for me
(at least I think this is what you are trying). I use the following
syntax:

DoCmd.SendObject acSendReport, "rptItinerary",
"SnapshotFormat(*.snp)", Me.txtEmail, , , "Itinerary", strMsg

This pops up the user's Outlook email, letting them modifiy the
default message and send the report.

So maybe there is a patch that is needed for your version?

 

[Andrew Smith]

Yes, that's what I'm doing. It works correctly some of the time, but
sometimes (including with the report that I need to send regularly) the
attachement is created with the wrong file name - something like C30BA.xls
(I forget the first part of the name, and I'm not sure it's the same every
time). Despite the .xls extension, it is actually a snapshot format file.
The same thing happens if the email is sent via the user interface, so it's
not a code problem.

I've not found a solution, or a patch, but there are a couple of other
messages that indicate that I'm not the only one to have had this problem.