How chart time scale x-axis with another date serie
Hello all. I have this problem, I will need to create this chart that I don't
know how to.
Serie 1 is below which needs to be time scaled
Serie 2 - needs to plot the three dates in serie 1's time scaled X-Axis with
I will look something like you have a line of count on a time-scaled chart,
with 3 dates point in the x-axis. Please ...Error message needed if incorrect Date Of Birth (DOB) entered
In cell D6 I have a DOB entered....in cell E6 I have a datedif function that
has 3 conditional formatting set as:
1 - If D6 is blank, E6 is blank.
2 - If DOB in D6 is between 18 - 24 then E6 shows age and cell is yellow.
3 - If DOB in D6 is 25 or over then E6 shows age and cell is blue.
What I need is when a DOB is entered in D6 under 16 years old, then D6
returns an error message -" You have Entered an Age under 16 Years - Retry!!
I have tried Data Validation, but cant get a message from tha as I dont know
what to set as the date validation.
I do need a...Why does copy and paste between eMails not work?
Copy no longer copies to the clipboard. Is there a setting I have deleted
somewhere? Using Windows 7 and Office 2007 proffessional.
Does it work if you restart outlook?
Do you have any addins installed that could be erasing the clipboard? I've
seen this happen with addins and contacts, but not email. to test, open the
new message form before copying so you just need to copy and switch to the
other message. (http://www.slipstick.com/Contacts/clipboard.htm)
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Cent...ALL of my email is gone- getting error message as well
I am getting this message:
The message store has been corrupted by an application external to Windows
Mail. Windows Mail has been able to successfully recover from this
In addition ALL of my emails are gone.
Any suggestions on how I can recover them? And what I should do about the
Try running the various repair functions in
the WMUtil program: http://www.oehelp.com/WMUtil
If still no improvement, upgrade to Windows Live Mail:
It will automatically import all your WM data.
Gary VanderMolen, Microsoft MVP (Mai...Not able to send email from CRM client
I cannot get CRM configured to send email from the CRM
client software. See error message below.
I have tried all the solutions I can find, including:
-Confirmed mailserverurl is set correctly on the CRM
server and that the specified server is the Exchange
-Confirmed that the mailserverurl returns well formed XML.
-Gave the IUSR_ORCAS user full control of the
the "...mailroot/vsi 1" on the exchange box, which is
-Confirmed platformurl setting on Exchange server is
-Confirmed that the machines can communicate with each
What...Excel Regional Date Format Options
A client of ours in NZ is complaining that date format options for English
(New Zealand) have changed from older versions of excel (they are using 2003)
Some of their spreadsheets have dates formatted as dd-mmm-yy, mmm-yy and
dddd,dd,mmm but these options do not exist anymore.
Is there anyway to add options to this list without using the custom format
I just compared the Excel 97 and Excel 2003 built-in date formats and they
are mostly unchanged. 2003 has a few more but I don't think there were any
subtractions. The formats dd-mmm-yy and mmm-yy are righ...MS Excel 2003 cannot auto calculate formula, need to press F9 each time
I don't know why my excel 2003 new worksheet cannot auto calulate
formula (eg. summation), i need to press F9 and it will refresh and
show the new figure. there is "calculate" word at the left hand bottom
of the screen.
what is the likely reason ? it was running fine 2 weeks ago.
any advise is greatly appreciated.
Tools>Options>Calculation tab, check Automatic
Microsoft MVP - Excel
<firstname.lastname@example.org> wrote in message news:email@example.com...
| I don't know w...Sending email from exchange server to Win2k server on same domain
This has been bugging me, I have a win2K box with smtp installed, I want to
allow users to send messages from exchange to the win2k server where they
will be processed by some scripts.
I have never tried this before and I am not sure of:
1. what is the address of the server (firstname.lastname@example.org?)
2. how should the exchange account/address be configured
Any advice gratefully received
Mark Davey wrote:
> This has been bugging me, I have a win2K box with smtp installed, I want
> allow users to send messages from exchange to the win2k server where they
> will be proc...Incoming Emails
We installed the CRM1.2 on the same server with
exchange. Everything is working fine except that the CRM
users can not see incoming emails inside CRM although
these emails are CRM emails.
Can anybody tell what is the reason of that?
Do you have installed the Router? The Router is a bridge=20
between the Exchange and the CRM who study the incoming=20
flow of emails and copy to the CRM everything who is of=20
I hope who that help you.=20
Vin=EDcius Pitta Lima de Ara=FAjo
> We installed the CRM1.2 o...No email stationery when through code
I am creating email via code from access using below;
Dim objOutlook As Outlook.Application
Dim objOutlookMsg As Outlook.MailItem
Set objOutlook = CreateObject("Outlook.Application")
Set objOutlookMsg = objOutlook.CreateItem(olMailItem)
objOutlookMsg.To = "email@example.com"
objOutlookMsg.Subject = "Email Subject"
objOutlookMsg.Body = "Dear abc..."
The problem is that the default signature that is set in outlook doe snot
come up in the email. How can I fix it?
Am Sun, 17 Sep 2006 21:11:45 +0100 schri...viewing LN emails (.nsf files) saved to CD in outlook?
I have lotus notes messages saved on CD, these are saved
as .nsf files. Is there any way I can view these in
have tried various LN websites - to no avail.
...Summary of Difference between dates in years, months, days
I need to calculate the difference between 2 dates and then total them.
Here's what I have so far:
From To Length of
01/09/2003 31/01/2010 6y 4m 30d
01/06/2000 30/11/2002 2y 5m 29d
Total of Service: ??????????
I've used the following formula to calculate the total days worked:
=DATEDIF(A4,B4,"Y")&"y "&DATEDIF(A4,B4,"ym")&"m "&DATEDIF(A4,B4,"md&...no content in the email body
Haven't changed anything knowingly, but now when I receive emails all the
in a .txt attachment which I open and goes to notepad.
There is no content in the email body.
"stephen" <firstname.lastname@example.org> wrote in message news:<#TKSQf$oDHA.email@example.com>...
> Haven't changed anything knowingly, but now when I receive emails all the
> content is
> in a .txt attachment which I open and goes to notepad.
> There is no content in the email body.
I've seen this before with an Outlook 2000 client. Couldn't find a way
to fix it,...Can you delete and empty an open email
Can you delete and empty an open email? I know I can delete and empty a
closed email by holding down shift and then deleting, but have not been able
to figure out how to delete and empty from an open email.
Is this even possible?
Thanks for your help.
On Wed, 18 May 2005 20:01:03 -1000, Kylie B""
> Hi there
> Can you delete and empty an open email? I know I can delete and empty a
> closed email by holding down shift and then deleting, but have not been
> to figure out how to delet...Moving Email Domain off of Exchange #2
I am in the process of moving one of our clients off of our Exchange
server and on to a third party email host. I have removed there domain
from the default recepient policy, and also disabled and unattached or
deleted their mailboxes. I have repointed there MX record to point to
the new host etc.
The problem is when I try to email them from our network my exchange
server still thinks it is responsible for handling the mail for the
domain and does not try to send it out of the domain. I get a 5.1.1
e-mail account does not exist in this organization.
How do I let Exchange ...Date/Time Displayed as 07/tt/jjjj
I'm new with MS CRM and just testing it. I have a prob with all date/time
fields like described in the subject of this post.
Timezone is set for all users
Problem occurs in all date/time fields in the web application
Anyone has a clue?
As Administrator, go to Home > Settings > there is an area in there (can't
remember what its called) that enable you to change default date/time format
"JanScheider" <JanScheider@discussions.microsoft.com> wrote in message
> I'...How do I add multiple times together
Hi does anyone know how I can add multiple times togther and get the anser in
hours and minutes. I have formatted the cell for time however when I atosum I
keep getting an answer that is incorrect. Any help?
Maybe it was just a formatting problem.
Try a custom format of:
Playhouse pm wrote:
> Hi does anyone know how I can add multiple times togther and get the anser in
> hours and minutes. I have formatted the cell for time however when I atosum I
> keep getting an answer that is incorrect. Any help?
...I m receiving my email but after received it is not in my inbox
When I open the outlook and click on send/receive, I receive all the emails,
but I could not find the downloaded email anywhere. It's not in my inbox or
any of the folders that I have created. The unread mail also does not change
to reflect that new emails have arrived. Could some one help me out here.
Thanking you in advance.
If you check your whole folder tree (composed of multiple PSTs possibly),
are any folders showing as bold?
"INAVAB" <INAVAB@discussions.microsoft.com> wrote in message
> When I open...Need Hyperlink from Menu Page to work in email
I have a workbook with several tabs. First tab is a "menu" type page
(summary of other pages). Currently I have hyperlinks to all the other pages
from the menu page. What I want to be able to do is copy the menu page into
an email and enable the users to click on the existing hyperlinks (whatever
adjustments needed) to go directly to their page of the workbook. Using
Excel 2007. Please advise how to do this and what changes may be need for
both options to work.
...Contacts vs Personal Address Book. Can't pull emails into TO fiel
I'm using Outlook 2k3 and having a slight problem. WHen I view my Contact
list in the main view, I have two sets (not sure why but I'll be combining
them). These lists have standard name, email, etc.
Problem is when I go to create a new email message and click the TO: button,
it tries to look for my Personal Address Book which I don't have. How can I
make it not use the PAB and use the Contacts list instead?
OK, I think I just stumbled on the issue. For some reason on my COntacts
Properties, the check box to tell Outlook to use that in the Address Book
...How do I convert time (hh:mm) to value ($$) in Excel?
Would like to calculate cost of time. Eg. Cost for production down time per
minute is $100. Says production doen for 3.5 hrs, what is formula shall I
apply in order to generate the cost (in $$).
> Would like to calculate cost of time. Eg. Cost for production down time per
> minute is $100. Says production doen for 3.5 hrs, what is formula shall I
> apply in order to generate the cost (in $$).
"ahfen79" <firstname.lastname@example.org> wrote in ...Receive triplicate emails
On earthlink webmail, I only receive one of each email.
When I "Send/Receive" from Outlook 2000, the Send/Receive
window tells me I'm receiving 10 emails, but 30 appear in
my inbox. Everything arrives in triplicate or duplicate.
Extended headers appear to be the same in all three
Things I've tried and know:
Deleted and then reconfigured my earthlink account many
times. There is only one earthlink account.
"Leave a copy of messages on server" is unchecked.
Turned Earhlink Spamblocker On then Off then On then
Off... no change.
Sent test m...Run-time error '380'
Back in 2003 I created a macro for a form that was working fine. I haven't
used it since but now that I need it, I get all these strange errors that I
am sure where not there back in 2003 (e.g. I had to in include VBA in the
txtBirth.Value = VBA.Format(spnBirth.Value, "d-mmm-yyyy")
Now my problem is with the code:
spnDOE.Value = Date
when I get a run-time error 380 that it could not set the value property.
Invalid property value.
...Authenticating addresses for sending emails
I installed Office XP for Small Business on my laptop
recently. Now, quite often I am getting an error message
when I try to send an email to someone that says, "You
must first authenticate this email address".
Does anyone know how this is done?
I have Office 2003 and I saw this once in my copy, I found it all I had to
do was to add the person to my address book as it was part of the built in
PDA Square Content Developer
"Ken" <email@example.com> wrote in message
news:01fc01c3d94f$...Email retention policy relative to CRM e-mails tracked from Outloo
Toss up question for the blue team.
When one hits "Track in CRM" on an e-mail from outlook we all know that it
CREATES an e-mail in the CRM system. The date that the e-mail is created in
CRM is placed in the field CreatonDate. When we look at the related record
it shows up in order based on the Created Date.
The rub is this. What do we do when we have a user who is just coming on
board with CRM and they have e-mail history they want to link that goes back
years. There does not seem to be any linking relative to the received date.
Which is actually much more relevant ...