acFormatSNP Not available for email

[JimB]

I'm trying to automate emailing some reports and am attempting to use the
DoCmd.SendObject method with an output format of acFormatSNP however
Access2000 does not recognize the format. I get the following error message:

"The formats that enable you to output data as a Microsoft Excel, rich-text
format, MS-DOS text, or HTML file are missing from the Windows registry."

If I use an output format of acFormatRTF or acFormatXLS it works fine.

Also, if I try to use the menu command of File-SendTo, the *.snp format does
not show up there either.

Am i using too old a version of Access to recognize this format? The about
screen shows Microsoft Access 2000 (9.0.3821 SR-1).

Note that the Office Applications for our company are administered by the IS
department and I can't install a service pak upgrade on my own.

Thanks in advance

Jim B.

 

[Rick Brandt]

I'm trying to automate emailing some reports and am attempting to use
the DoCmd.SendObject method with an output format of acFormatSNP
however Access2000 does not recognize the format. I get the
following error message:

"The formats that enable you to output data as a Microsoft Excel,
rich-text format, MS-DOS text, or HTML file are missing from the
Windows registry."

As you can tell this error message was never updated to include Snapshot
format. You are in fact missing some registry entries. Look for the
following (the version number will vary according to your version of
Access)...

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0\Access\Jet\3.5\ISAM
Formats\Snapshot Format

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0\Access\Jet\3.5\ISAM
Formats\Snapshot Format

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0\Access\Jet\3.5\ISAM
Formats\Snapshot Format

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\8.0\Access\Report Formats

 

[JimB]

Thanks For the input. My IS department does not give me access to the run
command, so I'll have to go through them to see if they can update my
registry.