IF help #2
i have to calulate a Excel Spread sheet on a weekly basis
so i know how to pay staff for product sales
the file is output from a weird old dos program into a excel document
I have 2 sheet inside a Excel document
lets call them Sheet 1 and sheet 2
has 3 columums
Date Product and $Due
$due Columum is not filled and i need this to auto fill
has a list of products in Columum 1 and 2 has the price on it
I need to do a if statement
that if sheet 1 PRODUCT = SHEET 2 PRODUCT THEN sh...Replication
This is a multi-part message in MIME format.
I was told that Exchange 2003 has store replication a feature "out =
of the box" that I would like to confirm.
The company I work for is looking for a DR / BC plan. We are =
evaluating software that will allow us to REAL TIME replicate the data =
on one exchange server, to a standby server so that in the event of a =
disaster, all we have to do is activate the standby server and we wil...POP message #2
The cable company I use does not support Outlook. I keep
getting POP. messages to put in my name and password
every minute or so. Cable company says I have to use
Outlook Express. How do I turn off Outlook and make
Express dominant. Keep getting errors when I attempt to
switch over and mail keeps going to Outlook
What version of Outlook do you have? What is the exact text of the error
message you're getting? Outlook will work fine for receiving mail from your
cable company - it's just that the company doesn't want to go to the trouble
of telling you how to configure it p...Bookkeeper #2
I have MsMoney 04 but want to use a business software called 'Bookkeeper' Is
anyone familiar on how to transfer all my check acct. register from money to
bookkeeper. do you think it would be best to use quickbooks instead. thanks
FWIW, most versions of Microsoft Office Accounting 2008 are able import
from Money as well as Excel and Quicken.
If you can manage with the Express version, the price is right - FREE.
"Jay" <Jay@discussions.microsoft.com> wrote in message
> I have MsMoney 04 but want...cannot access mailbox #2
Hi, I have a user who cannot access his mialbox.
He is using outlook2003. Exchange server is 2003.
Pst file is ok, no corruption. When he click his mialbox from outlook, the
message said:" the set of folders count not be opened."
I tried re-creating his profile and rebooted email server. It did not help.
try with OWA
"Rick" <Rick@discussions.microsoft.com> wrote in message
> Hi, I have a user wh...Transferring mail #2
Just got Outlook 2007...have been using Windows Live Mail. Is there a
(relatively) easy way to transfer my files from Live Mail to Outlook?
Tracy H. wrote:
> Just got Outlook 2007...have been using Windows Live Mail. Is there a
> (relatively) easy way to transfer my files from Live Mail to Outlook?
Outlook can import from Outlook Express (the same as Live mail)
Dean Earley (firstname.lastname@example.org)
i-Catcher Development Team
"Dean Earley" <email@example.com> wrote in message
> Tracy H. wrote...How do i make a poster with 2 pages
mollyman42million <firstname.lastname@example.org> was
very recently heard to utter:
> Hello all
Do you mean a large poster tiled onto two pages? Or some kind of strange
poster with a front and a back?
Ed Bennett - MVP Microsoft Publisher
We started replication on the hq database and are getting errors when we run
the 401's on the customer and shipto tables. It seems to be picking up the
Invalid column name 'msrepl_trn_version'
anyone been succesfull with replication.
any help would be greatly appreciated
Don't mind but if you have done this in live enviornment then it is worng,
first of all no where it is written that it support the replication
technology, I know i have put the replication script on the newsgroup for the
store operation only becuase I have been us...compare 2 columns and select the lowest
I have simple question
I have 2 coumns A and B
A1 is text and B1 is numbers and so on.. depending of B columns numbers , i
want colums C to show alway lowest numbers on top, but also text
like if A1,B1 is Mike 29
then A2,B2 is Josh 34, then column C shows Mike 29 but on top, not as a
Couldn't you just sort by column B in ascending order and leave the data right
where it is?
If that's not ok, how about an alternative?
I'd add a new column C.
Then use a formula like this in C1:
and drag down...license issue
here's an interesting one...
on dc, it complain a couple weeks ago that windows server and exchang is out
there are 50 and about 95 were being used. i went in and revoked licence of
those who don't work here anymore and users that existed under the old NT
domain. that brought the licensed users down to about 35. this morning,
license service said again it was out of licenses, and all those that were
revoked, all had usage again; the last access date being the last day they
worked here, or (in the case of users from the old NT domain) were from
2002. how could th...Triple emails #2
I have just installed Outlook from my Office XP Pro and I get three copies of each an every email. HELP! Thanks
...Calendar not updated #2
Anybody can help me ? I have problem using mic. outlook
(MAPI). When I receive Invitation Meeting in Inbox
folder, my calendar doesn't update automatically but I
have to open the email first then my calendar will be
updated. After I open that invitation email, if I receive
another invitation meeting, my calendar will be updated
the problem is if I don't open the invitation meeting my
calendar won't be updated.
Please your information
...Outlook Connector causes Outlook 2007 to not shutdown #2
I have had this problem with Outlook 2007 not shutting down for a long time,
but recently, through the process of elimination, I have found that it is
being caused by one of my Hotmail accounts, through the Outlook Connector.
The actual problem is that Outlook does not exit properly. If I close it,
the process can still be seen in Task Manager. When I try to shut down the
machine, I get a message saying that Outlook will not shut down, and I need
to force it to close. This means that sometimes Outlook needs to check the
message store when I start it up again.
This does not happen when I r...Date Scaling Issue
I have created an x-y scatter chart that has dates along the x-axis
(mm/dd/yy). The first date on the chart does not correspond to the first date
in my source data! When I go to change the min scale for the x-axis instead
of seeing a starting date I see a huge number(38790) that in no way seems to
corralate with my data (03/14/06) (note that my end point in this scaling
section is also a large number). My data cells that are used for this x-axis
data have been formated to be dates. I do want gaps between my dates that
match how much time has passed (if possible), but I do not want my da...Printing issue
I have OS X.3.9 and Office 2004 11.1
I print to a Lexmark Optra S 2455
I've installed the latest driver.
Since moving from os 9 and office 98 when ever anyone in the office prints a
new letter size document it comes out on legal size paper even tho' the
default paper size in the printer set up is US letter.
Sometimes even when you set the paper size to US letter in page set up it
still prints legal. To reliably get letter size paper users must specify the
tray to use. This wasn't necessary before.
Is this another great new feature?
What is the paper si...Public Folder Replication error #4
We have windows 2000 domain, exchange 20003 running on windows 2003 member
server, we have to windows 2000 sites, all AD replication is OK, but only
public folder replication did not happen, between two servers,
I am getting following NT event application event error
EVENT ID 3093
Error -1603 reading property 0x36010003 on object type tbtFolder from
database "First Storage Group\Public Folder Store
Also I have following event 3085
Error 0x8004010f occurred while generating an outgoing replication message.
Database "First Storage Group\Pub...Gartner response Cards envelope template 5 1/2 width 81/2 high
trying to find an envelope template for Gartner response Cards
It is going to take 2 pieces of stock to make one envelope unless you are using
Gartner Cards are nice items, are you sure you want to cut and glue?
Mary Sauer MSFT MVP
"Joe" <Joe@discussions.microsoft.com> wrote in message
> trying to find an envelope template for Gartner response Cards
...Xml into Dataset #2
I'm reading the following xml file into a Dataset but there are only 4
datatables in my dataset (which should be 5)
Is that because I have two nodes with the same name (detail) in my xml file?
how can I fix this?
Thanks for your time.
<?xml version="1.0" ?>
After a failed update to SQL 2008 SP1 + CU8, I restored master, and
then tried to do a repair on the install to make sure I was back to
SP1 only. I now get the following error:
SQL Server 2008 - Developer Edition x64
Windows Server 2008 R2 x64
There was an error executing the Replication upgrade scripts
TITLE: Microsoft SQL Server 2008 Setup
The following error has occurred:
There was an error executing the Replication upgrade scripts. See the
SQL Server error log for details.
For help, click:
http://go.microsoft.com/fwlink?LinkID=204...Help for compare 2 data table in excel format!`
I got 2 data table in excel format, but I want to know the different between
Table 1, Table 2,
Inventory ID Qty InventoryID Qty
CC2210 5 AA1101 5
CC2211 8 CC2210 9
CC2212 100 CC2211 160
Between 2 table, I want catch the inventoryID AA1101 IS THE DEFFERENT.
How ahould I do ??
If you're looki...Outlook Shortcuts #2
Want to add some Personal Shortcuts so I can
appropriately "store" various messages by content
Could you elaborate on what you're trying to do?
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
"email@example.com" <firstname.lastname@example.org> wrote in
> Want to add some Personal Shortcuts so I can
> appropriately "store" various messages by co...Spacing #2
Trim removes spacing in the beginning and end of word.
How can i delete a spacing betwee two words (name) ex "De Wit" > i want
You can use:
to remove all the spaces (leading/trailing/embedded)
if you really wanted lower case.
Luc Vandenhoeck wrote:
> Trim removes spacing in the beginning and end of word.
> How can i delete a spacing betwee two words (name) ex "De Wit" > i want
> THX Luc
..."custom dictionary not available" issue
Operating System: Mac OS X 10.6 (Snow Leopard)
Every 2-3 weeks I get the message that my custom dictionary cannot be accessed. I do what others have posted here and on other forums: I go into Preferences/spelling and grammar, make sure no language is selected, check the dictionary file for odd things (asterisks, etc.) and clear. But both times I've tried it, it doesn't fix the problem, and I start a new custom dictionary... <br><br>Which works for a few weeks until AGAIN the dialog box pops up saying the Custom Dic. is not available. I...IMAP replication
First post to this newsgroup.
I am wondering if it is possible to have Exchange sync itself with an IMAP
server. We have an in house Exchange server that is used to manage
Contacts, Calendars, and Tasks, however mail is handled by an external IMAP
The ideal solution would be to have the two kept in sync, so any changes
made on the Exchange server would reflect on the IMAP server and vice versa
for each user.
Is this just a pipe dream?
: We have an in house Exchange server that is used to manage
: Contacts, Calendars, and Tasks, however mai...MAcro Problem (probably easy) #2
Okay, here's another easy one. I want a formula that basically says "I
DATE IN COLUMN D => TODAY, THEN COLOR = RED." I can do the conditiona
format, but I'm having trouble figuring out the formula syntax. An
bludovico's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1480
View this thread: http://www.excelforum.com/showthread.php?threadid=26505
if the date you're looking at is in a particular cell (ie D2) use
in conditional formatting