Custom Format time to arc
I'm trying to find a symbol to Format/Cells/Custom, a symbol that
represents the max value of 360�. I know "H" is equal to the max value
of 24 hours, "m" is equal to sixty minuets and "s" is equal to sixty
seconds, this [h] will roll hours over past 24, and I know to format
cells like this h� m' s.00\" but these symbols represent time not the
arc of 360�. I want to convert arc to time and time to arc with the
symbols in costum format, I don't think this is possible, is it? Am I
doing this backwards? Should I be working with a formula or a
combina...How to send message to advanced find results?
Running Outlook 2003. I run an advanced query to get a list of contacts. Now
I have exactly the list of contacts I want to email in the Advanced Find
results dialog. Is there an easy way to send an e-mail to everyone in the
results list? Thanks for your help.
Select all, drag to your inbox?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Tom C. asked:
| Running Outlook 2003. I run an advanced query to get a list of
| c...Language input resets to default
I am using Windows 2000 service pack 4 and Office XP SP-1.
I have two keyboards installed, United States English
(which is default) and Canadian French.
When I switch from English to French inside Outlook, it
used (on Windows NT 4.0 with Office 2000) to keep the
input in French when I came back and forth between Outlook
and any other programs (keeping Outlook in French and the
others in English). Now, with Win2K and Office XP, it
doesn't always keep the setting. As far as I can tell,
this seems to be specific to Outlook.
Salut, comment fais tu pour ajouter le dictionnaire=...Formating Bars based on the value of a bar
I have created a bar chart in an access report. I want the bars to change
color based on the value of the specific bar. For example, if the value of a
bar is less than 1, it is red, if it is between 1 and 5, it is yellow, if it
is greater than 5 it is green.
How can I do this?
Seems like an easy problem, but I've just spent a couple of hours playing
with this and I can't make it work. The problem is that the Value property
of the points in the SeriesCollection is not exposed in the VBA interface.
It certainly exists (eg. with the chart in design mode, if you hover the
mouse...Conditional Formatting 03-29-07
I have been playing around with conditional formatting. I Have a few text
boxes with shading if certain items are entered. Now I want the first 3
fields in my subforms to be shaded if a record is started. I can get the
shading to work but I have the next record showing below the current record
that is entered. Those fields are also shaded, I only want them to shade if
there is anything entered in any of those 3 fields. Is there a wild card to
use so if anything is entered so the other 3 fields will shade?
I am not 100% sure I understand what y...rule for "Your Message " messages.
Is it possible to make a rule to move the "Your Message "
that is generated when your message is read to another folder.
Outlook 2003 XPSp2.
John G .
> Is it possible to make a rule to move the "Your Message " that is
> generated when your message is read to another folder.
> Outlook 2003 XPSp2.
Are you talking about read receipts?
you could but tracking on the sent item may not be updated.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginne...default client
I'm trying to make Outlook my default mail client.
In tools, options, other, the box to check to make
Outlook the default client doesn't exist.
How do I get that box to appear and put it in play ?
It's actually easier to do this: Open Internet Explorer. Go to Tools,
Internet Options, Programs tab. Use the drop down there to set the default
mail client to Outlook.
Author, Special Edition Using Microsoft Outlook 2003
***Please post all replies to the newsgroups***
"Dan" <firstname.lastname@example.org...BSOD in RtlStringCbVPrintfA() when using %wZ format specifiers on XPSP3
I get a BSOD when using this func with the UNICODE_STRING format
specifier %wZ (the bug is actually in vsnprintf. when the
UNICODE_STRING is empty. ie, a valid buffer (zeroed or unzeroed makes
no difference) with the Length and MaximumLength set to zero.
Now I know these specifiers aren't documented, but they exist, and are
well known, and used.
This is the crash:
0: kd> !analyze -v
****************...Printing a spreadsheet contained in an Outlook message
Within my company, I have multiple locations that report
daily counts. I set up an Excel spreadsheet that captures
all of this information. The file is set up and saved
using the "Send To -> Mail Recipient" feature so the
locations only have to plug in their numbers and
click "Send this Sheet" so that the message is sent in
it's open status rather than as a document (this is
definitely easier for those who use this).
This works very well for reporting purposes, but when
those receiving the message want to print the message,
Outlook does not seem to recogn...Report Card-like format
I don't know the best NG for this questions, so I guess
that's why they've got excel.misc <g>.
I have a simple table of data like this:
Date Field1 Field2 Field3
7/14/2003 123 254 75
7/15/2003 201 10 124
7/16/2003 215 258 2
7/17/2003 78 8 89
7/18/2003 125 186 582
7/19/2003 254 45 257
7/20/2003 200 199 89
The table is always the same size, but the data changes as
the days go by.
What I'd like to do is have the table look like a card.
Sort of like a report card or other. My idea is a
rectangle ...Cells formated as text do not always display properly
I am using Office XP and Windows XP. I have formatted a column of cells as
text and word wrap is checked, horizontal alignment is Left, Vertical
alignment is Bottom. I use these cells to type a short narrative. The
problem is some of the cells will not display properly, all they show is
######. The row height will expand to hold the text sometimes but not always
but it will still only show ######## instead of the text I typed. If I change
the cell type to General all the text is visible. This does not happed to
evey cell, only some of them. I can type several rows of data with a
narr...I can recibe but cannot send email
I have problem with outlook I cannot send email but Ican recibe
rudito <email@example.com> typed:
> I have problem with outlook I cannot send email but Ican recibe
When you post in here, always include your version, SP level, and mode (if
applicable) of Outlook - you can find this information in Help | About. Also
include the type of mail account(s) you use and any other pertinent details.
Be sure to put a consise summary of your question in the subject line, and
the full details in the body of yo...How do I remove the US (english) as a default language
I am using Word 2007 and would like to know how to remove the English (US)
setting to default to English (Australia). I have been into "Word Options",
"Popular" tab and changed it and have also changed it in a Word under
"Thesaurus", "Set Language", however it keeps reverting back to English (US)
which is very frustrating.
Could someone please show me how to permanently default it to English
Thanks and regards
Do they speak English in Oz? <g>
You have to look in a couple of places to m...Setting Product Defaults
Hello, I am trying to set up defaults for the Unit of Measure and the
price list within the quote and order. Our inventory is Great
Plains. Any assistance with this will be greatly appreciated.
Here is how you can set the default value for a lookup :
> Hello, I am trying to set up defaults for the Unit of Measure and the
> price list within the quote and order. Our inventory is Great
> Plains. Any assistance with this will be greatly appreciated.
> ...Compare dates (one cell not in date format)
I have one column of cells in date format (6/14/2005) and anothe
column of cells which also contains a date pulled from a database bu
this second column is not in date format, it comes from the databas
like this 2005Jan20. I need to compare the two dates to work out th
number of days between the dates but I can't convert the second date t
Is there any way I can work out the number of days between the tw
Thanks in advance
craigcsb's Profile: http://www.excelforum.com/...Will Windows' format mark bad sectors?
The external (USB connected) hard drive I use for backups apparently has
developed some bad spots. Formatting the drive starts producing System
Event Log entries at about 12% into the format, with the decription being
"The driver detected a controller error on \Device\Harddisk3\D."
If I allow the format to continue, will it eventually plow its way through
the bad area and mark those sectors as bad, or is this whole exercise a
waste of time?
Bert Hyman St. Paul, MN firstname.lastname@example.org
Waste of time would by my feeling!
When a "modern" drive has enough er...Can't seem to read PDF files, keep getting a 1402 error message
Tried loading Adobe reader and keep getting a Error 1402 could not open key
message. Here is what the message looks like.
Have you tried completely Uninstalling it and re installing it?
Russell Grover - SBITS.Biz [SBS-MVP]
Microsoft Gold Certified Partner
Microsoft Certified Small Business Specialist
24hr SBS Remote Support - www.SBITS.Biz
Second Opinion $15 - www.PersonalITConsultant.com
Free Trial Microsoft Online Services - www.Microsoft-Online-Services.com
&q...Formatting a List Box for Uppercase
I'm trying to format the data in a List Box to be upper case. I've tried
">" in the field properties, but that doesn't work. Below is the SQL
Statement in my query.
Any idea where I would insert something to make the First_Name and Last_Name
fields to be all upper case letters?
SELECT DISTINCT [tbl_PMS_Persons].[FIRST_NAME] & " " & [LAST_NAME] AS Expr1
ORDER BY [tbl_PMS_Persons].[FIRST_NAME] & " " & [LAST_NAME];
Thanks in advance,
Try changing the Row Source of the list box
SELECT DISTINCT UCas...Message Size Limits
First off, yes, I'm familiar with
According to this article, the most restrictive policy always applies. Now
what I want to do is very simple:
1.) Limit internal emails to 20MB
2.) Limit internet emails to 10MB
3.) Allow certain users a specified message size limit, even greater than
I see no way to accomplish this if the global 20MB limit is always going to
take effect because it's the most restrictive. There must be *SOME* simple
way to grant certain users a custom message size limit. There may be a
business emergency situation w...Read or sel message in outlook re-appears as new message on Blackb
Using Outlook 2007 on pc and Imap exchange server
A read or even just a selected message in inbox from outlook re-appears as
new message on Blackberry.
Searched the internet but no solution found yet..........
Anyone a clue?
Ed Crowley MVP
"There are seldom good technological solutions to behavioral problems."
"George AV" <George AV@discussions.microsoft.com> wrote in message
> Using Outlook 2007 on pc ...Selecting a command button whilst under a picture
I want to be able to still select (click) a command button i have adde
a macro to...but i want to hide the button under a picture.
Message posted from http://www.ExcelForum.com
Hi, Mat 66,
I don't know what all you want to work (you
can't click on the button once it's hidden behind
the picture without bringing it forward or
moving the picture out of the way).
Why not just drag the picture over the button,
and right click, select Order->Bring to front?
then, when you want to use the button, right click on
the picture, select Order->Move to bac...Sending NDR
My company uses an external company to filter spam , ( My MX record points to
the and then they forward my legit mail ) this company recently stopped
sending NDR's generated by my exchange server, for example if a message is 12
MB and my receiving size limit is 10, my server generates an NDR but is not
sent to the sender, ( My spam filtering service has will not send it back to
the sender and says that my server has to do this ) however it is sent when
the same message is sent to an email address on my exchange server not
filtered by this outside service, my question is this , how ...Formatting Odd Number Strings
I have imported a text report into Excel. For some reason the date
string on the text file reads as 20/05/0728. Is there a quick way to
reformat the string so it reads 7/28/2005 or even 2005/07/28, for that
matter. I really don't want to manually edit 300+ lines! Thanks.
Assuming your fubared date is in column A, insert a new column
immediately to the right of that, and enter this formula:
This parses the existing text string into arguments used by the DATE
function, which generates a date useable by Excel.
What is the cell...Cannot send email messages
This is my first time using this so I hope I do this right. I am trying to
help my sister with her email problem. She is not having a problem receiving
emails but cant send. Is getting the following error message and outgoing
emails are sitting in her outbox. We are using a wireless connection at a
hospital where she is staying while being treated for cancer. Ok....too much
The connection to the server has failed. Subject 'shower', Account:
'mail.bellsouth.net', Server: 'mail.bellsouth.net', Protocol: SMTP, Port: 25,
Secure(SSL): No, ...send receive probs
I hope somebody can help.
Untill about a year ago I used Outlook. Then I changed ISP. (From
Eircom to UTV) At UTV I could not get Outlook to work & had to change
to Express. Now I changed back to Eircom, & Outlook still does not
Any mail I send does not go off, does not appear in the "Sent items"
folder, does not appear in the "Outbox" folder, Does not generate any
error messages, does not open a progress bar. It DOES say "message not
sent". I also do not receive any mail.
I Switched to Express and it works fine, but I do not like Express.(No