pst file too big
Tried to open my Outlook today and it refused to open.
Went in and removed the personal file folder (pst) and it
worked fine. Trouble is that that pst file is too big (is
over 150 mbyte. I can reduce it but Outlook won't let me
open it to do that. Any ideas how I can open it?
Actually speaking 150 MB is really not too big for the PST file. You can
probably try searching for the Inbox Repair Tool ( scanpst.exe ) and then
try repairing the PST file.
"Rich Flight" <email@example.com> wrote in message
news:0ea701c3fb52$1b...How can I set up the random selection of a cell from within a ran.
I want Excel to randomly select one cell from a range of cells, but is it
possible? This would be the equivalent of drawing one slip of paper from
An uncomplicated way to do this is to simply add a column filled with the
RAND() function next to your column of choices.
Select both columns, and sort on the Rand() column.
Pick the one at the top, or bottom, as your random selection.
A little more complicated procedure would be to use a formula, referring to
this combination of Rand() and your list, and let this formula randomly pick
Place your list in an "out o...Can you program Excel to draw an asymptote?
I want to know if there is a way to get excel to put an asymptote on a chart
if you already have a parabolic data set on the chart. My goal is to find to
value of the asymptote for further analysis. I know I can fudge a straight
line graph onto the chart but it is not meaningful without the true value.
"csusbgirl07" <firstname.lastname@example.org> schrieb im
> I want to know if there is a way to get excel to put an asymptote on
> if you already have a parabolic data set ...outlook can't receive exe files
A guy here at work can't get exe files through his outlook. Is there a check
to uncheck somewhere to allow it to do this? He can receive normal
...how can i do this
i am using office 2007
i have a table called titles that has title of the movie and the another
field called year of movie also another table called actor that has actor
name of the actos and another infos
and third table called title-actor which is junction table of the two
previous tables and has the fields of title,year,actor name year
the title and the year is conectted to titles table and the actor name to
the actor name in actor table
now i have form based on each of the two tables and each one has sub form
whichs based one the junction table
the title form has su...Can field names be changed with a query?
I've got a sequence of queries that culminates in a final make-table query.
I would like to change the fieldnames with the final query, producing the
table with new fieldnames. Is there a way to do this?
Sure. In the field name put what you want to see in the new table like so:
What is before the colon ( : ) should be the new field name.
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
> I've got a sequence of queries that culminates in a final make-tab...How can I get Outlook (2002) from deleting emails older than 6 day
I have auto-archiving turned off, ansd I am doing backups manually thru the
Science-based nutrition! See TIOEnterprises.net
Change your view settings - enable the advanced toolbar and use the dropdown
to enable all messages, not just messages from the last seven days.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
"Mark Hilbrink" <MarkHilbrink@discussions.microsoft.com> wrote in message
news:639E637B-C8B...Open excel file through macro
I have one excel file with a column for file names and its entire path
written into it. Is there any code through which i can open those
file, read some data and close that file.
Dim myC As Range
Dim myB As Workbook
Dim myData As Variant
For Each myC In Range("A2:A100")
Set myB = Workbooks.Open(myC.Value)
'Read your data
myData = myB.Sheets(1).Range("A2").Value
'Do something with your data - write it next to the workbook name
myC(1,2).Value = myData
But there is no need to open the workbooks to read data - you coul...Outlook 2003
I would really appreciate some help on this. I run Norton AntiVirus and it
has this really aggravating behavior .. all virus infected attachments are
deleted, but the emails they rode in on end up in my inbox. There is no NAV
option to not only delete a virus infected attachment but also its email.
Since all of the virus infected email I get is spam, I end up with lots of
extra junk in my inbox. The Outlook 2003 junk filtering does a pretty good
job on everything else.
So .. I want to create a rule to move all emails with a file attachment
called "Norton AntiVirus Deleted1...Can't group pivot table items by month in Excel
i use excel 2004 for mac but have the same problem using 2003 for windows. i
have a pivot table with dates in the rows, names in the columns and count of
quantity in the data section. i want to group the date entries by month. i
follow microsoft's help directions listed below but i am never prompted with
a starting at box, ending at box or by box. the pivot table just groups
whatever i have highlighted and gives me no other options. i would like to
use this smart grouping option. please help.
1. Hold down CONTROL and click the selected date or time items, point to
Group and Outline...Saving and Restoring a Child Window to its Former Position and Size
I want to save a child window's position and size in the Main Window of an
MDI application, and restore it at any time later. I want to do this after
the user may have reposition and resized it. The parent of this child window
is the Main Window. Below is the code I am using to save the position and
pView->GetWindowRect( &m_WndRect );
AfxGetMainWnd()->ScreenToClient( &m_WndRect );
where pView is a pointer to the child window and m_WndRect is used for the
storage. Below is the code I am using in an attempt to restore the position
and size stored in m_WndRect:
CFr...Someone who can provide TRaining in NJ
I just openned a retail store in NJ. I need some help with some features
and am looking for some in store training formyself and my partner. We are
looking for informal, mostly question and answer training and demonstration
and maybe some assistance in setting up some features we are unsure about.
We have been using the system for several months now.
We have installed over 100 stores across North America remotely. Are
services are a $100/hr and we can spread out training sessions over serveral
days to allow you to digest the information.
If interested you can contact me a...Publisher 2007
We just upgraded to Office 2007. In my old version of Publisher (2003), the
print settings I had assigned to each file were retained in that file--very
handy in Publisher as some of the print settings can get complex at times. I
print to a variety of different printers and have different settings for
print jobs going to each. It appears as if this feature is no longer present.
Is this true or is there some way to retain them? Setting manually can get
time-consuming. Any suggestions?
I'm replying to my own post here, but I found the solution! In Publisher
2007, rather t...I have a column of many many numbers how can i split them up auto
I have a group of numbered data that I can split into different columns using
text to column. I now need to place a blank row in between each row of
diffeerent data. Can this be done
Give a few examples of what your data looks like and what you are
trying to achieve. What do you mean by "different data".
On Dec 3, 8:23=A0pm, Kevin <Ke...@discussions.microsoft.com> wrote:
> I have a group of numbered data that I can split into different columns u=
> text to column. =A0I now need to place a blank row in between each row of
> diffeerent data. ...Can I do Labels from out look and also How do I
I really need to print some adress labels and put them on another computer
how can I do this? I can either use mord or out look
Check OfficeOnline's template section to see if something there suits your
"Capggal" <Capggal@discussions.microsoft.com> wrote in message
>I really need to print some adress labels and put them on another computer
> how can I do this? I can either use mord or out look
...Allen Browne - Find as you type
Hello Allen (or others)
I am using Allen Browne's great utility 'Find as you type' on a form, but
now want to print the results of the forms output. Can it be done?
"efandango" <email@example.com> wrote in message
> I am using Allen Browne's great utility 'Find as you type' on a form, but
> now want to print the results of the forms output. Can it be done?
You may be able to apply the form's filter as the WhereCondition for
OpenReport, like this:
...Save Linked tables values in form based table
I am planning to have main form and sub form architecture. In my main form(
linked table to foreign database) I have ID and demographic values and this
main form is connected to a subform by ID and has test details.
My question is How can I save the demographic data into my sub-form based
I know it is bad normalization but need to have all the data related to my id
stored in my table ( it will very few so not worried about re-dundancy.
Message posted via http://www.accessmonster.com
You never need to be redundant. A query with a join on the ID field will
...Opening an excel file on another computer changes the setup on fil
Opening an excel file from a diskette that was created on a different
computer changes the setup on file. How can I prevent that from happening?
I created file on desktop and open it on laptop, all of my margins, column
widths are changed. I'm using on both computers Win XP and Excel 2003. Any
Maybe it's not excel's fault.
If you both use different printers (or different printer drivers), maybe excel
is doing its best to make sure the page layout is as close as it can be.
> Opening an excel file from a diskette that was cr...Can (or how can) I do this
My Access application tracks an employee's progress through a process
similar to hiring. There are 5 steps in the process. I track 4 of the steps
by counting the number of times a value appears in a date field for that
step. The count is then displayed and used in a calculation. The 5th step
is more complicated. The 5th step needs to determine if the employee has
verified that he can access all the applications that he should have access
My process tracking table has the first 4 dates. The application access
info comes from a different table. This process trackin...Changing a single value in an xml file
I often have to change a single value in an xml file based off of a given ID.
Is there any easy way to do this through .net.xml?
Do I have to parse the file then write it out again?
> I often have to change a single value in an xml file based off of a given ID.
> Is there any easy way to do this through .net.xml?
Depending on what you are used to DOM is rather simple, if the attribute
is defined in the DTD and of type ID then all you need is
XmlDocument xmlDocument = new XmlDocument();
XmlElement element = xmlDocument.GetElement...Can I create a one page Twelve Month Calendar
I am trying to create a One Page Twelve Month (2006) Calendar, using either
Publisher or Power Point, that gives me room for Logo and/or address to
distribute among my customers.
New, Publications for print, calendars, when the wizard opens and you select your
design choice, there are options for date range and so on.
Mary Sauer MSFT MVP
"Chezerim" <Chezerim@discussions.microsoft.com> wrote in message
>I am t...Investment Type vs Savings Type Accounts
What is the significant difference between a Savings type account
verse an Investment-IRA type account that involves only cash
I am uncertain about which type of account should be used in MNY03
deluxe to record the transactions for an existing traditional IRA
(money market) account that was opened at a local savings bank in
year1999 and closed during year 2006. A once-a-year transfer of funds
(i.e., Transfer Money) from a regular money market account at tax
time was made to the IRA account.
Can an account type be changed without complications at a later time?
Vin...How can I scan images into seperate worksheets at once?
I am trying to use my scanner to insert documents into excel. When I do it,
it adds all the images into one sheet that overlap each other. How can I get
excel to add each image to its own worksheet?
> I am trying to use my scanner to insert documents into excel. When I do it,
> it adds all the images into one sheet that overlap each other. How can I get
> excel to add each image to its own worksheet?
What I do is scan into a file, then run that file through OCR software
and then that data goes into Excel. But then I want data I can
manipulate with Excel -- I&...Can I save my presentation to open up in the first slide
I'm using PP 2003 and want to run off my presentation on CD's. When I save
it, and play the CD, it opens up in my work window. All the tools at the top
and the slides to the left of the screen. Is it possible to save it and
have it open to my first slide on the screen, and show from there, without
all the tools showing from the work screen.
"Grace" <Grace@discussions.microsoft.com> wrote in message
> I'm using PP 2003 and want to run off my presentation on CD's. When I
> sa...Can a macro be written to launch a pre-canned e-mail?
I need to launch an e-mail quickly with as few key strokes as possible. The
e-mail needs to have a pre-canned subject line, a simple pre-canned message
body and, a follow up flag. I have a template but also need to set the
Follow up flag each time I send it and this has proven more time consuming
than is practical for this application.
Can a macro be written to open the template and set the follow up flag to
the current date and 1 minute forward from the current time?
Most of the time the message will be sent with just that. On occasion I may
need to add a word or two to the subject...