Auto delete windows mail?
I'm using Windows mail with Vista. My junk folder has auto emptied twice in
the last two months. I can't figure out why. Any help out there?
"srmarty" <firstname.lastname@example.org> wrote in message
> I'm using Windows mail with Vista. My junk folder has auto emptied twice
> the last two months. I can't figure out why. Any help out there?
Tools>options>advanced tab>maintenance button.
MS-MVP. MAIL. ...data input in text box
We have a form which the operator enters data in a text box. Currently we
have a 'done' button on the form that the operator clicks to send the text
box info to a vba program. How can we send the text box info to the vba
program when the operator hits the enter key @ the end of the data entry for
the text box? TIA
In Christ's matchless name
ted & colleen
Use the control's AfterUpdate event.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"ted" <n6trf@arr...Transferring over outlook data to new XP machine
How do I transfer over my old emails, address book to my
new XP machine? I have looked over the internet and found
nothing the tells me EXACTLY how to do this, any help
would be greatly appreciated.
If your using MS Outlook copy your .PST file across and import it into the new install.
>If your using MS Outlook copy your .PST file across and import it into the
No, don't import it. Simply use "File">"Open"
3290 Patterson Ave. SE, MS 1B3
Grand Rapids, MI 49512-1991
Brian.Tillman is the nam...Can I send a recurring e-mail automatically each week
I want to send a e-mail with the same verbiage to the same person once a week
and make it a recurrence with no end date. Can I set this up once in Outlook
so it is scheduled automatically?
Microsoft Office 2003 Version
Students and Teachers Edition
Windows Vista Home Premium
Happy new Year!!
...visible cell only
I'd like to use the PERCENTILE function in a list that has been autofiltered
and get the results based only on the visible cells.
I've used SUBTOTAL in order to get count, average, min and max. But I need
to get the .25 and .75 percentile figures for the filtered data (visible
I've scoured these forums. I've scoured the web. I've found some vba code
that was supposed to select only visible cells but it doesn't work for me. I
posted last week in the programming section of these forums (and again this
morning) but got no reply. I figure...Using part of a cell in a chart title
I have a chart which should get a title. However, this should be partly be
used from a cell e.g.
"counted with 5%"
5% should be taken from the cell and used in the title.
Is this possible?
Yes it's possible but all of the chart title needs to be in the cell. So you
may need to use a helper cell and concatenate text and value.
Andy Pope, Microsoft MVP - Excel
"Nicole" <Nicole@discussions.microsoft.com> wrote in message
news:5CB7A971-AA7F-4C34-BB42-7DC283AA2958@micro...Parsing data from one spreadsheet into another format
The data that we dump out of one machine comes in like below.
%AT_1300 Bottoms|Conductivity| (Water Out) InputRange VDC1to5
%AT_1300 Bottoms|Conductivity| (Water Out) Custom_Range_Low 0.0
%AT_1300 Bottoms|Conductivity| (Water Out) Custom_Range_Hi 0.0
%AT_1300 Bottoms|Conductivity| (Water Out) MinScale 0.0
%AT_1300 Bottoms|Conductivity| (Water Out) MaxScale 20.0
%AT_1300 Bottoms|Conductivity| (Water Out) EngUnits mhos
%AT_1300 Bottoms|Conductivity| (Water Out) StepResponseTime 1.0
%AT_1300 Bottoms|Conductivity| (Water Out) DigFiltTimeCnst 0.016
And I need to convert this data to this f...move cell contents
Is there a way to move a cell contents to another cell with a formula. ex:
if a5="Name" then move g5 to j5? Also, I am using
=INDEX(Sheet1!B3:B12,INT((RAND()*10)+1),1) to pick random names from a list.
I have the formula in different place pick random names from different list.
This does work, but I have different list with some of the same names and
with the random pick I do not want the same name to appear.
Thanks for any and all help.
a formula can only affect the cell it is in, it can't move or change another
cell for this you need some code ...Exchange 2003 new install can not receive external email.
I have just setup a new Windows Server 2003 standard edition with
Exchange 2003 standard edition on it. I have been working for a while
trying to get it to receive external email. I can send out and send/
receive internal messages, but when someone trys to send me a message
from outside our network they get the following returned mail message
This Message was undeliverable due to the following reason:
Each of the following recipients was rejected by a remote mail
The reasons given by the server are included to help you determine
each recipient was rejected.
Recipient: <**...MS Money 95 data files
I hope that some one can answer this for me.
I have used MS Money 95 for years, and it works just fine for me on Windows
XP, however, I now have to reformat my hard drive, and have discovered that
I can nolonger find my original install disk. Will the latest versions of
Money still read the MS Money 95 data files. All that I have ever used the
program for is to track my investments, and am unlikely to do any different
in the future.
In microsoft.public.money, Stan Banner wrote:
>I hope that some one can answer this for me.
>I have used MS Money 95 for years, and...HELP! Need to export hourly sales data on POS (NOT RMS)
How can I export hourly sales data across a date range? For instance, I
want to show hourly sales for the month of October so I can graph it and
post it in our break room.
If I can't export hourly data, can I export daily sales?
The built-in reports don't address this data format.
This is a multi-part message in MIME format.
Mark, This should work for you. Keep in mind it takes up to 5-10 minutes to
load...can't customize toolbar
Operating System: Mac OS X 10.5 (Leopard)
all i see is document elements, quick tables, charts and smartart graphics. i do not see the main menu or the toolbar button. when i attempt to customize the toolbar, the to menu bar and format bar do not appear where they should. on a website i visited, they advised that i drag and drop the temporary toolbar into the real toolbar. but i can't drag and drop the toolbar. i can only move the temporary toolbar. how do i add the menu bar and format bar for go?
You may have hidden the toolbar by accident. Click on the ti...How to change font size on formula bar in Excell 2007
I don't find Tools>Options>General (as suggested in other post answers) in
Excel 2007. On the Office button there is an Excel Options but it doesn't
provide a method of changing font size on the office but. My font is so
small I can barely see it.
Office button>ExcelOptions>Popular tab>in the "When creating new workbooks"
section, choose font and font size
Microsoft MVP - Excel
"jimwillie" <email@example.com> wrote in message
news:588AAC05-0F52-404E-AA01-128E70E02D0B@microso...formula based on format
Is there a way to have a formula that is based on a cell colour or based on
the way a cell is formated? I need it to count the number of occurrences
that this happens.
Thank you for your time.
you'll need VBA. See for an example:
"James Kendall" wrote:
> Is there a way to have a formula that is based on a cell colour or based on
> the way a cell is formated? I need it to count the number of occurrences
> that this happens.
> Thank you for your time.
> Windows NT
> Office 97
This ...Sorting Data #5
Is there formula or anyway to be able sort the below data into a format that
I could create a pivot table on? I spend to many hours doing this every month.
Invoice #: 12345 Invoice Date: 1/16/1950 A/P Code: ABC
Due Date: 1/16/1950 Total Payable: $100.00 Reference: Freight:
Account #: 1234 Description: Name Reference 1 Amount: $100.00
Account #: 4321 Description: Name Reference 2 Amount: $100.00
Account #: 9876 Description: Name Reference 3 Amount: $100.00
Any help would be much appreciated!!
You need to show a Before and After version.
You still might not get any help, but your ...what's the formula for adding symbols in cells?
I have a chart that has blank info in the legend. I want
to add an * to indicate something, but just inserting a
symbol doesn't work. Any ideas? Thanks.
To add information to the legend, you need to add to a series name.
Right click on the chart, select Source Data from the pop up menu, click
on the series tab, select a series, and either type something in the
name box, or click in it and select a cell with the mouse.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
> I have a chart tha...How can I change 'Normal' Style for Word e-mails to 'Normal (Web)'?
Hi, I'm using Word as my e-mail editor in Outlook 2003 and want to change
the default Style for e-mails from 'Normal' to 'Normal (Web)'.
The problem is that new e-mails and replies in HTML format use the 'Normal'
Microsoft Word 'Style', and this has no gap after paragraphs. The upshot of
this is that when sending an e-mail, I have to press return twice to create
a gap, but when the recipient views this, their software shows it as four
gaps (the extra carriage return I typed + their correctly viewed HTML
carriage return after each line).
E.g. I type this:
...Can I make messages unable to be forwarded by the receiver?
We are interested in setting up a private email group at work that receives
Is there a way to make the emails that these users will receive unable to be
forwarded to people outside of the group? Make private, or somehow else
prevent the information from getting outside of the approved recipient list?
no. and you can't keep people from printing it, copying and pasting the
contents of it, taking a screen shot of it, etc, etc...
"Jonna Kosalko" wrote:
> We are interested in setting up a private email group at work that receives
...Can anyone help ?
I have created a holiday planner for staff with in are company
and i need a formula that gives us only 10% of the total number of staff are
off on holiday.
would be greatful if anyone could help.
Hello - If you have a total somewhere (I would suggest inserting a column on
your spreadsheet titled Total and then entering a "1" if the person is going
to be out, then total the column of "1"s by entering "=SUM(x:y)" where
x=first cell in the range, and y=last cell in the range), in a different
cell, enter "=.1*z" where z equals the total of people out...This formula doesn't work: = day(today())
This formula doesn't work: = day(today())
Except from spreading one formula into 2, is it possible to make it workable in
If so, how?
- I'm using Office XP
- I'm using Windows XP
���H����O�D�`����. �p��������B, ���Ѫ̤��[�祿!!
My ability is very limited. Hope you will not mind to enlighten me if I do
What doesn't work?
For today (7 May 2004)
In article <eYuAXhDNEHA.624@TK2MSFTNGP11.phx.gbl>,
"0-0 Wai Wai ^-^" <firstname.lastname@example.org> wrote:
> This formula doesn't work: = day...HELP! remote data not accessible msg
I have a use who is currently using a Bloomberg DDE add-
in. Whenever he attempts to activate the add-in to
retreive remote data, the system hangs. If I go to task
manager, I then see a message stating "Remote data not
accessible. To access this data Excel needs to open
another program.... I have searched the knowledge base
and didn't find much help. Does anyone have any ideas? I
am desperate!!!! We are currently using Excel 2003 in XP
...Can you only merge up to a certain number of cells
I am working on microsoft excel 2003, I have a sheet that I merged cells
starting with line 8 through 43...when I type my information in the merged
area I can see all that I am typing...say it goes up to line 30 once I hit
the enter key I can only see up to line 20. Even when I print it out it only
prints up to line 20...I have checked to make sure there are not locked cells
etc. I cannot figure out at all why this is happening...is there only up to
a certain number of cells you can merge?
From "Excel Specifications and Limits"
Length of cell contents (text) ...[b]Can I download Excel data to a MS Access database?[/b]
I've built an Excel 2002 form that I want our internal customers to
access from our intranet, and use. Once completed, they will send it
to us as an e-mail attachment. I'd like to be able to open it, and
somehow download the data from the form into an MS Access 2002
database I've built (so that we don't have to rekey it into the
Is this possible or even feasible? Any and all help is appreciated.
Message sent via www.excelforums.com
in Access check 'File - Import External data'
"...How do I merge cells with multiple data values?
I've tried highlighting the two cells which are in the same row. It
suggested that I format and align. Both of which I've tried. I keep getting
the same error message, "The selection contains multiple data values. Merging
into one cell will keep the upper-most data only." I need to make the cells
one with all my information. Is this possible?
Not knowing what you want to do, let me make a suggestion. Put all your
data into the first cell and leave the second cell empty. Select both
cells. Click on Format - Cells - Alignment tab. In the "Horizontal" b...outputting values to a range from one formula
I wish to generate a table automatically by means of a single
formula that applies an iteration on a starting given value with
a given step, and the computed values are posted/entered
automtically into cells from a given cell onwards, say below
it, until the computed value reaches a certain given limt.
This is somehow the inverse of INDIRECT or of OFFSET. These
can pull values from a variable addresses of cells. What I need
is to push values into a variable addresses of cells.
Can anyone help me on that??