Saving existing Outlook emails
I'm needing to re-format my harddrive and am wondering how
I can save my existing Outlook emails and settings so that
once I have the newly reformatted drive setup I can access
my saved emails and files?
do a search in your hard drive for *.pst... it contains all e-mails and
contacts... in brief, all eggs in one basket. If you have mail rules you can
export them, as you can your mail account(s).
<firstname.lastname@example.org> wrote in message
> I'm needing to re-format my harddrive and am wondering how
> I can ...Document not saved #5
I am trying to save a spreadsheet.
Everythgin seems fine excpet for the message "Document not saved"
Why is it telling me this and how can I save my work?
I have tried saving it to different places and I still get the same message.
When you attempt to save a workbook, you may receive the following error
Document Not Saved
This problem may occur when the following conditions are true:
The workbook was created from a template that contained an embedded object.
You have inserted a worksheet into your workbook from...Workflow rule on (Order)Products and columns of related entities in advanced find view
Does anyone know whether it's possible to create workflow rules on
(Order)Products, since the entity Products isn't part of the standard
In my example I have added a new (expiry) date attribute on the
Now I would like to add a workflow rule on that datefield to create a
task when the expiry date is nearly reached; but the problem I have is
that i can't "reach" the fields on the OrderProduct form to put a
workflow rule on?
Another problem I have is that I've created an advanced find query in
which I query customers who have or...Saving a calculated field
First, yes I have read the threads on storing a calculated field and that it
is bad mojo to do that. However, I have pay data that I calculate and input
to a database and it must be able to be reconciled with our ADP data. So I
need the ability to change and fix the data so it does not change as a result
of recalculations. I have a form with a field that calculates the pay based
on hours and pay rate. I have another field (the "copy" field) next to that
one that has the control source set to the database field. I have set the
default value of that field to be equal to the...reflecting values in a column into a row
I am creating a chart to map a round-robin chess game. If there are 4
players, then all 4 has to play one another.
if I have the names
Then I'd like to type them into a columns and write a formula in a
row to pick up the names
the spreadsheet should then look like this:
John Mike Sally Bill
I think it may be achieved with the Indirect() function, but my Excel
2007 help seems broken and I can't figure it out without an example.
With names in A2:A5
Enter in B1 =INDIRECT("A"&COLUMN(B1))
Or...Not able to open imported accounts 4.0
We have a situation where we've updated a client from 3.0 to CRM 4.0 and have
an import that brings in new Accounts. Unfortunately, we can open accounts
that don't have a parent account but can't open the parent account itself. In
essence, we have two accounts with another one the parent - we can open ones
that show the parent, but again, we get an error - see yor administrator. Is
there a rights issue or relational setup we're missing.
...save as problem
I cant save my excel file
The "save as" option is not eviable. Whats happening?
"From a prior post by Ron DeBruin,
You can reset your menubar to default.
Right click menubar. Customize > Toolbars Tab. Select worksheet
menubar. Click Reset button.
Using VBA Application :
CommandBars(""Worksheet menu bar"").Controls(""File"").Reset
Or the whole menubar
You lost the things you add to the menubar!!"
And one link that offers some sugges...Second E-Mail Account (Address)
I have set up a second e-mail account using the same POP3 and SMTP servers
(provided by the ISP) as I used to set up the first e-mail account. The
first e-mail address is working fine, but when I send an e-mail to the
second address (from the default account), it does not appear in the Inbox.
The e-mail does appear in the Sent Items folder with no errors.
How do I access the second account to receive/send e-mails?
Thank you for your solution(s).
Using Integration manager i am able to insert fixed allocation accounts for
general ledger. However, if i have to make changes to these accounts, say if
i want to change percentages and then update the old percentages with the new
ones, the updates fail when i use Integration Manager.
Error Message displayed - xxxx-xx-xxxx distribution account already exist.
Can anybody tell me why is the updates fail and how to overcome it? And
please note that integration is set in "INSERT & UPDATE" mode.
Integration Manager does not update transactions.
That drop down option should ...Outlook 2007: When i Save a New Rule outlook Change it automatically...
I have this problem with Outlook 2007. I have 15 e-mails addresses in
my outlook, but i can=B4t create the rules for send all the received
mails to each emails folder.
I want to create a simple rule that move all the e-mail that i get
from "email@example.com" to the folder "Inbox/
firstname.lastname@example.org". When i create the rule, all works fine, i
select the correct e-mail account name, the correct destination
folder, etc... but when I hit the SAVE button in rules window, Outlook
2007 changes the account automatically to another one. Not
automatically...need to make a formula that would add a field value to current dat
I have made a form in which I input different values. On of the values is
(How Many Days). Now I need to a assign a default value, or expression (not
sure which way to go about this) that will take the date value for (Date) and
add the value (How Many Days)
I figured that the formula should read =sum([Date]+[How Many Days])
But that is not giving me any results, thanx for your help in advance
=DateDiff("d", Date(), [How Many Days])
"J Man" wrote:
> I have made a form in which I input different values. On of the values is ...Emails don't find contacts in restored Outlook
My hard drive burned up, so I replaced it, reinstalled, and imported
everything into Outlook. The contacts are there if you click contacts.
However, when sending emails, there is no way to connect to my contacts.
It's like they are invisible.
You never import Outlook data to restore it. You just open the Outlook data
When you do, you will be able to configure your address book view to display
your Contacts the same way as always:
"Mike Row Soft" <MikeR...column value translation
I'm sorry if this is already here somewhere, but I could't find any references.
I need to upload a list of people into our computer system and this list is
comprised of their names and the code for the branch where they work. The
computer system into which I need to upload this list will not recognize the
current branch ID code for those employees, but I do have a list that is
basically a comparison of the two different codes. For example branch code
800 on the list equals branch code C001 in the system. I need to get a way in
excel to convert all the branch codes that are next...restore accounts
A user accidently deleted some accounts. What's the easiest way to get them
back? I have the backup of all the databases. Please indicate. Thanks.
there is no way to restore the accounts except restoring a backup of your
For the future you should forbid deleting in the security role...then the
users only can deactivate the accounts (thats the recommended way, instead
> A user accidently deleted some accounts. What's the easiest way to get
> them back? I have the backup of all the databases. Please indicate.
...Fill cells with interpolated values
What is the easiest way to fill cells with linear
interpolated values ?
e.g. i have value 5 in cell A1, and value 15 in cell A6.
Cells A2 ... A5 should now be filles with 7, 9, 11, 13.
of course, it's not a big deal to write a formula for
interpolation, but maybe there is more simple way, (just
by some mouse clicks....?)
Select the range A1:A6 with your start and stop value in their respective cells,
and then do Edit / Fill / Series / Trend / Linear
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/...some replies come from default account
Some email replies from me come from the address to which the email was sent
and others come from my default address.
For example if I reply to a message that came to email@example.com, the
reply comes from firstname.lastname@example.org. I can change it manually for each
reply but that's a pain and if I forget to it's a problem.
Not all messages behave this way. Some come from the correct "reply from"
address. I can't figure out what the difference is for those that come from
the correct address.
I'm using OL2000 on XP, Internet Mail Only.
Any ideas what'...Someone must have asked this before but I can't find it!
Being a relative Excel newcomer I,m not sure of all the terminology so
may have used the wrong terms when searching. What I am trying to do is
create a worksheet in which a cell shows one of 3 values (LOW,AVERAGE
or HIGH) according to the value in the cell to the left of it, which
itself is the sum of the 2 preceding cells.
To be more specific, cell D6 is Men, E6 is Women and F6
is"=SUM(D6,E6)". I then want G6 to show "LOW" if F6 is less than 5,
"AVERAGE" if it is between 5 and 20, and "HIGH" if it is over 20.
If anyone understands the question and can h...Date & Time file was last saved
Is there away to display in a cell the date & time the file was last saved?
I know you can do this in word but is it possible in Excel 2002?
Here is an UDF
Function DocProps(prop As String)
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties(prop)
DocProps = CVErr(xlErrValue)
Now you can use the following formula in one of your cells:
=DocProps("Last save time")
Obviously, the file has to have been saved.
... looking out across Poole Harbour to ...XML Deserialize of empty value
I'm encountering a strange issue when deserializing a piece of XML. If I
have the following XML and try to deserialize it, everything works:
If I have the following XML, everything works:
BUT if instead I have the following XML, the "margin" element is always 0:
Why...investment importing & "recover account"
Hello. I'm using 2006 and am unable to directly connect to Principal
Financial Group to directly download my account transactions. I've been
downloading my transactions in a .qif file and am trying to use the
recommended "recover account" approach to import the investment
When Money opens the file, however, my Principal account, which is in my
money file with transactions, is not listed. The only account listed as
available to import the transactions is one other investment account that is
a single stock - held by itself. Why would my account not be list...Search and display a value from a XMLDOCUMENT
I have the following XMLDOCUMENT loaded in memory:
And I need to retreive the value in <NUM_VALOR>, I had tried of many ways,
but I can´t do it,
Please somebody h...Retrieving values from lookups
Is it possible to use client side scripting to achieve the following? If
not, what is a good approach for handling this.
On the Case record there is a field called responsiblecontactid which is a
lookup. When a contact is selected we want to pull specific attributes from
the Contact record onto a few custom fields on the Case. Specifically phone
Any information anyone has is greatly appreciated!
If you are interested in custom solution for your requirements, Please drop
a email to know more information.
mani...I need help assigning a value to a character
I need to format a cell so that if I enter an upper case "Y" it display
the "Y" but the cell thinks the value of the "Y" is "1" so that it ca
be added in another function elsewhere. I have tried to use the "IF
functions but have had no success as of yet. HELP
billybob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2661
View this thread: http://www.excelforum.com/showthread.php?threadid=39881
in cell a11 type in
=SUM(IF(A1:A10=...Update values in close opportunity form
I want to update the values in the drop down of the close opportunity
form. I want to add/remove the values in the status reason field
Is there any way I can do this?
Not using the default crm forms. You have to build a custom aspx page calling
the webservice for this. The CRM SDK has some details on this look for the
Patrick Verbeeten (MCSD)
> I want to update the values in the drop down of the close opportunity
> form. I want to add/rem...Run Time Error on trying to save workbook
This code worked perfect when it was in the User Form Code Window, but I
moved it to a module and I get a Run Time Error "424' Object Required
Code in the User Form Window
'Save Installer Forms 11 Control Button
'Located in M3_Save_Workbook
Private Sub Save_Installer_Forms_11_Click()
Code Located in the module: