Replies

Thank you, John. Worked like a charm . Even better than I had hoped, because although it took all the titles off the display name, it puts them in when I insert them. Also, when I sync’d to my PDA, it left all the titles in, so it works just like the desktop Outlook. I expected it to take awhile to sync, but it didn’t require any changes. Anyway, thanks again for all your time. I can’t wait to get the rest of my computer back in order so I can start contributing again.

Hi John:
I use the following steps to insert the contact address into Word:
1. Start Outlook (not actually necessary, but it saves one click in Word).
2. Open any document in Word.
3. I have an Insert Address button on my toolbar, but it’s the same one that’s found under Tools/Letters & Mailings…/Envelopes & Labels…
4. On the top of the dialog box that opens is an open book icon, which is the insert address icon. I click it & select a name from the list.

I was inconsistent in the way I entered contacts. Some had a title, some didn’t. In Word, there is an autotext entry which inserts the title, followed by the display name, when you use the Insert Address command with Outlook Contacts as a database. I could change the autotext entry in Word to omit the title, but then some names wouldn’t have a title. I’m guessing that I caused this in Outlook by entering something like: John Jones (& then adding the title “Mr.”) in some circumstances & in others, I entered Mr. John Jones. Outlook 2003 seems to understand that the titles are not part of the name, but older versions of Outlook, where I created many of the contact names, didn’t understand this.

If the macro can be altered easily, that would be the preferred solution. I appreciate the trouble that you’ve gone to, John. If it requires too much work, I think I can just do it manually. At 4/minute, it’ll probably just take over a hour. At least it’s not a business list containing thousands.

OK, Mark. Thanks for the advice. I’ll set a password & make a password reset disk.

Hi John:
No problem; I appreciate the help. I should have made a backup anyhow. Two questions:
1) I know I can make a copy of my Outlook.pst file, try out the macro, & simply delete the Outlook.pst file & rename the copy if it doesn’t work out. Is there a way to backup just the contacts, as the Outlook.pst file backs up everything.
2) Will the macro, with your changes, delete the titles & then replace them with the same titles? i.e. will
Mr. & Mrs. John Jones
Mr. Tom Smith

end up with the same titles after running your macro?

I’m not using a mail merge in Word. Word has an “Insert Address” button, which inserts the name & address from a database at the insertion point. It will use Outlook contacts list. Since I use it to address individual letters, including the title, I don’t want to lose the title. I don’t know what I did to cause the problem, or why deleting & retyping them cures the problem, but it does. My other option is to go through a few hundred names individually, but, of course, a macro would be faster.

Thanks again,

Hi John:
Thanks for this. But what it did is remove everything before the name except the “&”. Now each name has something like “& John Jones”. I wanted to keep the title, but not have it repeat twice in Word. Can I get the titles back?

Later: OK. I got the titles back by restoring from a backup. Is it possible to have the macro step through each contact, hold the titles in some sort of variable, delete the title, save it, then put the title back & save it. It would also have to work for titles like Mr. & Mrs., Dr. & Mrs. without leaving the and. Thanks again for all the work.

Yes, we share a connection to the Internet, using a wireless router, from the cable company. Would that put my machine at risk without a password? I know that a technician that used remote assistance on my machine couldn’t connect until I put a password on the account, so I thought it might be safer not to have any password?

Hi Mark:
Thanks for the response. I’m not on a network, except for my wireless connection to my daughter’s Mac, & she doesn’t use my machine. Does that count as a network?

Hi Again:
Well, I got rid of the script error, although I don’t know what caused it. In the “Phil” user account, I went to Start/Run & typed

control userpasswords2 & pressed .

In the dialog box, I then checked “Users must enter a username & password to use this computer”. Without checking apply, I clicked on the Administrator account, then Reset Password, left it blank, & then clicked applied. This reset the Administrator account to have no password. Then I unchecked the box to require a username & password.

I got no warning messages by doing this & no script errors, so problem 1 is solved & I guess #2 also. I’m still not sure if it’s better to have a password to either the Administrator or Phil account.

Hi John:
Thank you so much for this. I just had the identical problem & your solution (&, of course, Jefferson’s star post above) solved it.

Welcome to the Lounge. Actually, you can do it with a single click.

I see Jefferson has already given you a solution, but I thought I’d mention another way also. You can use two single quotes, which will appear as a double quotes.
Cheers,

I see what you mean. I hadn’t tested it in a table cell. I’ll see if I can find anything & get back.

With respect to the mouse, that’s how Word works, when the form isn’t protected. Once the document is protected for forms, it will work the way you expect. To select only a few characters within the form field, you can either use the arrow keys or you can click inside the field, release, click again, & hold the mouse motionless for a couple of seconds (you’ll see a vertical hashed line), & then release again. However, you should be able to move the cursor within the field by using the arrow keys. If you use the shift key in conjunction with the arrow key, you can select portions of the field, EXCEPT when you get to either end. Then using the shift + arrow key selects the whole field.

That last bit of behavior can be changed by going to Tools/Options/Compatibility tab & UNchecking “Select entire field with first or last character”.
Hope this helps,

Hi Karen:
Definitely not one that is hyperlinked. I think the closest that you could come is to create an index in each document, use Find/Replace to add some reference at the beginning of the index to let you know what document it pertains to, & then copy them into a master document. Others may have a better solution, but I can’t think of one. Quite frankly, if I’m looking for something that may be contained in one or more of several documents, I use a search engine like Wilbur.

Wrong. See post 529,101

Hi Judith:
The RD field will create a combined TOC, TOF, or TOA. Assuming that is what you want, you could put a document name in the heading style at the beginning of each of the documents. That would then show up at the beginning of each part of the TOC.
Cheers,
See post 529,101