Search:

I have a rule set up that automatically notifies me when a daily newsletter comes in, moves it to the correct folder, and prints it. I just changed the newsletter to HTML format recently. In normal...

Back in the ancient days predating Word 97, there used to be an option off the Window pulldown (in addition to New Window, Split, and Arrange All) that would tile two Word documents vertically side...

This certainly helps. I weeded out the "The" companies by doing a search and replace to remove that prefix from both tables. I added some parameters to the query to narrow the playing field and...

I've imported two Excel tables that I wish to relate into Access. Company names appear in both lists, but they appear with some variation. For instance, one list says John Henry Company and the...

Thanks, Hans!

Works like a charm. Now Phase II -- what's the best way to send the Word document to a third party. Do I just need to send the Word document and the accompanying spreadsheet, or is...

I'm developing a Word document that I want to be able to automatically update as the Excel workbook that contains its source data is updated. I'm using the Insert object approach with the link...

We have a file on our network that some of my colleagues would like to access while traveling. I set up a slick little client rule, specified a subject line ("Send me Bulletin Board"), attached the...

Wow, that was too easy. Yes. Thanks!

I'm using Routing for the first time and I've circulated the document to all recipients simultaneously but haven't heard back from anybody yet. I've had some verbal changes and incorporated them and...

<P ID="edit" class=small>(Edited by MaryJ on 23-Jan-03 01:33. make screenshot smaller)</P>I've deleted the .NICK files and we'll see what happens. I'm attaching the properties screen that I see when...

Hi, Mary -- When I doubleclick on the message, it opens the contact; and when I doubleclick on the address there, the only option is RTF, which is not checked. The list software is L-Soft list server...

I've escaped in the last couple of days with a couple of gentle reminders from a mailing list that I track regularly that HTML posts are not welcome there. So I changed my default e-mail format to...

I volunteer for a small church library and want to use the merge features of Word 97 in concert with Outlook Express 5 (I'm doing this at home on an old Win95 machine) to send out overdue notices via...

Thank you so much! All of you on Woody's Lounge have been real life-savers today.

Very, very close. It's an elegant solution, and I very much appreciate it. I realized when testing, however, that I need to add one final condition:

The IF function should ONLY apply when the Item...

One more quirk I just came across:

IF the value in the Underrun column (B6) is less than the value of the Overrun column in the row immediately above (F5)
THEN: B6 should = F5+1

How do I...

You're right, Andrew. Perhaps I was too quick on the trigger. I also found that John's suggestion works very nicely. Thanks to both for the prompt and effective help!!

Thanks, with just a little tweaking, I think I'm there. I tried this and it appears to work:

=IF(D2<5000,D2*80%,IF(D2>5000<10000,D2*85%,IF(D2>10000,D2*90%)))

I'm trying to solve a situation where the results in columns B and F vary with what's contained in column D. I'm having difficulty with the syntax in creating a nested IF statement to get my results....

Works like a charm. Thanks!

I'm trying to find a way to calculate an employee's next anniversary date. I'm sure there must be a simpler, lower-maintenance approach than the one I've taken in the attached sheet, where the...

Jan, this is great! I'm working on a workbook and searching for part numbers across multiple sheets for different customers. One suggestion I would make is to add some kind of "memory" for recent...