Replies

Steve…thanks! I had used the other solution before I saw yours, but yours is better for regular users (especially) whom I want to keep out of the VBA editor at all costs. Again, I appreciate your quick response…

jen

Steve…thanks! I had used the other solution before I saw yours, but yours is better for regular users (especially) whom I want to keep out of the VBA editor at all costs. Again, I appreciate your quick response…

jen

HansV: that worked perfectly; thanks so much! I did not realize that I could reference a hard return in Excel VBA the same way I can in Word VBA. This one is definitely noted for future reference…

klyjen

HansV: that worked perfectly; thanks so much! I did not realize that I could reference a hard return in Excel VBA the same way I can in Word VBA. This one is definitely noted for future reference…

klyjen

AHA. Figured it out. Changing the .readonly property of a control causes a one-off. To avoid this, use the .enabled property instead.

[EDIT TO ADD]: For more details, see MSKB article 238765.

As a follow up to my last post–deleting the Data key worked on that machine…until it was rebooted. After reboot, the MRU is missing again.

Any other thoughts from anyone?

Interesting; you’re right, the placeholder is there but the DMS (PC DOCS) must be controlling it (even though Docs has been uninstalled from this machine). I can’t get to any properties on the placeholder, though, to figure this out. I’ve avoided doing anything with the Data key because this behavior is consistent across multiple machines. Removing the key did resolve the issue on a single machine, though, but I wasn’t experiencing any of the other “problems” mentioned in Phil Rabichow’s message so I am not sure the key was actually corrupt; perhaps it was a legacy setting from the DMS.

I can’t help but think there should be a way to reset that particular item without deleting the whole key, though. Perhaps that is wishful thinking…

Jen

Oh good grief.

That did it. The stupid thing is, I *knew* that–I’ve been looking up numerical values for constants for other parts of the code for a few days now.

Thanks!

I did not end up using SendKeys–after talking to the user, she wanted to be able to control whether or not the selected table was pasted into the Outlook item or not, so I simply copied it and left it on the clipboard for her to do as she pleased.

Thanks again for the help, though. I have another question about copying/pasting within a document that stems from this that I’ll be posting as a new question.

jen

[edit to fix typo]

hehehe. Oops…yes, the .copy command works much better with the ActiveWindow in there. I can’t believe that.

I’ll play around with SendKeys and see if I can make that work; I can get the cursor to the .body of the document by inserting the other text I need, so maybe I’ll add the SendKeys for Ctrl+V at that point. I’ll post back with the results.

This is not going to be a widely-used application (only two or three people) so kludging it is probably okay.

For reference, I’ve found an answer. The link needs to be in this format:

Click here

–the target=_blank attribute doesn’t work because of the increased security on the OL Today page.

Jennifer

No, that’s perfect; thanks. None of this will do anything automatically; it is still up to the user to choose to click the button, so knowing that it is generally better to keep everything together is a good thing. Thanks again.

jen

Eh, that’s too much trouble. Plus, my users are accustomed to this macro NOT spellchecking; I was just checking to see if I could add that functionality somehow. It was worth a shot…

Thanks!

Jen

And, in the spirit of continuously adding more to this thread, here’s another query:

Is there a “best practices” guide to Addins for Microsoft Outlook 2000, specifically relating to how many of them you should have? In this case, I have 4 types of functionality I want set up, plus a toolbar–should they all go into one addin, or should I have 5 separate addins?

Any thoughts would, as usual, be gratefully appreciated…

And, one more comment regarding books: I’m using Thomas Rizzo’s Programming MS Outlook and Exchange, 2d. ed. ; Jeffrey Kent and David Jung’s MS Outlook 2000 Programming Bible; Randy Byrne’s Building Applications with Outlook 2000; and Sue Mosher’s SAMS book on Outlook programming. The Mosher book was helpful in the VBA phase of various projects, but this move into VB and COM Add-ins is leaving me stumped. The others have all be helpful with various pieces, but this key piece–where does the code go??–seems to be something so basic that they all assume I should know it already.

Like I said Friday, I am new to this, so it’s been a struggle to say the least.

As for the MSForms controls–I’m in the same situation as Sam, in that I’m building something that is only going to be used for Office. For that matter, it’s only going to be used in Outlook.

Thanks again for all of your comments…

jen