Exchange rich-text format
What are the results from the client side if I change my Exchange 2003 server
to "Alwayes Use" Exchange Rich-Text format from "Determined by individual
On Thu, 22 Jun 2006 08:31:01 -0700, CK <CK@discussions.microsoft.com>
>What are the results from the client side if I change my Exchange 2003 server
>to "Alwayes Use" Exchange Rich-Text format from "Determined by individual
Depends on what your users are sending messages as. Most will be using
HTML or RTF anyway unless you have some policy in p...How to remove the alternative text box from the publisher email?
I have created a publisher email and have email it to myself for testing
I find there is a small alternative text box appearing whenever my mouse
cursor station at any point of the email.
How to remove this alternative text box from the publisher email?
Sounds like all the text has was converted to an image. Try to select the
text and you will see it is an image.
Go to tools > Options > Web tab and under Email options uncheck the option
to send as an image.
If that doesn't fix the problem, reference: Tips and troubleshooting for
...Change from MS Outlook Rich Text to HTML
I use Outlook 98 and I want to change my message format to HTML so that
I can have nice backgrounds etc on my mail. For some reason this
facility doesn't seem to be available to me on the 'Mail Format' Tab.
It is blacked out and I cannot change it from Rich Text to HTML. Is
there anything I can do to sort this out? Could it be because I am on
a network at work and they have disabled it? If so, how can I enable
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www...Trouble with hyhens within text when using LOOKUP
I have two columns, each containing a list of part numbers. Some of the part
numbers contain hyphens.
I am using LOOKUP and/or VLOOKUP to determine if the value in one column
exists in the other. This works great on non-hyphenated part numbers.
However, it will not find or return the hyphenated part numbers from the
specified arrays. As a test, I did a quick if statement to compare the
instances of identical hyphenated values that exist in both columns. Those
statements did not have a problem with the hyphens. Can anyone offer any
help? If hyphens cannot be used in conjunction with the ...How to use MSExcel to plot Column A against Col B?
I want to plot col A (x axis) against col B ( y axis). I cant seem to
do it. Can anyone here please give me step by step primer. Thanks in
All I get is the graph of (1,2,............n) (x axis) against the n
values of either col A or B.
i.e 2 graphs instead of one.
(In the old Lotus this was so simple: select the column for the X axis
and then select the col for the Y and press enter, and you'd get the
Why is it so diff in Excel?
Select the entire range you want to graph such as a2:b44>insert>chart>>>>
dguillett1@au...instructions disppear when users begin type (text field)
I need to customize the outlook contact form and I want to add one text
field to allow users to add details info and instruct users how to add.
Instructions shows in the field and the instructions disappear when users
click and begin to type. How should I do this? exchange 2003/outlook2003
It's hard for me to visualize exactly what you're expecting to happen. If
you want the instructions to stay on the screen, you could display them in a
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumps...If statement with formatted text
Is there any way to have an if formula such as:
If (A1="Active", "KAE",KPE")
where the two letters after the K are formatted as subscript?
The best I've done is to paste a picture over the cell. The picture's
formula refers to named formula that selects one of two cells, the one with
correct string. One cell contains KAE and the other KPE with the subscript.
However, it means that I'm using a picture and it would be much nicer if I
could just do it in an If formula.
I hope that makes some kind of sense, and thanks in advance for your help.
Hope you folks can help me out with a strange one.
I have several worksheets formatted in exactly the same way as follows:
Col A - width 4
Col B - hidden
Col C - width 4
Col D - Width 108
Col E - Width 3
Col F - Width 11
Col G - Hidden
Col H - Width 11 & Empty
My print range should be Cols A:G (I have used page setup to set the
scaling to fit 1 page wide by [blank] pages tall, thus each sheet will
print as many pages as required depending on number of rows]
When I have the print range set to A:G only columns A:E show on the
print preview (and also on the actual print out) and when I m...Saving html message as Draft changes text formatting...
WIN XP HE,
I have recently noticed that whenever I write an email (using Word as
editor) in html format, and instead of sending it, save it (to the drafts
folder), the text itself changes format from my default to another one.
It seems to change in the paragraph style which then changes the text
The only change I recently made was to edit my signatures in html, rtf and
plain text format.
When I write a new email, it opens up with the signature already in it and
perhaps there are format/style conflicts..?
Tx for shedding some light into this.
As an added information, t...can lookup return cell reference istead of "text" for sumif?
I am trying to use a lookup-function to determine a different sum
range for several criteria.
The problem is that the vlookup returns text and not the cell
reference. Is there a way to get the answer from the lookup expressed
as cell reference instead of text, since sumif can't use text, just
the cell reference?
I use it to calculate the number of hours the staff should be paid, so
it's different from weekdays to saturdays, holidays...Using cell text in a formula
I am trying to use derived cell references in a VLOOKUP formula to matc
data in several tables. For example, A1 contains the cell reference fo
the top left of my array (A3) whilst cell A2 contains the cel
reference for the bottom right of my array (D14). The array I'
checking against starts in column E3.
However, when I use the formula =VLOOKUP(E3,A1:A2,4,FALSE) I get a #N/
error. I need to use the cell references in each VLOOKUP as the arra
sizes may vary in each case. (PS, I've used =INDIRECT(ADDRESS(A1,A2)
to derive the cell references.
Message posted from http://www.Excel...cannot view all of text in large cell, even though I have it to w.
I have cell format to wrap text and it works fine to a p[oint then no more
text is displayed....casn increase the size of the cell, but still only so
much will display....rest of the cell show blank.
+the limit is 1024 characters. You can extend this with manually inserting
linebrekas using aLT+ENTER
> I have cell format to wrap text and it works fine to a p[oint then no
> more text is displayed....casn increase the size of the cell, but
> still only so much will display....rest of the cell show blank.
...Text box jumps to left of page
(I am relatively new to Word and am delighted to find a forum
specifically for the Mac version. There are a number of unresolved,
niggling issues I can live however they slow the workflow. I am eager
In the recent past, I manually converted 12,000+ recipes from
WordPerfect 7 to Word. Since Word 2004 does not have a filter for the
old files, the conversion was done on the Windows side of my Mac in
Word2003. Those files _usually_ open without protest also in 2004. One
annoyance regards text boxes. When text was highlighted and a text box
was requested for it in...initial default column width
Is there a way to configure Excel 2000 so that when I create
a new Workbook or add a new Worksheet so that all the columns
have a particular width instead of the default 64 pixels?
Create the workbook exactly the way you want it, then save it as a
template with the name "Book.xlt" (no quotes) in you XLStart directory.
It'll be then used as the template for new workbooks.
Likewise, save a one-sheet workbook as a template, named "Sheet.xlt" for
the template for Insert/Worksheet.
In article <419E181F.6251D20D@nospam.net>, Bruceh <email@example.com&...Windows and Mac have two distinctly different units for column width.
Operating System: Mac OS X 10.5 (Leopard)
I am trying to format columns for some data I am entering in a spreadsheet and when I enter "15.00", which is the required width for these columns given by my professor, I end up with a column 15 inches wide. What I would prefer is for the options to be like the default options in Windows version of Excel. In Windows version of Excel, when you hover over the lines between the columns it gives you two numbers (e.g. 8.43 (64 pixels)). These are the default numbers for column width in Windows Excel....How did you add text into publisher, without using boxes?
how do you add text to publisher without using text boxes
I suppose you could create your text as an image and insert the image into
your publisher file.
"Calvin Scott" <Calvin Scott@discussions.microsoft.com> wrote in message
> how do you add text to publisher without using text boxes
Calvin Scott <Calvin Scott@discussions.microsoft.com> was very recently
heard to utter:
> how do you add text to publisher without using text boxes
Text in Publisher has to e...How to assign unique number to column duplicates?
I need to assign a unique number to a set of duplicates all in one column in
so columnA will has about 9000 numbers, some of them unique, and others are
duplicates of 2-4 approx.
I used to conditional formatting to show which are duplicates, but need to
be able to assign a unique number to each set duplicates, that will be in
ColumnA ColumnB(unique ID)
Any ideas please? I don't know how to do programming, just form...Create your personal SMS homepage, let friends send FREE text message to your mobile phone by web
Create your personal SMS homepage, let friends send FREE text message
to your mobile phone by web
Support over 147 countries and ALL languages (unicode encoding)
MSG.to provides a unique personal SMS URL for you.
It is easy for friends sending text message to you by web.
For example, if your name is Lisa, you can register:
http://MSG.to/Lisa (you can use this link to see demo)
You can also register your mobile phone number as SMS URL like:
http://MSG.to/+886913123456 (you can use this link to see demo)
Please visit http://msg.to/ for more information.
Short Message Serv...imbed excel cell text in a shape
I need to insert a number into a shape that corresponds to a cell in excel.
Kinda like the exploded parts view in a car repair manual.
A callout shape with a text value "123" that is linked to cell A1 in file
It would be nice to be able to auto generate the callouts from the excel file.
shape 123 is cell A1, shape 124 is cell A2 and so on.
what version of visio are you running?
"mystified" <firstname.lastname@example.org> wrote in message
>I need to insert a number into a s...Filter two columns with criterion applying to one or the other?
I am looking for a solution to the following filtering problem:
I have two adjacent columns, so using a filter for both of them is no
problem. But what I want to do and don't know how to do is this:
I want to filter for values greater than x (a certain number, in my
case 5000) in any of the two columns. I can filter both columns for x
greater than 5000 but that filters out more than I want because there
may be some cells with a value greater than 5000 in only one of the
Is there a solution to this problem (using Excel alone or an add-on)?
you can use th...Vlookup, multiple times in one column summing corresponding
I have a list that contains common invoice numbers that appear multipl
times in column A and need to use the vlookup function to find and su
the corresponding amounts in column B.
As you would be aware the following vlookup functio
=VLOOKUP(A3,DATA,2,FALSE) will only return the one amount once i
reaches a match and I need it to continue down the column and sum al
matching invoice numbers.
Column A Column B
145880 80.87 *
145880 54.09 *
The answer I�m looking to return is
It has to be a vlookup sty...Extract Values from a Column
I have a worksheet used to track time spent on various jobs. One column is for the JOB # while others are for descriptions, etc. I would like to have formulas or possible a macro (if necessary) to sum the time spent on different jobs. For example, say (for simplicity) that each row is equal to 1 unit of time. Then in this row I put 342 for JOB # 342. After the entire day I have worked on say 5 different jobs. I would like to have a cell that says "Total time spent on Job # 342" and then next to it a formula that would look at the column and count all the values that are equal t...Text box unwanted border
For some reason I know not why, that even though I enter 'No line' in both
Line/Border style and Dash style I still have a visible bold dash surrounding
the text box.
Any help would be appreciated.
Did you happen to draw a rectangle around the text box?
Try highlighting it, and move the bottom text box adjustment up. If the
dashed line didn't move, click on it and delete.
Copy the text, and paste it and if the dashed line didn't go with the copy,
delete the original.
"Meridklt" <Meridklt@discussions.microsoft.com> wrote in m...HQ Reports
In the HQ report 'Work Orders - Detailed' one of the default columns is Order
#. I am hoping to enable the magnifying glass on this field that would take
me straight to the journal for that transaction. I do have my journals being
Is this a reasonable wish?
Can you point me in the right direction?
The worst words in business:
"We''ve always done it that way"
Stop Fishing for eMail.
DrillDownFieldName = "[Order].ID"
In the Order # column section.
Get Secure! - www.microsoft.com/security
You must be usi...Can I add more columns to a spread sheet or is limit 256 columns
I am trying to produce an Excel spread sheet with at least 370 columns in one
spread sheet but the limit seems to be set at 256. Is it possible to
increase this number?
Grit your teeth and wait for the next version of XL (12), and you'll have
all you need!<g>
Check out the new specs here:
Please keep all correspondence within the NewsGroup, so all may benefit !