Is there a way to empty the Deleted Items folder by date?
Is there a way to get Outlook to delete items in the Deleted Items
folder that have been in there for some period of time (1 week, 1
I know there is a Tools option to empty it on exit, but I sometimes
want to recover a file a few days later.
> Is there a way to get Outlook to delete items in the Deleted Items
> folder that have been in there for some period of time (1 week, 1
> month, ???)?
> I know there is a Tools option to empty it on exit, but I sometimes
> want to recover a file a few days later.
Use AutoArchive. Enable the global...WAB and Office 2k3 problem
I've Outlook 2003 connected to an Exchange 2003 server. The only
addresses that appear in my address book are the Global Addresses from the
server, my contacts do not appear. Now when I go to the appropriate
"Outlook Address Book" tab in the contacts properties dialog, the "Show this
folder as an e-mail Address Book" checkbox is grayed out. I have several
other contact folders that exhibit the same grayed out checkbox. If I try
to add them from the Options dialog in the Address Book specifically, they
don't even show up in the as being avail...Installing office 2007 student over a standard trial
My computer came pre-installed with a copy of Microsoft office, I
don't' recall which version, but it is expired and had Excel, OneNote,
PowerPoint, and Word.
I've signed up for night school courses, and the school lets students
download and install Office 2007 as a perk. Do I need to remove the
trial before running the installer?
Also, I've heard that Office 2003 and 2007 can coexist. I currently
have my old copy of office 2003 installed on Virtual PC with my old
copy of Windows XP professional, can I have both available on the host
How would I set that up?...sorting dates in Excel 97
Running a worksheet that lists all medical expenses and am not able to
always insert date, expense, who to, in correct sequence. Some postings just
come in on time. Is there a sort formula that will allow me to sort these
entries in sequence? Will the sorting move up the entire row that lists
date, amount, payable to, etc. also? Thank you, Steve T.
I wouldn't use any formulas for this.
I'd select the range (all the columns in that range, plus the last row of
headers, plus all the data) and do Data|Sort
If you include all the columns that should move with the sort, you'll ...Publisher 2007: How do I change dates on calendar page in newslet
I'm creating a newsletter. I added a calendar page. In previous versions of
Publisher, I was able to get to Calendar Options to change the month. In
Publisher 2007 when I insert a calendar page into a newsletter, I can no
longer access the Calendar Options task pane. Please describe how to change
The calendar wizard is broken. Hopefully it will be fixed in a future service
pack. Meanwhile you will have to manually change the calendar dates.
Mary Sauer MSFT MVP
"Stephanie" &...dates in excel #2
need help with the date function
this is the situation
i use excel daily to create a report. as this report is
printed out i just save changes made.
except at the weekend when i also make backups so that my
boss can send the report by email on monday mornings.
in the report we use the NOW function to display the date.
when we used to open the backups the date never used to
change ie if saturdays backup was opened on monday morning
it used to still display saturdays date.
now for some reason the date is automatically updating.
anybody know how to prevent this happening
You probabl...How to convert US date format to European
My computer is set up to use the European style dates (ddmmyyyy), not the
USA-style dates (mmddyyyy format). So if I enter "01/06/05" I get a date of
01-June-2005. However when I download some information in CSV format at
times that same date is formatted like this: "06/01/05". However this is
interpreted as 06-January-2005 in the spreadsheet. How can I convert the US
formatted values to European, in effect swapping the first two numbers?
1025 Osborne Rd.,
New Germany, NS, Canada
Rename the .csv file to .txt
File|open that .txt file...I don"t office,but need Excel or some part of it to open a web pag
help me I don't won't to load all of office
> help me I don't won't to load all of office
you can buy Excel as separate product.
"cowboy" <firstname.lastname@example.org> schrieb im Newsbeitrag
> help me I don't won't to load all of office
When about to load office, choose custom. You can then
choose when to load certain parts. You can install them
when you use them the first time. The installer will ask ...Date format of 0 and if statements
I have an is statment as such:
=IF('Raw Data'!A5=0,,'Raw Data'!A5)
This issue I have is when I format fields as "date" and the
reference cell = 0 excel formates the cell as 01/00/00.
I have also used the formula:
=IF('Raw Data'!A5=0,"",'Raw Data'!A5)
The issue I have is I want to create graphs of this data in
a dynamic fashion, but when the data range of the graph
encounters either "" or 1/00/00 as a date, it plots it as a
data point. I need a way to make my IF statment to produce
a BLANK or EMPTY cell. Is there a key word in...2 Formatting Questions
Can we, in the CRM forms, format dates to read into the “15 Aug 2005”
format? This is possible in reports, but by default, the forms use only
numbers for dates, but in any format.
Any ideas of how to track multiple currencies in the same application -
specifically USD and Canadian? I know a Microsoft CRM installation currently
supports one language. But aside from using a picklist to specify "USD",
"CAN", "MEX", or other I'm concerned about how their forecasting.
www.visalign.c...outlook web access in office xp pro
Is Outlook web access available with office xp pro? If
so, how do I obtain it? Thx
Outlook Web Access requires an Exchange Server.
Author, Special Edition Using Microsoft Outlook 2003
***Please post all replies to the newsgroups***
"brad" <email@example.com> wrote in message
> Is Outlook web access available with office xp pro? If
> so, how do I obtain it? Thx
...HELP! When I removed Office XP did I lose by inbox file?
I didn't archive my inbox and personal folders before
removing Office XP. Now I have reinstalled Office XP and
thought I could find my old data files. but all of the
import and repair tools work with PST which I don't have.
I remember that previously there were seperate inbox
files and can not find them now.
Thank you for your input. Ron
Be sure to show hidden and system files on your computer and then do a
search for *.pst. This should get you started...
"Ron" <firstname.lastname@example.org> wrote in message
news:email@example.com....VBA date question
Why isn't this working?
I have a form which has a text box for an attribute of type DATE. This
attribute, foo, is normally null when the form is loaded. I tried
setting the default value for the text box to "Date()" but it doesn't
show up (i'm thinking it's because I'm actually running a join query
to generate the record for the form so the form never gets the
opportunity to display the default value for foo since it thinks it's
supposed to be null, the result from the query)
So I added some code like this:
Private Sub Form_Open(Cancel As Integer)
If (I...Date/Time field calculation
i am trying to make a sum calculation on a field that keeps duration of
time. How can i do this? I get errors or zero as result.
On Jun 21, 10:02 am, Stathis <s_paraske...@hotmail.com> wrote:
> i am trying to make a sum calculation on a field that keeps duration of
> time. How can i do this? I get errors or zero as result.
You need to do the calculation at a level at least 1 level below what
you want the answer to be in.
msgbox DateDiff("h", #6/20/2007 1:00:00 AM#, #6/20/2007 1:30:00
will give an ans...Multiple Users for office #2
Operating System: Mac OS X 10.6 (Snow Leopard)
Hi, if I have office:2008 installed on my imac and I set up a new user (one of may staff has left and the new person is using the same machine) how do I get office to appear in the list of applications? I am hoping i dont have to reinstall given it is the same licence being used, just by a new person.
All help much appreciated
> Hi, if I have office:2008 installed on my imac and I set up a new user (one of may staff has left and the new person is using the same machine) how do I get office to appear in the...linking a date colmn with outlook calender
I am using a financial sheet, on which loan is given to customer(s) fo
6 months (180 days), when the 6 months competted, some time
fogot/,miss to collect the loan back from customer(s). So, i want t
import the same sheet to outlook calender so it automatically inform m
on exact date (after completing 6 months).
Can some one help me to sort out.
Message posted from http://www.ExcelForum.com
Seems preety complicated.
Else plot the due dates in excel and conditionally format the cells t
be highlighted in case date is the present day i.e today
Message posted from http://ww...Change Directory Creation/Modification Date/Time programatically
Can anyone help me out to change the directory creation/modification
date/time through C++/MFC code? Can this be acheived without changing the
Thanks in advance.
In article <98EDAE87-3F31-4F06-AE8C-378CF91A6F3A@microsoft.com>,
> Can anyone help me out to change the directory creation/modification
> date/time through C++/MFC code?
> Can this be acheived without changing the system time?
The universe is a figment of its own imagination.
"Je...Can't open office documents from my emails until word is openned f
When I try to open a word document or excel spreadsheet that is saved as an
attachement to an email, I get the message:
Windows cannot find ‘c:/users/mona/appdata/local\microsoft\windows\temporary
internet files\low\content.IE5\SB2EHHFL\xxx.xls\’ Make sure you typed the
name correctly, and then try again.
If I open Word or Excel before clicking on the attachement to open it, then
it works. This problem only happens when using my laptop which is running
Windows Vista and office 2007. I do not have any problems with this on our
desktop which is running XP and office 2003.
Wo...How to validate User ID creation date in Windows XP
Is there a way to validate the creation date of local User IDs in Windows
> Is there a way to validate the creation date of local User IDs in Windows
You could query the Security Log but you will only get the information
if the log was setup to record events 624 and providing that the log
wasn't purged or overwritten:
cscript c:\windows\system32\eventquery.vbs /L security /FI "id eq 624"
Other than that verifying the creation date on the user's profile folder
is the only way that I know of to get the information.
...Date and Auto Fill
I'm trying to auto fill a column with dates. Everytime I I use the auto fill
command it changes the year rather than the day. I do have "day" selected in
the fill series command. What am I doing wrong??
Sounds as though you're talking about Excel, not Access, the database
product that's part of Office Professional, and the focus of this particular
You'd be better off reposting to a newsgroup related to Excel. When you
repost, it would probably help the responder to know what version of Excel
you're using, and possibly the operating system on ...Entourage Reminders showing dates for next month overdue
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC
Email Client: pop
Recently my reminder window has been showing me events as overdue, but upon looking closer find the date showing as next months events. Why are late December dates showing as overdue in November. The are events that occur monthly and are set up to remind 2 to 3 days in advance.
On Nov 26, 5:24=A0pm, tankmas...@officeformac.com wrote:
> Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Power =
PC Email Client: pop Recently my reminder window has been showing me events=
a...how do I change list order in color catagory assignment in office
only 15 color catagories can be displayed in color assignment in office
outlook 2007. I wish to change the order of the list. I tried to number them
1-15, but it did not change the list. It did show 10-15 in the top of the
list, and 1-9 on the bottom. I wish it to show them in order of 1-15, not
necessarily with numbers, but with the color and catagory that I have assigne
any help would be appreciated THNX
Hi All ...
I'm a newbeee using vb2008 express, vs2008, & sql 2008 express.
I have created a column in my sql table with the DATE data type as I only
want to store/display the date portion in my winform control field which
works fine on a but on a report I also get the default time (12:00:00 AM)
How do I truncate or format this to only display the date portion on the
> How do I truncate or format this to only display the date portion on the
> report ?
The report is done using ? Programmatically you would call
...copy/paste into excel changes numbers into date format
I need to copy a lot of raw data from html format into
Most of the data consists of a min/max figure (eg. 31/45)
Excel (2003) always converts this number to date format
no matter what I format the cells as. I have been
unsuccesful in converting back to the same format.
Any help or advice is appreciated.
try formating the cell s as 'Text' before pasting the values
> I need to copy a lot of raw data from html format into
> Most of the data consists of a min/max figure (eg. 31/45)
&...Formatting a text box for date entry only
Is there a way to format a text box on a user form to only allow date
entries ie: mm/dd/yy or mm/dd/yyyy?
Not really, but you can ensure it is a date, like so
Private Sub Worksheet_Change(ByVal Target As Range)
Dim fValid As Boolean
fValid = False
On Error GoTo ws_exit
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("A1:A10")) Is Nothing Then
If IsNumeric(.Value) Then
If IsDate(.Value) Then
If Year(.Value) >= 1970 And Year(.Value) <= 2999 Then