Replies

(Edited by jrklein on 22-Jan-03 20:13. )

Greetings
Your sheet comes close to what I am looking for and I appreciate all your help

My constraints so you understand are the following
1. The date at the top is a month ahead of todays date so when I bill in January for February the word merge automatically shows Rent due for FEBRUARY IS

Steve:
I have attached a limited spreadsheet including copies of the area of leases that show increases. I am looking for insight on how to best structure a computer automation to check for rent increases each time I send a monthly invoice for payment of rent. that will also increase the rent without any input from me. I can keep a separate spreadsheet, or use an access database. Again the main spreadsheet links to a word document for invoices. It is updating the main excel spreadsheet each month with the correct rent amount that is the area I am stuck on both structurally and mechanically
Thanks for any help
Jerme

Did my reply make sense????
Jerome

Spreadsheet A:
X technologies Photographer
rent front $1,749.00 rent $1,643.00
water $0.00 water $0.00
waste $18.32 waste $18.32
Total $1,767.32 Total $1,661.32
The totals ie 1767.32 and 1661.32 are then linked to a word letter merge Dear Computer you owe for Feb 1767.32 and Dear Photographer you owe……
The difficulty for me is knowing wheter the rent should be increased this month as determined by a lease.
I can store in any way, ie spreadsheet B or database B, that makes it easy that say Feb 2003 the rent for the photographer is now 1693 and in March the rent for the computer is now 1752.and in year 2004 etc.as determined by their leases, I would have to enter say 5 years of increases for each tenant.
Do you see the problem I am having, I just do not want to keep manually checking another spreadsheet, eg spreadsheet B, to see if it is the required month to increase which tenant and then by how much.for spreadsheet A that the word letter does a letter merge from. I have access database, but I don’t think that will be of big help???
Jerome

Leif the 192573 : Image Previews Not Displayed in Windows Explorer article did the trick. Added the keys to the registry and back working. Many many thanks
My hard drive also crashed so I could not pick up my Email until today.
THanks
Jerome

Andrew:
Many thanks, I took your advice since whatever I did made it worse, I uninstalled office, and reinstalled it from the original disc, could not even get it to install off the sp1 disc from MSFT./ Now it seems to work fine. Detect and Repair is worthless once you use any upgraded files, Msft really needs to allow us to have some kind of ini file to keep as a copy of a correct instillation.
ALSO I CANT SEEM TO GET JPG FILES TO IMAGE IN THUMBNAIL VIEW ON WINDOWS EXPLORER NOW, BMP AND TIF DO. Tried going into control panel and using advanced folder options to assign it to photo editor, but no improvement. Any thoughts
Thanks as always
Jerome

Perfect, I think all the bases are covered.
Many thanks, you are a genius
Jerome

Thanks, but now it does not work for N/A – N/A cells gives value error.
Sorry to be a pain
Jerome

Actually only works for 0,n/a,and positve number CELLS. GET ERROR VALUE WITH NEGATIVE NUMBERS IE. -0.04 IN A CELL.
Is there a way of modifying to allow for negative numbers to work
Jerome

Perfect
Many thanks
Jerome

Slipstick.com was perfect
Thanks
Jerome

I dont like to archive to hard juggling archive files.
I am using the palm software to sync.
Some one recommended XTNDConnect PC* (formerly known as Enterprise Harmony `99) 3.1 as this is supposed to use dates.
No trial version

Yes this works, I was doing it into cc field. Did not know about the bcc field in the address book
Many thanks
Jerome

I tried this, but it still shows the individual email address in the email in the header of the received email: cc: PLASTICSURGEON@prodigy.net ; Fdn@prodigy.net where botox group had these 2 email addresses. should have just shown botox.
So does not quite accomplish what I want to accomplish. I want to group patients together, but most patients won’t be happy having their email addresses seen by other patients.
Jerome Klein

Thanks, I tried as you suggested. And it does not seem to hold this setting for more than an hour either.
Is there something that I do not understand with IE6???
Thanks
Jerome