Microsoft Outlook has encountered a problem and needs to close #2
After installing Microsoft service pack (sp2) and while
opening Outlooks 2000 (Office 2000);I recieved this error
message, "Microsoft Outlook has encountered a problem and
needs to close."
Can anyone offer a suggestion to fix this problem?
>After installing Microsoft service pack (sp2) and while
>opening Outlooks 2000 (Office 2000);I recieved this error
>message, "Microsoft Outlook has encountered a problem and
>needs to close."
>Can anyone offer a suggestion to fix this problem?
i have the same pro...Numbering
Can I enter numbers in a cross functional flowchart?
On Mon, 24 Aug 2009 12:07:02 -0700, carosaam
>Can I enter numbers in a cross functional flowchart?
Do you mean for the process names or function names? Yes.
Regards, Paul Herber, Sandrila Ltd.
Electronics for Visio http://www.electronics.sandrila.co.uk/
Electrical for Visio http://www.electrical.sandrila.co.uk/
Electronics Packages for Visio http://www.electronics-packages.sandrila.co.uk/
...Newbie questions #2
My company is in the process of converting over from Quattro Pro to Excel,
so I have a few newbie questions.
1. How do I set a default footer that is printed with every page of a
spreadsheet? I want to have the path and filename, tab name, and date at
the bottom of each page of a printout. I know how to set them for a
particular spreadsheet, but how do I set it up so it is automatically
included with every new spreadsheet?
2. How do I set the default page setup so that the scaling is always "print
to 1 page wide by 1 page tall", and margins are all 0.5inches al...Adding a row to a protected table
Graham Mayor provides a macro that is extremely helpful to me in a project I
am working on entitled: "An alternative method of adding a row to a protected
" (http://www.gmayor.com/word_vba_examples.htm). What I am having trouble
with is identifying the number of the table. I have a lengthy document and
over time some tables have been added or deleted, and I am suspecting that I
my table numbers are 'out-there.' I have a commandbutton running the above
macro and if I tested the macro to add rows to tables 1-4 and it works fine.
However, I cannot seem t...Replying #2
When replying to an email the normal setting is for the
reply text to be blue and for my name to appear, however,
recently this has changed and my name does not appear and
the reply text is black. I have checked the settings and
the reply font is stated as blue and the setting
indicates that my name should be displayed. Any ideas
Are you sure you're not replying to a Plain Text message?
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"Tom Cullen"...How do I expand the number of characters in Access comment box?
I am using Access 2007 and want to be able to include more than 250
characters in a "Comment" box.
You could try changing your table's field type to Memo. Assuming that
your are talking about a field in a table, that maybe shows on a form. If
that is not the case, please describe precisely what comment box your are
attempting to use.
>I am using Access 2007 and want to be able to include more than 250
>characters in a "Comment" box.
Message posted via http://www.accessmonster.com
...Raffle tickets #2
I have just purchased Publisher 2003, thinking that I would be able to do raffle tickets, with stub, for drawing and automatic sequential numbering system with same number on stub and ticket itself. If Pub 2003 can do it, it doesn't tell me. Iwould have thought with the new version, it would have been easy.
Mary Sauer MS MVP
"Joni" <email@example.com> wrote in message
news:DEDA14CE-D8D2-4B9...negative number to positive number
How can I change a negative number to positive number
Multiply by -1 or use the ABS() function.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"fgiord" <firstname.lastname@example.org> wrote in message
> How can I change a negative number to positive number
=ABS(##) or mult it by -1
"fgiord" <email@example.com> wrote in message
> How can I chan...Hide page numbers for mutliple discontiquous levels
I need to hide the page numbers for levels 1 and 7 in my TOC. I used the \n
switch to hide level 1, but cannot find a way to specify multiple ranges for
this switch. Is there a way to do this? I am using Word 2003.
You have to use a trick. See the "Omitting page numbers for noncontiguous
levels" section of
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Phillip Llacuna" <firstname.lastname@example.org> wrote in me...Running UserForm1 routines from UserForm 2
I have 2 userforms. Userform1 works great and now I'm creating
userform2. In userform 2 I'd like to call a couple of the routines
from Userform1. Is this possible? and if yes, how should I
By default, userform subroutines are private, which I think means
that they cannot be called from outside that userform module.
However, you can rename the Userform subroutines from
"Private" to "Public". (Not sure if this is a good idea or not)
Once the userform subroutine is "Public", you can simply call
any use...Need a formula for multiple sums in a cloumn when rows vary
I am making a invoice I need a total for each truck, with a grand total at
the end. The number of rows for each truck in the amount column will vary. Is
it possible to have the text truck total to the left of the total? A small
example below, there will be more entries under each truck and more trucks
tr# date hrs rate amount
3 4/12/10 10 50 500
4/13/10 5 50 250
truck 3 total 750
4 4/10/10 1 50 50
truck 4 total 50
and so on
...1-52 pages, 8,000 employee numbers
I have the ultimate challenge: to do job books for 8,000 employees.
The form is completed, but the request is to make booklets of 52 pages
for each employee.
Each page of the booklet must also have each employee's number on it
(0001 to 8000). Each page o fthe booklet must be numbered with the
week number from 01 to 52. Therefore I need to auto generate 416,000
pages. Ridiculous I know but nobody listens to us!
How can I export the above scenario to PDF from Excel?
On Apr 19, 2:17=A0pm, gatecrasherg13 gatecrasherg13
<gatecrasher...@gmail.com> wr...Sequential numbering in Number field
When I am entering transactions manually, I will put "Debit" or "VISA" to
indicate how the withdrawl was made. When I download my account information,
Money05 overwrites this with a sequential number. I have to go into the
entry a second time to redo my change. Does anyone know how to turn this
"feature" off? I want my values used - sequential numbering does not help me
in the slightest.
This is not a "feature" you can turn off. It's a reflection of the basic
premise of downloaded transaction data. The presumption with downloading
data...Data Export #2
We are using MS CRM 3.0 and are migrating to NetSuite. I am not a CRM
expert but is there a way to export all data ( I can already do the
excel export for names/contacts/accounts) including attachments and
information from the notes tab?
So when you open up a contact and click on the Notes tab I want to be
able to export all of that information and then import it into
I have looked online for solutions but haven't come across anything as
any information you can provide would be help and yes i do realize i
am asking a ms forum to help me migrate to a non-ms product...Number of Cells in a column
I want to add this formula in my ESS.
COUNTIF(sheet1!S2:S43,"*Yes*") to find out
the number of value containing "YES".
My concern is I don't have fixed count from
S2 to S43. It could be something else.
What can I do to have this code reusable?
I thought something like
\But it doesnt work
Thanks for your help
Try this if there is nothing else in that column:-
Ken....................... Microsoft MVP - Excel
Sys Spec - ...Delivery Status Notification (Delay) #2
I have Exchange 2003. There are some remote user (using
POP3)got messages like below from postmaster when sending
This is an automatically generated Delivery Status
THIS IS A WARNING MESSAGE ONLY.
YOU DO NOT NEED TO RESEND YOUR MESSAGE.
Delivery to the following recipients has been delayed.
Internal user (useing corporate/workgroup mode in Outlook)
has no problem. No problem from OWA. The remote POP3 user
is submitting the message over an authenticated SMTP
connection. We don't allow unauthenticated email to be
routed through our se...General Number Format Changed
Excel 2003 on XP
I have a collegue who's Excel setting for General number format displays as
0.1 instead of 1 in the sample box.
ie if you type in "1" you get "0.1", if you type in ".1" (as in 0.1) you get
Where in the settings can this General format be returned to standard?
Sorry that should have been:
ie if you type in "1" you get "0.1", if you type in "1." (as in 1.0) you get
> Excel 2003 on XP
> I have a collegue who's Excel setting for G...How to define cells so that only numbers can be filled?
How could I format cells in excel so that only numbers can be filled
The input should be integer e.g. between 0...99 and cells shoud no
accept any other marks, such as space, letters... simply nothing els
Message posted from http://www.ExcelForum.com
Data > Validation
You'll find it pretty intuitive and very flexible as to what you can
do as far a restricting input to a cell.
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available fre...Conditional Macro #2
I want the workbook to print using a macro (using a form button), only if a
referenced cell has a value (text). In this case it would be the cell
referenced by **
ActiveCell.FormulaR1C1 = "=RC"
' PRINT11 Macro
' Macro recorded 5/26/2009 by Larry
ActiveCell.FormulaR1C1 = "=RC"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
...Is there a Publisher (otemplate for DVD Case Inserts (10.75" x 7.2
I need to create a DVD Case Insert approx 10.75" x 7.2"(video store case
size). I cannot find a template. Could anyone suggest where I could find a
Might try www.neato.com, they have downloadable templates. If you know the
measurements it should be fairly easy to make your own template.
Try here too.
Mary Sauer MS MVP
"ScottW" <ScottW@discussions.microsoft.com> wrote in messag...Copy rows of data to another worksheet where ReturnDate is blank
I'm sure this is do-able within Excel but what formula I should use to
accomplish it escapes me.
Basically, I'm working with a spreadsheet which lists books checked out from
our Resource Center. When the books are returned, the Return Date is entered
in column D.
I want to run a report showing everyone who has outstanding books without
having to go through the spreadsheet, row-by-row, to copy the data to the
Thanks for your help!
Try AutoFilter - Select Row 1, go to Data, Filter, AutoFilter. An arrow will
appear at each cell in that row....Dexterity Training #2
I want to know if there's any Dexterity development training for GP 9.0
available in Mexico or USA.
Yes! Contact Integrated Business Group in Orlando, Florida. They have a
wonderful Dex trainer. I am not sure of the class schedule. Their web is
http://www.IBGNET.com and the phone is 407-677-0370. Ask for Roxanne and
tell her I said call.
Richard L. Whaley
> Hi all,
> I want to know if there's any Dexterity development training for GP 9.0
> available in Mexico or USA.
While there are already a lot of posts about numbering, I haven't been able
to find the solutions for my specific quandry...
[BTW, I'm posting this under "General" even though ultimately I'd like to
make macros to support the answer -- since a manual solution needs to be the
first step! :) ]
Background: My workgroup is preparing to migrate to Word 2007 very soon.
We create/maintain hundreds of large procedure manuals, each containing
multiple chapters (sometimes up to 40-50 per manual). Each chapter consists
of steps, using multi-level numbered lists...Formula error #2
I am trying to create a simple formula to grab the text from a cell in another worksheet (same workbook). Instead of getting the text, the following is displayed (which is the text of my formula, not the text in the cell it should be reading):
What am I doing wrong??
Your cell was probably formatted as Text when you entered your
formula. Change the format to General, click in the cell to edit,
then hit Enter.
In article <43B3041F-CBAE-408F-AE25-FDD8323FE625@microsoft.com>,
Ashley <email@example.com> wrote:
> I am trying t...Limit number of characters in a cell
Is there a way to limit the number of characters that a user can key into a
I want to get a list of names and addresses imputted by user, but I don't
want them to be more than 35 characters.
Thanks for the help
Take a look at Data|Validation.
You can have excel yell at the user when they hit enter after typing in a
Dr Senji wrote:
> Is there a way to limit the number of characters that a user can key into a
> I want to get a list of names and addresses imputted by user, but I don't
> want the...