This is probably happening because of the different versions of Outlook
used. Not sure if early or late binding is used, but you can check out the
code in your mailto macro by opening your form, pressing ALT-F11 to enter
the VBE window. Click the "Tools" menu, select "References" and see if any
of the top "checked" items say "Missing". Might be the object model for
Outlook 2000. If so, you can unselect that version and scroll down to find
the version for 97.
If there isn't anything checked, then the reference is in the code. In the
macro that sends the actual message look at the version number towards the
top that declares the Outlook variable and opens Outlook. It will need to
be reduced one number (i.e., Outlook XP is 10.0, 2000 is 9.0, 97 is 8.0).
If neither one of these makes sense, is readily apparent, etc., holler back
and someone much more versed in VBA will help you out (I hope)! I'm already
in a little over my head, but I've run into these things before so I pretty
sure one of these is the culprits.
Keep in mind that you will either need to have two versions of this form for
the 97 and 2000 users or the code will need to include an error-checking
section that if it checks for 9.0 and finds an error, it skips down to the
exact same type of macro code section for the 8.0 stuff. I can provide a
few examples of that if needed. Better yet, copy and paste your code in a
reply post and someone will help out.
Good Luck!
--
Bill Foley, Microsoft MVP (PowerPoint)
www.pttinc.com
Check out PPT FAQs at:
http://www.rdpslides.com/pptfaq/
"Success, something you measure when you are through succeeding."
Faris said:
I am trying to design a Form in Word 97 that submits the data to an Email
when the user clicks the submit button.
I have used the mailto: command inthe action and when clicking the button,
the email is created, with the correct address, but no data and no automatic
send to Outbox is performed. The same form works in Word 2000 but this one
has to be in 97.
