Error Message on SendObject

[Jim]

Hi,

I haven't posted here before, but I'm not exactly a newbie.

I am getting an error message saying I can't email atable
using:

subject = "Top 20 for London"
texter = "Please find attached the London Top 20 Report"
DoCmd.SendObject
acSendTable, "LONDON_TOP20", "ACFormatxls", mailer, , ,
subject, tester, False

Access is coming back with the response:

"The formats that enable you to output data as MS Excel
file are missing from the registry"

I have tried re-installing acess using run all from my
computer to no avail??

Anyone out there got any ideas.

Thanks in Advance.

Jim

 

[Cheval]

How about re-installing Excel?

 

[Guest]

Cheval,

Thanks, I never thought of that. You think the registry
settings come from the applucations and not Acess, it's
certainly worth a try.