Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 360
  • Last Modified:

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
0
bneuman
Asked:
bneuman
1 Solution
 
joekendallCommented:
It sounds like you may need to reinstall Microsoft Office.

Thanks!

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

Wes
0
 
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
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
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
 
procyn00Commented:
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now