How do I set sent column to show recipient instead of sender
I have transfered all my email from outlook express (XP) to a new windows 7
computer running windows live mail. All is good except for the sent items
list. It is showing myself instead of the recipient , why is this and is
there a way to correct it ?
This should work in WLM just about as it always has in OE: Right-click on
any column header, click Columns... and choose the ones you want. I see
both From and To as options. Note that you may some differences between the
columns in Mail from those in News.
R. C. White, CPA
San Marcos, TX
rc@grandecom...Multiple Columns in a stacked column chart
Is it possible to create multiple columns of stacked data
sets? For example: can I plot monthly data in which each
month is the sum of 3 categories, but plot these stacked
columns for 2 years (side by side per month)? This
enables me to compare last years monthly totals versus
this years monthly totals on a per month basis?
Through careful arrangement of the data in your worksheet, you can make
a stacked column chart that looks like a clustered-stacked column chart.
There is a tutorial showing this technique on Bernard Liengme's site:
http://www.stfx.ca/people/blie...Excel graph 3 sets of data. 2 sets as lines 1 as column?
I have data a bit like below, I am trying to do a graph, which shows the AFR
as columns for A-D, but I want 'water' and 'whole' as seperate lines to show
current scores across the graph. When I do the graph, I get two columns and 1
line. Does anyone know how to get to get the two lines?
A B C D
AFR 0.8 0.6 0.4 0.3
Water 0.5 0.5 0.5 0.5
Whole 0.3 0.3 0.3 0.3
On the chart, select the second column, right-click, select Chart Type from
the context menu, select line chart.
Thanks for that worked a treat, I'll remember that ...Column chart with both value x and y-axis
I was wondering if it is possible to define the x and y axes from two
columns of data for a column chart. For example, I want the x-axis to
be "Days Past Due" and the y-axis to be "Quantity" for a bar chart.
When I try to do it now, it plots both sets of data as separate bar
series and I want it similar to XY scatter but with colums instead.
Thanks for any ideas or suggestions you may have.
chris46521's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35909
...Stacked column charts that cross the X Axis
I need to show a stacked chart for the budgets of companies A, B, C &
D. As you can see, I have both positive and negative numbers. My
graph starts both the negative and positive data at zero. I'm not an
expert at graphs so the simpler the better.
A B C D
Budget =A30.313 -=A31.179 -=A32.055 =A31.1
Thank you very much for your time.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"valerie&...subtract column right from column left in excel?
How do I do entire columns with the same function, like subtraction?
I have excel 2003.
Question is unclear, please expand on what you want to do
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Muffin" <Muffin@discussions.microsoft.com> wrote in message
> How do I do entire columns with the same function, like subtraction?
> I have excel 2003.
if what you mean is each row
if you mean the whole column
=sum(B1:B60000)-sum(A1:A60000...How do I link data in Excel 2000 from a column to a row?
I am trying to paste link of data on a sheet organized in a column to another
sheet organized in a row. It does not seem to work by just copying and
pasting link. Any help?
When your ready to paste, Right Click in the new location and choose "Paste
Then click on "Transpose", then <OK>.
Please keep all correspondence within the Group, so all may benefit!
"rbenedict" <firstname.lastname@example.org> wrote in m...Summing the contents of one column based on the contents of another?
Hi again everyone,
Ok, after I got several speedy and very helpful responses to my last
query, I figured I could do worse than asking for help here again!
Maybe when I learn some more I can help dish out advice instead of just
Here's my problem:
I have a large spreadsheet with data in columns A and B. Column A
contains lots of strings. Column B contains numbers. eg:
Column A Column B
Ok, what I want to do is g...Is it possible to set a listbox column text to align right?
I have a listbox that has abount 14 columns. My client asked if I can make
one of them (a money display with $ sign) to align right cos that makes it
easier to read. I thought it is simple but it seems not possible.
"yanguo" <email@example.com> wrote in message
>I have a listbox that has abount 14 columns. My client asked if I can make
> one of them (a money display with $ sign) to align right cos that makes it
> easier to read. I thought it is simple but it seems not possible.
I haven'...100% Stacked Column Chart Labels
I've created a chart with several 100% stacked columns, each having multiple
data points in common. I'd like to show what percentage each of the data
points is in relation to its column but the percentage data label is greyed
out. Is there another way to do what I'm trying?
You can use this free add-in to link data label content to cells.
In those cells you calculate the value you need to display.
> I've created a chart with several 100% stacked columns, each having multiple
>...deleting every other cell in a column
I googled this question but am unable to understand how to use the programs
(or scripts) offered as a solution.
I am looking for a simple solution as I cannot program or use macro's. I
want to delete every other cell in a column where the values in these cells
happen to be the same three letters: QCO. (I found a solution for deleting
every other cell where those cells had no value:
Is there a similar set of commands I could use in Excel to delete every
other cell in a column where the value in those cells remains constant?
thanking all in advance
H...Easiest way to write data to a file
I have a couple of macros that periodically act up. I say
periodically, because some of the calculations are based on random
numbers. I would like to have them write a few lines of debug data to
a side file that I can examine after the macro completes.
I wrote the Write2File subroutine below and the TestWrite2File routine
to test it. It works except that it overwrites the previous data.
How do I get it to append the data the the file?
Are there any other improvements I should make to these routines?
'***** Routine to test Write2File *****
Public Sub TestWrite2File()
Dim...What is the best way to block incoming email from a specific domai
I am wanting to start blocking incoming email from specific domains, but am
not sure of the best way to do this. I am running Exchange 2003 SP2.
You can block mail from a smtp address/domain using Sender Filtering.
If it's coming from a particular IP address/range, you can also use
Connection Filtering/Global Deny list.
"Mike" <Mike@discussions.microsoft.com> wrote in message
news:0E1BAE53-B154-4CE6-8858-74749CB08047@microsoft.c...Best way to format a flat file that Excel will load properly?
I'm generating a flat file in Outlook VBA. Right now I'm able to save it as a
..txt file, although I hope to save it in a delimited flat file format with an
..xls extension so it will automatically be opened by excel without having to
go through the whole 'import' sequence.
There are string fields in the file, some of which contain commas- so I
can't make it a comma delimited file.
What is the best delimiter to use so that Excel will automatically recognize
and parse the flat file contents across columns?
Currently in 2003, but strongly prefer solutions ...Text to columns question
I have some data in the following format:
Number firstname lastname schoolname
The first three fields are one word each. Schoolname can be more than
one word. I'm trying to parse the data using the data -> Text to
Columns wizard, but I cannot figure out how to tell the wizard that
there are only 4 space delimited columns in my data and not 5 for
those instances where the schoolname is two words.
Any help is appreciated. Thanks.
On Jan 22, 9:50 am, MikeB <MPBr...@gmail.com> wrote:
> I have some data in the following format:
> Number firstname lastname schoolname
>...How to change Series Order in a Combination Chart?
I have 3 series of data in my chart:
1st two series are in a Stacked Column chart
3rd series is a Clustered Column Chart
They are in the order as follows:
I want to change the series order now as follows:
I tried right clicking on my chart and went into Format Data Series - Series
Order and change the Series order there. Nothing happens.
Why is this not working? And, how do I change the series?
P.S. I have gone through Jon Peltier's example and many other combination
chart examples on the...how to fit my column unmoved eventhough i scroll down?
how to make like for example i have column 1 until column 20
when i right scroll to column 8, it start to move to right hand side, and my
first column can't see anymore.
I want to be even though i scroll, the first column is not moving one.. no
matter how i scroll, it can see the first column, how to set?
- move the cursor in cell B1
- goto 'windows - Freeze Panes
"Zxing" <Zxing@discussions.microsoft.com> schrieb im Newsbeitrag
> how to make lik...Finally, an easy way to get rid of excessive default Excel 2007 styles
Delete from "Select Case CurStyle.Name" to the "do nothing" line. It
deletes all existing styles and resets them to the default Book.xlt.
Not glamorous, but it works.
Less Spam Better enjoyable experience
Visit : news://spacesst.com
So what's the question?
> Delete from "Select Case CurStyle.Name" to the "do nothing" line....Easier Way to Refresh Pivot Table Data
I am looking for an easier way to refresh a pivot table (to avoid any
complications with the PivotTable toolbar and to avoid the select/right
Ideally I would be able to add the ! Refresh button directly into the
file, but I don't know if I can do that. I guess it would be similar
to adding a macro button for the refresh function.
Any ideas? Thanks!
If your Pivot Table is based on external data ...
then you can use the Pivot table's options to update from the data
automatically every n minutes.
(The Pivot table's options are available by doing a right cli...Independently set columns windows live mail (IMAP)
I'm having problems with the with windows live mail and the columns on my
imap email account. If I change columns in the inbox the columns in the sent
mail box changes to the also. How can I set the columns in each folder
independently? I have no problems doing with with my pop account. Thanks in
advance for any help.
...Removing grid and column lines
i am trying to create an invoive in publisher 2003. Having a problem getting rid of the column and grid lines. It says to click on arrange and the go and change the grid lines to one but they are already at one and I can't seem to get rid of the lines. I would most certainly appreciate any help with this.
Click on the table to select it.
From the Menu click on Table > Table Auto Format > [None]. This removes any
table and/or cell gridlines.
"BOB" <firstname.lastname@example.org> wrote in message
&g...Is there a way to select all text boxes in a document?
I want to change the size of my document from a booklet on 11 x 14 paper to
one page each on 8 1/2" x 11" paper. I can get the document to change to the
81/2 x 11 paper but the text boxes are still the smaller size (from the
booklet). Is there a way to select all the text boxes at once so I can
reformat their size?
I want to make a large-print version of this booklet.
Thank you for any help you can offer.
Try the Painter tool.
Quickly copy formatting with the Format Painter
Mary Sauer MSFT MVP
http://office.mi...changing all email column names at once
I've been using outlook for about 2 months and I like to have the e-mail
account name as one of the columns. Unfortunately I have a ton of folders and
it looks to me like I have to change each folder individually. Is this true?
Try making a new View that you then apply to each folder.
Judy Gleeson - MVP Outlook
Acorn Training and Consulting
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 pertin...Is there a way to disable Synchronizing Contacts Globally
We are testing the Outlook CRM Client and we have decided that we don't want
our employees to synchronize the Contacts from CRM. Is there a way to
globally disable this from either the server, when the clients installed, or
through a registry change?
you can stop them going offline through a security role
Microsoft CRM MVP
"Dan N" <Dan N@discussions.microsoft.com> wrote in message
> We ar...Creating Combinations from Two Lists
I have data in two lists on two different worksheets. The data is laid out as:
I need to define the relationship between each element in a vertical
setting, In the past I have used cut and paste but am hoping to write a macro
that would create the relationships for me. For example:
Col A Col B Col C
Does anyone have any thoughts ...