Gantt Chart in Excel. Do I need conditional formatting?
I have created a Gantt chart that shows approx. 15 tasks in each project. I
am using this to show percentage of completion for each task.
It is working just fine and looks great but I need it to insert a date when
a task is at 100% completion to show the client the date that particular task
was completed. How would I do this without ruining my chart I already have
working fine? I know this is probably easy to do but I cannot seem to keep
the rest of the chart intact. Is conditional formatting the answer?
You could use Rob Bovey's XY Chart Labeler to do this:
h...Can only send email to myself using POP3
I have a problem sending out email using my POP3 account.
I used the configuracion check of outlook and everything
is working. The problem is that if I send an email to a
different address then my own I get the following error
Algunos de los destinatarios no recibieron su mensaje.
Enviado el: 26/04/2004 15:37
No se puede localizar a los destinatarios siguientes:
en 26/04/2004 15:37
530 delivery not allowed to non-local recipient,
Anyone knows a solution?
You need to set up your outbound mail serv...How do I set the worksheet to save before closing?
When there is a change in a worksheet and I try to close it, a message asks
me whether I want to save the worksheet or not? How do I turn on this
notification before closing the sheet?
Open your workbook. Hit Alt+F11 or Tools-->Macro-->Visual basic editor
(VBE). On the left, double-click ThisWorkbook. Paste the following code into
the ThisWorkbook code window. Hit the Save diskette at top-left. Close the
VBE. Make a change to the workbook, and close it to test. Was the change
saved? Should be. :)
Private Sub Workbook_BeforeClose(Cancel As Boolean)
ActiveWorkbook.Save...Outlook email password always requested
I use MS Outlook 2002 SP3 in Vista. The email password is asked for every
time. Is there a fix for this?
A known issue - see http://www.outlook-tips.net/howto/vista.htm
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
After furious head scratching, James Truelove asked:
| I use MS Outlook 2002 SP3 in Vista. The email password is asked for
| every time. Is there a fix for this?
"Milly Staples [MVP - Outlook]" <What@ever> wr...2-D charting with multiple rows
I have a power user who wishes to increase the size of his 2-D graphics but
is limited to using 32000 records. He needs to be able to use 64,000 records.
Any suggestions? I think this might be something that is changed in regedit
but I am not sure. Thanks!
Yep, and you can bypass the 256 column limit with Windows API calls.
Joking aside, how about two series, formatted identically. If you have duplicate
entries in the legend, select the legend, then select the text of one entry, and
press the Delete key.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorial...Missing Text in emails replied to via Lotus Notes
I use Outlook 2003 to create emails. Using either plain
text or html format, when I send the email to a colleague
who uses Lotus Notes, and they hit reply to the email type
their response. I do not receive or read any of their text
in the incoming mail in Outlook. If I use an alternative
Email client such as Pegasus, I can read their text. What
can I do to fix this, how can I get the missing text back
from within Outlook, without getting them to re-create a
new email with their response?
I think that I have solved this.
I think that when the option to remove blank lines is
Ou...Opening forms and setting captions.
I am opening the same form but in different states i.e Read Only, Edit and
Add New. using Event Procedure from three different command buttons. Is it
possible to change the caption of the form being opened to remind the user
which state the form was opened in? If so can someone please point me in
the right direction of how this is achieved?
Regards to all
Mike Green wrote:
> Hi All
> I am opening the same form but in different states i.e Read Only,
> Edit and Add New. using Event Procedure from three different command
> buttons. Is it possible to change t...BUG in O2K3
I posted this yesterday, with no response, and am posting again today as
this is clearly a bug in Office 2003. Office 2003 is not properly integrated
(well not at all!) with the IE setting "Reuse windows for launching
shortcuts" (Internet Options - Advanced). This causes severe readability
issues for users who need to make many url clicks from within Outlook, and
don't want multiple instances of the IE window opening.
See this for someone else's report of the same issue:
8a7bde&..."a document with the name" error on opening file
I'm getting an error message that says "A documents with the name " &
filename & " is already open" (where filename is the actual name of the
file) when I try to open certain files in Excel 97, when I don't really have
a copy of the file in question opens. This error comes up pretty
consistantly on one file that lives on a server, but I also get it when I
try to open some local files. Anyone have any idea what would cause this &
how to fix it? Thanks in advance.
have a look at: http://www.contextures.com/xlfaqApp.html#AlreadyOpen
I have a problem with receiving email from a certain domain, I can receive
email from one user at that domain but not from any other user, there ISP is
telling them that it is on our side that it is being blocked, we have
nortons doing filtering but the emails are not even gettting to the filters,
we can receive email from everybody else with no problem, we have exchnge
2000, could this be a DNS issue or is it coming from there ISP that is
hosting there email, we can receive email from other domains that there ISP
is hosting with no problem.
...Help on displaying recession periods in a financial/ stock chart
Using excel version (10.6501.6626)sp3
How do you shade the chart background to show economic recession periods in a financial/ stock chart. I've fiddled with the drawing function-rectangle box, transparency, etc- but it isn't very satisfactory since it corrupts the column/ line colors and usually washes out when printed. So that doesn't appear to be the solution. And after checking thru Microsoft help and the discussion group messages I haven't found a message addressing my problem. Since we see charts all the time with the recession periods shown I know there is a way to acco...Where have my emails gone?
we are in the process of merging with a new parent company and
currently have two mail boxes setup in Outlook. I copied some mails from
one mail box to the other and they have left the original mailbox but do not
appear in the new one. However, I can find the messages by using a Search
Folder. Apparently, the messages are in a folder called IPM_SUBTREE. What
...CRM Email 12-29-03
I have successfully installed the email router, and i was
able to send emails from crm and successfully receive them
(both to company domain and outside clients).
I have noticed though:
1. when i send email activity to CRM users
(CRMEmailEnabled attribute assigned), they do not receive
this in their queue - actually the application should
generate another activity appending CRMxxxx to the subject
line which doesn't happen in this case
2. Internal mails (company domain)
We can not send emails to CRM. I have followed the steps
in the guide, created a queue...everything and i am still...Not getting all my emails
computer with XP and OE crashed. Have W7 now... downloaded windows live...
can send and recieve but not getting all of my emails... (have other accounts
set up with same email address.. am getting emails there but not all in W7).
Have a Pop3 account. Never any problems with OE... don't understand why I
recieve some emails and not others... some emails I send and people reply to
I am not getting either. Any help would be appreciated.
Are these actual different accounts, or different e-mail addresses that
are aliases for the same Inbox? How are they set up? (i.e. rules moving t...domain added then removed from exchange but emails still route to exchange ?
Was wondering if someone can explain this:
added external domainA to accepted domains
added domainA mail address to users mailbox
(mx was not changed)
sent email from mailbox/account/domainB (hosted on exchange server) to
domainA , arrived in users mailbox on exchange as expected
removed domainA from accepted domains
removed domainA email address from users mailbox
to domainA , arrived in users mailbox on exchange as expected, arrived in
users mailbox, this was not expected.
When using Outlook (domainB exchange accounts) and entering the email
address user@domainA.co...My Account Settings, Icons, Files are "Missing"
Recently, I booted up and discovered that my personalized icons (under
my account) had disappeared from the desktop. The Account Name is
"Gilxxx" but my data is under "Curxxx"
When I looked closer, I was able to see the directory structure in my
"Documents and Settings" folders, but none of the files.
The files are there, however, as I can play MP3s in Windows Media
Player (and they are in my My Music directory). And, when I tried to add
new desktop icons to "re-create" my old desktop, Windows tells me that a
shortcut with that name alread...Open a Publisher document without having Publisher
Is it possible? Can I convert the publisher doc to something else to then be
able to open it?
Can't even be done with a crowbar. You need Publisher, version of the same
or later version as the pub file.
"edd1121" <firstname.lastname@example.org> wrote in message
> Is it possible? Can I convert the publisher doc to something else to then
> able to open it?
What about a BMF hammer? ;-)
MVP Microsoft [Publisher]
"Don Schmidt" <R...Set of Dialogs -Delete Any Dialog at Runtime-Organize Pos
I Have set of Dialogs created a Runtime and those are placed sequentially
in a postion by using SetWindowPos and now i want to delete a Dialog using
close button associated with that Dialog which is placed at a Position the
Dialog Order shoulnd rearrange automatically and is there any way to do that
Thanks and Regards
Uusually if you have a set of dialogs there is an application window of some sort
associated with the application. What I would do is have the dialog's close handler post a
message indicating the dialog had closed, then...Cant see mail properties on users
Just got EX2007 installed. When I create a new mailbox for an existing user I
do not see the the exchange tabs when I open the users properties. Did I do
On Fri, 2 Feb 2007 12:52:01 -0800, D303M
>Just got EX2007 installed. When I create a new mailbox for an existing user I
>do not see the the exchange tabs when I open the users properties. Did I do
You mean in ADUC? Use the EMC to view that info instead.
...List servers and their DNS server settings
I am trying to get a list of server names and their primary and secondary
DNS server settings.
If I try the following command:
get-wmiobject Win32_networkadapterconfiguration -computername "servername |
select name, DNSServerSearchOrder
It would give me the specific servername and its dns addresses.
I know have a list of computernames which I would like to list out and their
DNSserversearchorder settings (DNS settings)
I tried putting the list of computernames in a text file by using
get-qadcomputer | export-csv C:\computername.txt -notype
Then I used the get-con...using Outlook on local machine with domain user account
I have a small network running with w2k domain.
Client computers run under w2k pro and have Office 2000 installed.
* When I log on locally (with administrative privileges) Outlook works fine.
* When I log on to the domain (using any domain user account) Outlook does
* When I add a domain user account to local administrators group and log on
to the domain Outlook works fine.
How to make Outlook working when domain user account is used (without
administrative privileges on local machine) or I must use an account that has
administrative privileges on local machine to run Outlook?
...Excel Worksheet menu bars customizing for limiting users to optio.
Customizing Excel worksheet menu bar for limiting users to the options
provided in that menu
Look also at the links to MS pages on the bottom of this page
Regards Ron de Bruin
"jim" <email@example.com> wrote in message news:F8009001-5F5A-4415-9527-34C71D8DF1DB@microsoft.com...
> Customizing Excel worksheet menu bar for limiting users to the options
> provided in that menu
...Multiple Exchange Servers and Email Router
When installing CRM 4 Email Router in an environment with 2 Exchange servers,
where do I need to install the Email Router?
it is not requirement in CRM 4.0 to install the exchange router on
exchange. All you need to do is to choose the exchange server name
while configuring the router .
I myself had installed the router on CRM server.
...Add "." to user's entry if they didn't
I have a Remarks section in my form for the user to type any additional info
pertinent to the file they are entering but it seems that about half of the
time, they don't punctuate it with a final period. Is there a way that I can
code it so that IF they didn't add that final "." that the system will? All
of the data is later concatenated together which is why it matters.
Thanks so much for any help!
If Len(Me!txtRemarks & vbNullString) > 0 Then
If Right(Me!txtRemarks, 1) <> "." Then
Me!txtRemarks = Me!txtRemarks & &q...Email deletion over X amount of time for subfolders
I'm trying to configure the mailbox manager so it cleans out everyone's
mailbox once a week for emails that are over a year old. I had no problem
with cleaning out the Inbox, but none of the emails in the subfolders are
deleted. I selected 'All Other Mail Folders' option, but that didn't work.
Anyone know how to go about doing this or having this same problem?