Replies

worked like a charm – thanx

do i feel dumb
The excel session was in full screen mode

Thanx for your question.
I’m posting this for a client and apparently the problem is more sever than I thought. When Excel opens, the taskbar is hidden from view. This effect apparently does not happen with any other application.
I think i’ll pursue this in a windows lounge

Thanx for reminding me, that although I can’t filter on rows, I can filter on fields (columns) using the field mapping – I just tried it
excel is mostly fine and I have a fair comfort level with it.
I do have one major problem with excel and the way it interacts with contacts: two fields: (1) business address, and (2) business street address. These fields have embedded carriage returns and/or line feeds and these drive me crazy when using them in excel. They do not “copy and paste” intuitively and they do not export to excel intuitively. I find that exporting to a csv field and then converting the csv to an excel file works better, but this is a pain in the neck.

barry,

Thanks, This idea might solve some other problems. For example, my main contacts folder is too large to export to a floppy. If i break it up into chunks (by copying, say the first 500 to another folder), I might be able to fit each chunk on multiple floppies.

thanx again

art

I have no trouble changing the font on an individual basis by right clicking on the note and changing font.
However, I would like to increase the font automatically for each NEW contact without having to right click and change the font

thanx, it worked very nicely.
I’m going to try to use this as a springboard for learning the use of macros

devious!

thanx

art

I’m new to this lounge! where is the VBA code located? How can I access it?

I tried your array formula and it worked – thanx

I would like to understand what the array formula is doing

Why the construct “1/countif….)”? Does this mean “1 divided by the result of the countif”?
I would guess not.

I assume that the first a1:a6 represents the range being checked.

I’m guessing that the stuff following the comma breaks down into “=a1 or =a2 or =a3 or =a4 or =a5 or =a6”. How does it know to check “unique” occurrences?

Why the control-shift-enter (i read in a book that this places the formula in each of the array cells, but I don’t know what that means)!

The counta – now that’s something i can understand

I tried saving and it worked. Thanx a lot. Thanx also for the article.
If I have multiple PSTs, is there a “primary” PST?

Regular Windows commands (such as save, save as, copy and paste) have surprising (to me) effects in Outlook and related (e. g., explorer .vcf) environments which are not covered in the Outlook textbooks that I have read. The file structure contained within the pst is also unusual, but that is because outlook manages its own “hierarchy”. I’m learning more and more each day about outlook’s quirks

Thanx for the reply.
although i did not state it in my post, my question about carriage returns was really limited to Outlook Contacts (e. g., Contact Notes, Contact Address).
In MS Word or MS Excel, I often use a carriage return to arrange text so that it will fit left to right on a printed page. (as a matter of fact, In composing this reply,
I am using carriage returns so that my text does not roll to the right of my screen, where I cannot see it without scrolling.)

By the way, I’m pretty new to this posting business. If I want to clarify a previous post, do I clarify it in my response to you, or is there a way I can “alter”
my original post?

thanx