OUTLOOK NEWS #2
Once again my news does not work. When I click it, I get a folder full of
outlook stuff. This has happened before and someone here helped me. I,
unfortunately, do not remember what to do. Next time I will save the
instructions as this seems to be happening again and again. The word news
appears at the top but when clicked there is nothing but the folder. Help
You mean you cannot start the Newsreader from within Outlook? Go to Internet
Explorer and make sure Outlook Express is set as the default newreader.
For other solutions see;
http://www.howto-outlook.com/faq/news....lookup problem #2
I have a sheet with J11 called Buyers # and K11 called Buyers name. On the
next sheet called Buyers there is a list with B1 being the buyers number,
and C2 is the buyers names. How can I enter a number on the first sheet and
get the corresponding name to come up?
Have a look in HELP index for VLOOKUP
"Todd Fischer" <firstname.lastname@example.org> wrote in message
> I have a sheet with J11 called Buyers # and K11 called Buyers name. On the
> next sheet called Buyers there is a...3.0 to 4.0 conversion
We are getting an error when the 4.0 install is doing it's upgrade review. We
are getting "The unique constraints in the CRM database are not consistent
with the Dynamics CRM 3.0"
Then we get the "Stored procedures in the CRM database are not consistent..."
Then "Setup has detected customizations that have not been published..."
However, any customizations, and they are minor, are published. Anybody have
...Similar multiple entries not downloading #2
I am facing issue in downloading similar multiple transactions - eg-
I have 3 southwest air ticket purchase transactions on a particualr day ,
where each tickets is for $60. Now in my bank statement, these appear as -
1-aug Southwest $60
1-aug Southwest $60
1-aug Southwest $60
- which is correct as i purchased 3 tickets.
now when i download in money, only one transaction comes as -
1-aug Southwest $60
-other 2 are not downloaded. It seems money is treating other two as
Can someone tell me how can i get such t...importing pst files #3
I've had to reload Office 2000. I am now trying to import
the Outlook backup I made, which is a .pst file. I'm
following the import directions, Outlook is performing
the task, but nothing is showing up - I am unable to see
any of my contacts, emails, or folders I created.
HELP! I'm desperate!
Why are you trying to import? Why not just use the old .pst file as your
main Outlook data file? If you need help in doing this, go to Help | About
Microsoft Outlook and tell us whether Outlook is configured in Internet Mail
Only or Corporate/Workgroup mode.
Sue Mosher, Outlook M...Can an IF statement be used for 3 options?
Can I setup an IF statement to select between 3 options? For example, I have
3 divisions with 5 teams in each division. Can I setup a formula to have it
enter the proper division if I have the team name entered. For example, if I
have BOS in cell B2 how do I get cell C2 to say AL EAST. I have a tab called
divisions with the divisions listed in cells A1, A2, and A3. The teams from
division A1 are listed in cells A2, A3, A4, A5, and A6. Thanks.
Assuming your division names are in A1:C1 and teams are
in the 5 rows below each division (A2:C6), then try:
=OFFSET(divisions!A1,,MAX(IF(I...I want a cell should 2 accept only >=0 or <=30 or Y or N
I want a cell should to accept >=0 or <=30 or Y or N
In "Custom" for Data Validation.
"Brijesh Poojary" <Brijesh Poojary@discussions.microsoft.com> wrote in
> I want a cell should to accept >=0 or <=30 or Y or N
When we open a workbook, we would like the header/footer
to default to an 8 instead of 10. We always end up
changing it from a 10 to an 8. Any way for this to
default instead of creating a new template?
You need to save a template file (called Book or Sheet) in the XLSTART
folder. Look in Help under Standard Template for more details.
"Kim" <email@example.com> wrote in message
> When we open a workbook, we would like the header/footer
> to default to an 8 instead of 10. We always ...Smartlist export to Excel #2
Quantities for Inventory Items are set-up in our database with zero decimals.
When exporting 'Inventory Purchase Receipt' information to Excel, quantities
receipt and quantities sold, greather than 1000, are shown only the first
digit in Excel, for example 4,799 is shown for 4.
Any idea how to fix it???
Sounds more likely that the file is being exported as a csv using the print
function in smartlist.
> Quantities for Inventory Items are set-up in our database with zero decimals.
> When exporting 'Inventory Purchase ...source sheet to auto fill 2 other sheets
sheet1 witch is what i fill out (source data)i want the data to be auto filld
into the next too sheets..an to also sort the the data (by date- verry
important) from the 1st sheet. all 3 sheets r totaly difernt..same names
thx for any help
Shouldn't minus a squared number be a minus number? In Excel -2^2 = 4. To
keep it negative I have to write -(2^2). It's very easy to make mistakes
because I also work with Quattro Pro which works differently. Is there a way
to customize this in Excel so that -2^2 = -4?
In Excel the negation takes precedence over the power operator.
However, subtraction is a lower priority.
results in -4.
Does that help?
"Tim Walters" <timwalters@DROPTHISterra.es> wrote in message
> Sho...Account format change #3
framework length = 14
seg 3 natural
in a test environment
under tools setup acct format made the changes so that
length = 14 seg1=3 seg2 =4 no change to seg3 or 4
this keeps us within the framework
ex acct 0-401-5000-399 became 0ss-401s-5000-399 s=space
I then ran the prof tools modifier
final acct 000-0401-5000-399 with the actindx of
0-401-5000-399 = to the new acct 000-0401-5000-399
only results that I have an issue with so far is the gl40200
the 2 segments that were changed had both in the table and the new longer
segm...Too many cell formats #2
I have a set of spreadsheets that I am unable to change the format of any
cells. When I try to change the background color, font or font size, an
error message pops up saying there are too many cell formats. I really want
to avoid having to re-create all of these spreadsheets. Please help. Thank
Excel has a built in limit to the number of cell formats. You
have reached that limit. As the message indicates, you cannot use
any additional cell formats.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"wsdanalyst" <...Printing multiple charts #2
My question is - i have multiple charts on the same worksheet. Is it
possible to print them on separate pages without selecting each one
Depending on you layout inserting page breaks may solve your problem.
> My question is - i have multiple charts on the same worksheet. Is it
> possible to print them on separate pages without selecting each one
Andy Pope, Microsoft MVP - Excel
Here is a possible workaround.
Go to View>Page Break Preview
Select a range of cells and the...Event ID 1025 SLINK::EcTestMessage Error: 0x8007000e
We are getting the following error in out W2K3Sp1 XS2K3 SP1 server's
Application log. Any ideas?
Event Type: Warning
Event Source: MSExchangeIS Mailbox Store
Event Category: General
Event ID: 1025
Time: 5:40:28 PM
An error occurred on database "RTC\Huber".
Function name or description of problem: SLINK::EcTestMessage
I can't say I've seen this exact error code before but a good starting point
for such events might be to run isinteg...
isinteg -s server_name -fix -test allte...message bolocked in local deivery queue article id Article ID : 32
I installed a new exchange 2003 on windows server 2003 and , since, somme
messages are not delivered to a particular mailbox. But this mailbox still
receive some other messages. The messages are queued in local delivery queue.
The folowing message seems to be related to the problem :
(sorry for the french and ...)
Type de l'événement : Avertissement
Source de l'événement : MSExchangeTransport
Catégorie de l'événement : Gestionnaire de stockage Exchange
ID de l'événement : ...cell reference problem #2
I am trouble with cell references in a spreadsheet. Some cells will
display the cell reference rather than the value it points to.
For example the cell will display =A1 as text rather than the content
of that cell.
What could cause this????????
thanks in advance david
First check that you have calculation turned on.
Tools, Options, Calculation, automatic calculation
If that is the problem and it recurs, see my slowresp to see
how to spot the problem earlier.
The other possibility is that you have Text formatting instead
of General or a numeric format.
Other things t...Creating a new TASK using VFP9.0
I know this is a VBA group but I can't seem to get an answer from the VFP
group on this subject. I need to create a new TASK and send it to the person
I pick from a drop-down menu. This has to be done in FOXPRO (VFP9.0-SP2). I
can get to Outlook and create/send an email, but I can not figure out how to
create/send a TASK. Any help/sample code will be great.
Thanks in advance
Lost in Tampa
I don't have a clue as to how you'd do it in VFP, but if you are using the
CreateItem() method with an olMailItem argument to create a mail item
substitute the olTaskItem en...test post #3
I've posted a couple messages today that havn't shown up. Just
testing my account.
...X axis on 0 on Line-Column on 2 Axes
Is there a way on a Line-Column on 2 Axes chart to have the 0 value on both
the bar and line axes be straight across from each other even though the bar
chart is in 1,000s and the line axes is in single digits and has negative
numbers? Only way I can figure is to put negative numbers in the bar axis as
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
"Supe" <Supe@discussions.microsoft.com> wrote in message
news:F1174954-513D-...Min value excluding 0 and another criteria
I am trying to exclude zero plus add another criteria in calculating
the min value of a column. I want the other criteria to be the text
value of a different column. For instance column A has dog, cat,
fish, etc (up to 16 category types) and column B has age. I am trying
to find min age for each category and not include zero.
I know this will find the min age of everything
but i am at a lost for how to incoporate the other criteria
any suggestions would greatly be appreciated
On Apr 24, 10:41=A0pm, calebmich...@gmail.com wrote:
>...Data from 1 sheet to another sheet in same worksheet but then sorted....
I'm importing data from other worksheets with the database query function,
this does carry a possibility to sort but due to specific matters I can't
use the sorting function.
My idea is now to have the data thus important automatically listen on
another sheet in the same worksheet but on another sheet but this time
sorted according to certain criteria.
I'm sure this is easy with lists etc and filters, but what I'm looking for
is something simple where even I can work with.
Your suggestions are very welcome,
...Change file name #2
Hi, I've been searching for a solution to the following problem for more than a week. I've posted it here a couple of times, and got some good ideas, but unfortunately they did not work. The variable "myfolder1" has the correct value, followed by ".xls" as it should.
I'd be very thankful if someone could find my error. This is the original question:
I am new to Exel, and i cannot find my error in the following script.
The error is:
Run time erroro '9'
Subscript out of range
and it always stops on the "windows(my folder1).activate" line...Question about E-mail templates in 3.0
Do anyone knows whether it is possible to customize email templates to
include e.g. flash or jpeg’s or just a plain word dodument??
...Lost all inbox and contacts etc when removed server #2
I found the outlook.ost file. Can I reimpost this to
Outlook? Can I somehow set it or use it as the "personal
data files" that the outlook dialog box requested? I dont
get why I was
able to access the contacts emails etc after I
disconnected the exchange server BUT only after I removed
the exchange server did it all disappear.
Not sure how I was meant to continue this thread so I
copied the previous question, comment and listed it as a
new post -- hope this it ok protocol.
Also someone else had recommended that I re-engage the
server but it is neither listed nor frank...