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...newsletter formatting
I have designed a newsletter in Publisher that I e-mail as a message. The
format is saves as HTML. The original recipient can view the newsletter fine,
however, when the newsletter is forwarded the formatting gets rearranged.
How can I keep the original newsletter the same for orignal recipients as
when it gets forwarded?
Fredrik A <Fredrik A@discussions.microsoft.com> was very recently heard
> How can I keep the original newsletter the same for orignal
> recipients as when it gets forwarded?
Convert to PDF using an application such as PrimoPDF (www...Copy and Paste not saving format changes
Operating System: Mac OS X 10.5 (Leopard)
I just bought Microsoft Office for Mac early this month and am still getting used to it. Can someone help me with this:
I have several documents typed onto a notebook layout with lots of bullet points, color changes, cross outs and the like. I wanted to copy and past all of that into a new document but when I did ALL of the formatting changes were lost. There were no bullet points, so the text flushed left, yada, yada, yada.
I looked around the toolbar to try and find a setting that would allow me to do the cut an...Query Problems
I have a table of ecards that is populated from a website and includes
receiver, sender, and Team leader. The problem I am having is names can be
entered into the table like this "Tom Thumb", but Team leader is a dropdown
menu that is constant and lists name like this: "Tom S. Thumb". When I make a
query to find all the members of Tom S. Thumb's team, I get everyone except
Tom Thumb, who is member too. Tom Thumb has his own higher team leader, so I
can't change that. How do I get Tom Thumb to be included when I enter "Tom S.
Thumb" as Team Leader?
...Query to Mail Merge issue
I am running Access2003 on WinXP SP2.
I send out dues letters for members of a retiree group. When I try to do a
mail merge to my Dues Query all goes fine except the telephone number in the
query which is (555)555-1234 comes out 5555551234. If I copy the query into
an excel spreadsheet and use that as the datasource for the mail merge it
Is there something I need to do to format the query so it merges with the
In the query format the field to include the parentheses and dash. In query
design view, instead of the field name put an expression alo...Excel web query returns no data
When I enter a web addreess into IE it shows the page
When I set up a web query in Excel it allows me to select
the relevant tables, but then returns no data
The same Excel query worked on previuous versions of Excel
Web address for query
Any help appreciated
...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.
D...Formatting cells from internet
I have copied and pasted a chart from a website. (The website will not let me import) The cells are showing numbered values, but when i go to put the formula in it is giving me a zero like it cannot read the numbers in the cell. That is on 3 seperate columns. On the very last column it is reading the numbers
I cannot make it recognize that those columns are numbers to be used in formulas
Thanks for your help!
Use Dave McRitchie's Trimall macro to clean up the data. Then copy an empty
cell, select all your data and do Edit / PasteSpecial / Add and it will coerce
all data back to nu...Conditial Formatting Not Available
After trying to use conditional formatting (which didn't work btw) now
the Conditional Formatting button in the ribbon isn't available or disabled.
I tried Compact and Repair but it didn't work.
Duh. I was selecting a label instead of the field.
"JamesJ" <jjy@adelphia_darwin.net> wrote in message
> After trying to use conditional formatting (which didn't work btw) now
> the Conditional Formatting button in the ribbon isn't available or
> I tried Compact and Repair b...Cannot view itme in Public Folder between 2 different exchange 2003
I have 2 Exchange 2003 on WIN2k server.
Exchange 2003 (A) has 300 mailboxes and store the public folder.
Exchange 2003 (B) has 100 mailboxes.
User at Exchange 2003 (B) found that they can view the public folder but no
items in it.
User at Exchange 2003 (A) do not have this problem.
Is the public folder must replicate to other server?
Is any suggestion to view the item if no replication on public folder ??
These 2 servers in the same routing group.
Exchange 2003 (A) is the Master
Exchange 2003 (B) is the Member
"omer maydan" <email@example.com> wr...Export query to Excel with formated heading
When export from query to Excel, I'd like to turn some columns into heading
row on top of Excel sheets how to turn this:
LastName FirstName SID Section Instructor
Doe John 1234 0545 Su
Doe Jane 2345 0545 Su
LastName FirstName SID
Doe John 1234
Doe Jane 2345
I think one way of achieving this would be to create a report in Access
where you would group under instructor with the students in the detail
section. From the report you can then use the analyze with Ex...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...Amazing Problem in AllocPhysMem wince 6.0
I am writing a Port Driver for x86 platform in WinCE 6.0. I want to
allocate virtual and equivalent physical memory in driver and mapped
it to USER mode to use application. For that I used AllocPhysMem in
driver and passed that
address through IOCTL calls but i cant use that virtual and physical
address in application side. Because AllocPhysMem returns Error Code
as 0x57 (meaning Parameter incorrect).
But the same code is working in WinCe 5.0.
My code snippet is,
VirAddress = (LPVOID)AllocPhysMem(32,
...conditional sum returns not expected
Using xl xp pro
Here is conditional sum formula
Sorry about the wrapping.
Where C$2 = 7001.4500
Where C$3 = 7001.4501
Where $A5 = 54608001
Where Far_All_Data! contains data, all ref's verified
However, all formulas return 0.00. As I copy down the formula Col
(54608001) udates ...002, 003, 004, etc...
Sometimes the expected result is 0.00 other times value should b
greater than 0
Not sure how to read the formula.
Does it say if, or, and?
...Query Criteria issue
Trying to create a demographics report that will allow the following.
On the form "frmStudentDemographics" is a drop down field named "cboGender"
When the user makes a selection "Male" a report is generated for only Males.
But in some cases the user will want to run a report for both (all) genders.
So I added a check box next to the drop down named "ckAllGender"
My idea is that if that box is checked then the report will show information
on Both (all) genders.
So in the query that generates the report, in the c...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...Multiple indexes on same fields in different order
I sometimes need to find the largest or smallest value in a field. If I put
two indexes on the same field, one in ascending order and one in descending
order, is Jet smart enough to use the proper index if a give it a grouping
query with the condition Max or Min, or am I just wasting resources?
This e-mail address is fake, to keep spammers and their address harvesters
out of my hair. If you want to get in touch personally, I am 'pdanes' and I
use yahoo mail. But please use the newsgroup when possible, so that all may
benefit from the exchange of ideas.
...Restrictions in format
How do I restrict some columns of having all text in UPPER CASE, some columns
to have text only First In Capital Letter and some columns only in lower
You can restrict using Data Validation but I would find that very annoying.
Example............in DV>Allow>Custom =EXACT(A1,UPPER(A1)) will not allow
anything but Uppercase.
I would use event code to automatically change Case when anything is
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error GoTo ErrHandler
Application.EnableEvents = False
...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....Spontaneous 'Compile Error' In Queries
I've got a half-dozen queries that contain this expression:
Haven't touched any of them, but suddenly they were all throwing
"Compile error. in query expression 'IssuerName:
tblIssuer.IssuerID is still there in a link.
My kneejerk was to somehow force recompiles of all the queries,
so I did a Compact/Repair.
After the compact/repair, all was well: the errors went away.
C...Conditional Format #14
That's what I was messing up! It was the ordering, not the formula!
Thank you. Now if I have my =AND(E2="Y") for one and no formatting
and my second =C2<TODAY() Red bold format, I should be able to mak
rule 3 =C2<TODAY()-2 format Yellow bold and have anything 2 days clos
to due yellow, YES
Jimmytech's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1447
View this thread: http://www.excelforum.com/showthread.php?threadid=26087
You o...Two different cells
I have a file with more the 1000 names and addresses. My proble is that the
firat and last names are in 2 differents cells. I i would like to put it in
teh same cell. Is there anyway I csn do that?
Please help too many names to re-type
Assuming that Column A contains the first name and Column B the last
....depending on your preference.
Hope this helps!
In article <520FA0CA-1940-42E5-B84D-22BA15D59638@microsoft.com>,
"Hombreck" <Hombreck@discussions.microsoft.com> wrote:
> I have a...Conditional Formatting
I need some help with conditional formatting.
I'm trying to highlight those cells which have a plus sign in them. Can
someone help with the formula to enter into the conditional formatting
Grateful for any assistance.
if the Plus sign + is part of a text string Select the column range first then
=FIND("+",A2:$A$160) change the range to your needs.
If the + sign is alone in the cell, you don't need a formula, just select > Cell
value is > then select Equal to> and type the plus sign in the third box.
H...I am having trouble keeping numbers formatted in a Pivot Table
I have a pivot table that won't stay formatted. The data is formatted as
currency in the worksheet that the Pivot Table is drawing off of. It shows up
as a general number in the Pivot. I've tried formatting it in the Pivot but
it doesn't stay when I refresh the data. "Preserve formatting" is checked on
the Pivot table, so it SHOULD be preserving any formatting I apply to the
pivot table, but that doesn't seem to be happening. I know I could record a
macro to format this, but it is happening on multiple Pivot tables in the
same workbook and that would be a pain ...Do you need MS Access to query on an Access table?
I'm asking these questions because I have looked at a lot of stuff in the
discussion groups and still confused. I am fairly good at Excel programming
but haven't been able to get Excel and Access to talk.
First, I have Office 2003 Professional at work and Office 2003 without
Access at home. I want to work on developing Excel programming at home which
will get data from Access to Excel with either MS Query or with programming.
Is it possible to just have the .mdb files on the home computer for Excel to
work with, or do I need the Access program too?
The info I want ...