acFormatSNP Not available for email

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JimB - 21 Oct 2005 20:26 GMT

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.

Reply to this Message

Rick Brandt - 24 Oct 2005 14:04 GMT

> I'm trying to automate emailing some reports and am attempting to use
> the DoCmd.SendObject method with an output format of acFormatSNP
[quoted text clipped - 4 lines]
> 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

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

JimB - 24 Oct 2005 15:49 GMT

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.

> I'm trying to automate emailing some reports and am attempting to use the
> DoCmd.SendObject method with an output format of acFormatSNP however
[quoted text clipped - 17 lines]
>
> Jim B.

Reply to this Message