Message colour ?
Someone recently sent me a email that shows up red in my message window ( I
don't use the preview pane ).
I don't have any message rules that would change the colour of that message
or anything like that and the priority of the message is normal.
Anybody have any ideas as to how this is done ? OL 2002.
It's done with the default automatic formatting rules -- View | Current View
| Customize Current View | Automatic Formatting
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
...Change table text column lookup list
I must add a column using vba and need to change the lookup list.
Set tdf = DB.TableDefs("TableName")
Set fld = tdf.CreateField("FieldName", dbText, 50)
The FieldName column need a lookup list whose
Display Control is a combo box
row source type is a value list
row source consists of a list as in Item1;Item2;Itemn...
Can this be done using VBA when the column is created.
>I must add a column using vba and need to change the lookup list.
>Using: ...Date Validation List not working
I have a spread sheet with Date Validation List in it and it works
fine but when I send the file by email to someone else the DVL doesn't
work. The little thingy to the right of the cell doesn't appear.
What's wrong? I have Excel 97 and so does the other dude.
Look if the other dude is using freeze panes, that is a known bug (try to
unfreeze the panes)
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
<firstname.lastname@example.org> wrote in message
> I have...Fixed Asset- change in cost basis
What is the process to increase or decrease the cost basis of a fixed asset?
I have some that the cost basis need to increase & some that the value needs
to decrease. Will the depreciation "catch up"?
You change the cost basis in the Asset Book card. When you click Save
to save the changes you will be warned that you have changed a
depreciation sensitive field and asked if you want to continue. Say
yes - you have 3 choices as to how you want depreciation recalculated
Reset Life Recalculates depreciation from the date it was placed in
service to the date the as...Need to change comission settings
I need to change the comission setting on all inventory items so comission
will be based on the sales rep's comission schedule.
Also, is there a way to make this the default setting?
Hi Meralee....you'll need to run an update query so all items in your item
list get flagged as "base commission on sales rep schedule"....
backup your database first and if possible update after hours
connect to your db with so administrator
query - new
set commissionmode =1
this will udpate all your items in your item list
My store ops (v2) defaults to sales rep comm...Create a check box for each row
I am trying to create an issues list in excel, and I want to add a check box
in the field as the issue is resolved.
Install by rightclick on sheettab then view code then insert the following:
Private Sub Worksheet_BeforeDoubleClick(ByVal _
Target As Range, Cancel As Boolean)
If Target.row = 1 Then Exit Sub 'row 1 s/b column titles
If Target.Column <> 2 Then Exit Sub
If UCase(Target.Value) = "P" Then
Target.Value = ""
Target.Value = "P"
Format the entire column with Symbol Font
...554 delivery error after changing DNS settings ?
I recently upgraded AD from 2000 to 2003 by prompting a member server and
making it a DC and transfering all roles, catalog etc... (old DC not
demoted yet but is switched off). This new DC also hosts DNS and WINS.
Im running exchange 2003 on an additional 2000 member server in this domain.
Im receiving emails ok (i.e smtp pushing email to me - not using connector)
but when sending email i get the following return:
'email@example.com' on 13/09/2005 14:42
There was a SMTP communication problem with the recipient's email server.
Please contact your system administrator.
Greetings from Downunder
One of my colleagues sent me this, something of a puzzle.
She is using XP and Office 2003:-
In My Documents I have a folder of PPTs of hymns and songs that we use in
church. I file any new songs here making sure that they are a golden yellow
text on a very dark blue background. This is the way it has been for about
This morning I went to use some of them in the presentation for this coming
Sunday - and would you believe they are now ALL pale yellow on a black
background. Every last one of them - and each song is is a separate PPT
...Dates changing in MPP?
When I enter my receipts I obviously use the transaction date for the date
of the sale. However, I just noticed that a lot of my dates have changed by
a few days when I compared against the Visa statement. Is there an issue
where MPP changes the date? Even downloaded transactions match against the
transaction date before I accept them or I'll change it.
In microsoft.public.money, Geekster wrote:
>When I enter my receipts I obviously use the transaction date for the date
>of the sale. However, I just noticed that a lot of my dates have changed by
>a few days ...GPO for change of "Show this address list first" ?
is there a way to change the setting in the Outlook address book over GPO ?
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
"Udo Lorenz" <Udo Lorenz@discussions.microsoft.com> wrote in message
> is there a way to change the setting in the Outlook address book over GPO
...changing bargraph colors
I have the following code section:
int a, b, c, d;
in = fopen("teststring.dat", "rb");
fread(bars, 30, 1, in);
d = (cr.Width()/30);
for (b=0; b<30; b++)
a = ((bars[b+0x30]*10)/14) + 1;
pControlDC->Rectangle (c, cr.Height(), c+2, cr.Height()-a);
The file teststring.dat contains 30 bytes data in t...changing the server response for SMTP
If I telnet into my server via port 25, the server responds with "220
server.mydomain.local Microsoft ESMTP Mail Service...."
I want to correct this so it responds as my correct FQDN, which would be
I swear I must have done this a dozen times in the past on other servers by
checking the properties of the SMTP Virtual Server, Delivery, Advanced, and
typing the correct name in the FQDN box.
However, I've done that, stopped and restarted everything, rebooted the
server, and it still shows as the ".local" name.
Where else should I be...Imported Form Changes
This is a multi-part message in MIME format.
Access 2007 sp2.
I hope I explain this ok... Here goes.
When I want to discard changes made to a form by importing a form form a =
the imported form takes on all the characteristics of the form I want to =
As an example, lets say I remove a command button from Myform in my main =
I then import Myform from a backup knowing that this form still has the
command button...can i match a colour to its wavelength in nm
I have no clue what nm means?
Mary Sauer MSFT MVP
"aquakem" <firstname.lastname@example.org> wrote in message
Mary Sauer <email@example.com> was very recently heard to utter:
> I have no clue what nm means?
Won't do it.
http://members.cox.net/astro7/color.html claims to have a FORTRAN program
that will do it....date problem #4
this is probably some rookie mistake that i am just not thinking of.
i enter the date 2.19.1979 but it shows as 28905 & i can't make it
show the other way. i have 3 worksheets in the workbook & only 1
shows the dates this way. i tried the obvious format cells option but
it didn't change.
its monday & my brain is not working right, your help is appreciated.
On Nov 3, 1:52=A0pm, evilyn <rdl...@charter.net> wrote:
> this is probably some rookie mistake that i am just not thinking of.
> i enter the date 2.19.1979 but it shows as 28905 & i can't...Colour Rows in Datasheet based on three criteria
I was wondering whether it would be possible to colour rows in a datasheet
(or continuous form) based on 3 criteria. Scenario is I have a series of
jobs that can be either unassigned, assigned and finally "assigned and
I would like all rows that are "unassigned" to be one colour; all assigned
jobs to be another colour and the final section to be a further different
thanking you in anticipation
On Mon, 17 Dec 2007 09:05:01 -0800, PMK <PMK@discussions.microsoft.com> wrote:
>I was wondering whether it would be possible to colour r...changing a series 'value' label to 'none planned' ? #3
Thanks, that worked fine, now displays None Planned if the figure is 0.
neowok's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=5940
View this thread: http://www.excelforum.com/showthread.php?threadid=274120
...Why is colour printouts not same colour as in word?
When I print my logo from Word the colour is correct. When I copy it to
Publisher and print it from there the colour comes out wrong. What could be
Try importing the image rather than copy/paste.
Mary Sauer MS MVP
"DvdM" <DvdM@discussions.microsoft.com> wrote in message
> When I print my logo from Word the colour is correct. When I copy it to
> Publisher and print it from there the colour comes out wrong. What co...Change bkgnd colour for some words in CRichEditCtrl?
I'd like to be able to change the background colour for some of the text
in a CRichEditCtrl. I'm comparing two files side-by-side in these controls
and need to be able to highlight some text to illustrate the results.
I could just change the text colour and make the font bold and/or
larger, but highlighting similar to when text is selected would stand out
better, especially if I could also change the text colour to suit.
Is this possible? (I've seen it in some programs, but don't know if a
CRichEditCtrl was used.)
Any help appreciated,
...See last changes in sqlserver
This is probably a novice question but I cannot find it: Say you are
debugging a program, you replay the error, and you want to see which
database files are effected, how can you see that? Is there a way to get the
latest changed date for a entity, is there a log file where you can see
which statements where executed the last five minutes? For example my
database exist out of customer, product, order, company files/entity I want
And then conclude:...Reports
Could anybody assist me or guide me in the correct direction for what I need
to do. Lets use the Detailed Sales report for example... If you place the
date in the first column and group by first column, it does not group all of
the same dates. I believe what it is doing is also grouping the Time as well
as the date. Well of course these transactions all happened during different
hours of the day, but i want it to group. by the date only, ignore the time.
what could I do to the code to modify this change? any ideas?
There is a Custom Report in the microsoft reports library that fixes t...Adding text box to pie chart
I have a pie chart on an EXCEL tab that charts 10 different pieces of data
from another tab in the same workbook. I need to show a total of these 10
pieces of data on the chart. The total is available in a cell on the tab
with my data.
When I add a text box with a link to the data onto the chart, the data
appears. However, as soon as I click off the chart, the text box with the
How can I get the text box with data to remain on the chart. I've read
through some of the other similar posts but can't seem get their solutions to
work for me. This seems like suc...Changing column views
When I go into view-> columns and change the columns that I want to see in my
view, it only saves the changes for that session. IE when I go back into
Mail later it has reset to the original columns! How do I keep the view
changes that I want permanently??
"Vic33" <Vic33@discussions.microsoft.com> wrote in message
> When I go into view-> columns and change the columns that I want to see in
> view, it only saves the changes for that session. IE when I go back into
> Mail later...Change formulae easily?
I have to change a great amout of formulae from a simple
=A3/A4 to either
The cells are spread all over the sheet, sometimes in one row or line,
sometimes grouped together or sometimes individually placed anywhere on the
Is there an easy way to change these formulae faster then individually
change each cell? Even changing each cell individually would be easier if
there was a way to wrap the old formula between the necessary alteration.
(PS: ASAP has a Macro that can alter the formula, but it can only add
something at the end...Change Range in macro
How can I change the range in the macro below for sending email to recpients,
I want to change the range to sheet3 and email addresses that are input into
Here's the code:
'Working in 2000-2010
Dim FileExtStr As String
Dim FileFormatNum As Long
Dim Sourcewb As Workbook
Dim Destwb As Workbook
Dim TempFilePath As String
Dim TempFileName As String
Dim OutApp As Object
Dim OutMail As Object
.ScreenUpdating = False
.EnableEvents = False