Having a problem with SendObject...

When I use the following:

SendObject([ObjectType as acSendObjectType=acSendNoObject], [ObjectName], [OutputFormat], [To], [Cc], [Bcc], [Subject], [Messagetext], [EditMessage], [TemplateFile])

I get an error when code gets to [OutputFormat]. If I use "html" things work fine. I would like to use snapshot or "rtf". When I use anything other than "html" I get an error saying:

The formats that enables you to output data as a Microsoft Excel, rich-text format, MS-DOS text or HTML are missing from Windows Registry.

The weird part is if I leave the [outputformat] out of the code, when run it will pop up a box asking which format to use. I can pick anyone and it works fine.

Any suggestions on whats happening? Also how can I get this to complete the SEND automatically. I can get it to do everything in "html" format but box comes up and I have to hit SEND. Can't find anything to make it complete on its own.
Thanks,

Bill Neuman
bneumanAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
procyn00Connect With a Mentor Commented:
Great news!

SendObject([ObjectType as acSendObjectType=acSendNoObject], [ObjectName], [OutputFormat], [To], [Cc],
[Bcc], [Subject], [Messagetext], [EditMessage], [TemplateFile])


if you have editmessage = 0 then you don't have to press send!!!
0
 
joekendallCommented:
It sounds like you may need to reinstall Microsoft Office.

Thanks!

Joe
0
 
wesleystewartCommented:
I agree.  Something is boogered up.

Wes
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
procyn00Commented:
The formats are

"HTML"
"Microsoft Excel"
"MS-DOS Text"
"Rich Text Format"
"Snapshot Format"

As for sending without hitting send i'll check up more on that.
0
 
procyn00Commented:
And no!! don't reinstall office, its simply a glitch! If you type in "Snapshot" and not "Snapshot Format" it gives you the error you described.
0
 
wesleystewartCommented:
PLEASE use FALSE instead of 0.  Constants are there for a reason.

Anyway, are you sending an object or are you sending a blank message?  A blank message shoudn't prompt you for an output format.

Wes
0
 
SE081398Commented:
check to see if the latest mdac is installed
0
 
bneumanAuthor Commented:
procyn00,

I had used FALSE before but didn't work. I had it in the wrong spot. It now works! 1 problem down and 1 to go. This is on my work computer and it maybe a bad install. IT has control of the computers. I'll send the database to my home and try it out tonight.

wesleystewart - I'm sending this as an Object.
0
 
wesleystewartCommented:
"I'm sending this as an Object"

What object are you sending?  Sorry if I don't get it, but you are either sending a form, module, table, query, report, OR you are simply sending a message with no object attached.

Wes
0
All Courses

From novice to tech pro — start learning today.