warning mail then password Expired
Hi, I was thinking is there a way, that you can get a warning email 5
days before your user password on the domaine expires ??
"Driogan" <Peter@driogan.dk> wrote in message
> Hi, I was thinking is there a way, that you can get a warning email 5
> days before your user password on the domaine expires ??
There's already a warning that can be set when the User logs on.......
On 27 Nov., 11:41, "Gordon" <gbpli...@gmail.com.invalid> wrote:
> "Driogan" <Pe...@dr...Save formatted text from RichEdit control to rtf-file
How can I save the text from Rich edit control (2.0) to *.rtf , *.txt ,
I tried to get the buffer and putting the buffer to file, then saving
but the text in the file is something different.
Please let me know what to do?
Here is the Code I ma using:
mFile.Seek( 0, CFile::begin );
int iTotalTextLength = m_oChatMessageControl.GetWindowTextLength();
HWND focusWnd = ::GetFocus();
cBuffer2 = m_oChatMessageControl.GetSelText();
LPTSTR...Help with a formula..
I am trying to create a formula that will take information from a cell on one
sheet and combine it with text on another sheet. I know how to get the two
together. My problem is that I want the part that is brought in to be bolded
type. Here is what I have in the formula. ="we are pleased to submit our
quotation for "&(cell reference)&" according to the following
specifications." What I want to do is have the cell reference part be bold
type. Is there a way to do that? It doesnt work if I bold the cell.. already
tried it.. Any suggestions?
You'...Help needed urgently
Im trying to check that one row of data satifies a criteria, then if it does
it counts an entry in another column adjescent to it.
Column A - Column B
Blay - Y
Blay - N
Blay - Y
Chop - N
Chop - N
High - Y
What i would be asking (of a much bigger table) is If Column A = Blaydon and
then column B (same row) = Y, then count. In this example I would want 2
returned as the answer.
Is this possible?
Try one of these...
Use cells to hold the criteria:
D2 = Blaydon
E2 = Y
If you're using Excel 2007 or later:
=COUNTIFS(A2:A7,...Having problem of Outlook not receiving new e-mails
I have been using Outlook for over 1 year with Comcast
Broadband. Suddenly last week, I received a message that
Outlook 2000 was experiencing a problem when receiving new
e-mails and was going to shut down. I re-opened Outlook
and it looked different and then it asked for me set up a
profile and I canceled it. But after that window coming up
a couple of times after it shut down, I decided to put in
a new name and then I could not get to my old e-mails and
it acted like a new set up. Then I really got frustrated.
I was eventaully able to get back to my old e-mails and
have been able t...The Links from e-mails don't work
If I copy the links and insert it into IE 8 it reads it. Trying to link over
from an e-mail directly is not working. If I copy the link and go to IE 8.0
the link (URL address) works. It was working before.
You mean if you click on the link in a message it does nothing, not even an error message?
Are you certain IE has all its defaults?
Open the Default Programs applet, which you can access either from
the Start menu or via the Control Panel, then click the first item:
"Set your default programs."
After a few seconds, a list of programs comes up. Click on...how to config Server for one user which has 2 mail address.
we have one NT4.0 + Exchange 5.5 Server "A" Email email@example.com ��and
windows2003 + exchange 2003 Server "B" firstname.lastname@example.org user name is same in A
B��Mx record was be set ,question is how to config Exchange 2003 to receive
down the mail to Server A , because of we need to replace A with B.
thanks a lot.
E2K3 setup guides you through common scenarios (like yours) pretty much holding
your hand - on welcome screen tell it that you have existing E55 org and want to
join it, then follow on-screen instructions. Having usable backup of Exchange
databases and AD i...help with dynamic tables
This is a bit complicated to explain but I'll try my best. In columns A, B,
C I have different drop down lists. Column A has Store1, Store2, Store3,
etc. Column B has Dept1, Dept2, Dep3, etc. Column C has ProductA, ProductB,
ProductC. As of right now, these lists are not dependent on each other, I
can choose anything from any list regardless of the previous category. Also,
the length of these lists is undefined, meaning I will constantly be adding
to them in sequential rows below. And then columns D and beyond have data
such as Sales, Profits, # of items, etc.
What I...Cell Format #4
Is there a way to have a cell format based on contents of an i
if(C1="Input",and(C3,Format $#.##),if(C1="% of Revenue",and(C5,Forma
I want the If statement to test a condition, return contents of th
correct cell and format automatically.
Any help is appreciated
bforster1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1177
View this thread: http://www.excelforum.com/showthread.php?threadid=26133
You can't change the fo...How do I setup an SMTP gateway / smart host for Exchange 5.5 internet bound mail
My current setup has a Windows NT 4.0 Exchange 5.5 server setting on our
company LAN behind a Microsoft ISA Server. The Exchange server's Internet
Mail Connector binds to (I assume this is the proper terms) port 25 on the
ISA server for inbound and outbound Internet Mail.
Our company has finally upgraded to a new Cisco Pix Firewall which we are
able to setup a DMZ on. The suggestion by our ISP is to setup an SMTP
gateway in the DMZ and have our internal Exchange server send mail to it
destined for the Internet.
I am aware that most of the work for making the connections from the SMTP
How can i have codes in this form 00.00.0000.00, & i wanted to sum to the values below like next code, 00.00.0000(+1).00 I'm tired to format but always sum in the last 2 digits 00.00.0000.00(+1), what can i do
Someone can help me
How did you put 00.00.0000.00 in the cell?
Did you type 0 and then give it a custom format?
If yes, try changing your custom format to:
Then add 1, but make sure that the resulting cell also has this custom format.
This is really a funny formatted number with 2 decimal places now.
> How can i ...Mail Merge Printing collated
When I print a mail merge (I don't use it for mailings and envelopes),
Publisher prints out the first 5 records as an individual document then the
next 5 as a seperate document, and so forth. Since I often need to make
multiple copies of these documents, I end up having to collate them by hand.
How can I get Publisher to print the entire merge as one document before
printing the second, third, copy? I believe when I had P'03 it would print
that way, but when I upgraded to '07 this problem started.
You can't... Maybe later with a service pack these printing bugs will b...Help! Problem Referencing Excel 2003 in VB.NET
I am using Visual Studio 2008 Express Edition to develop some VB.NET
code that manipulates Excel files. I am developing on a Vista/Excel
2007 machine, but I need the code to work on an XP/2003 machine as
I initially set a reference to the Microsoft Excel 12.0 Object Library
and imported the Microsoft.Office.Interop.Excel namespace. This works
great on the VIsta/Excel 2007 machine, but it does not work on 2003,
which needs the 11.0 library. I get an error that says "Unhandled
Exception . . . Could not file or assembly
'Microsoft.Office.Interop.Excel, Version 12.0.0....Video mail VEMAIL.EXE
Just installed VEMAIL.EXE
v1.1 and get the message "The fatal error occured"
Any tip on how to get this plug in working ?
Give up on it - the add-in doesn't work.
>Just installed VEMAIL.EXE
> v1.1 and get the message "The fatal error occured"
>Any tip on how to get this plug in working ?
...conditional formatting in excel #3
how do you add a phrase to a field if the filed is blankl, also, can you have
a notifiction sent to you when a date on a spreadsheet has expired?
> how do you add a phrase to a field if the filed is blankl,
What "phrase" do you mean? A Comment? A value?
also, can you have
> a notifiction sent to you when a date on a spreadsheet has expired?
Maybe you can apply an open event (date to be tested being say in F1):
Private Sub Workbook_Open()
If Range("F1") < Date Then
MsgBox "Date expired"
...Need Help with drop down list with conditions...
I need help.
I'm having a very difficult time creating a sequence of list which change based on the item selected on the main list, lets call it the index:
The Index list, the first list, would define vendors. In this case Hotel Companies (e.g Hilton, Marriott, Sheraton).
The following list, the 2nd list, would define properties, but the properties would vary based on which hotel company is selected (e.g. If Hilton, then "The Plaza, the Waldorf Astoria. If Marriott, then Marriott Marquis, Marriott Convention Center etc etc...) on list #1.
And Last but not least, the 3rd list would...make outlook automatically delete html mail with linked images
The junk mail filter should be able to automatically delete html mail with
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/community/en-us/default.mspx?mid=9e1b783b-c9c1-44f2-a1dd-93da59216c56&dg=microsoft.public.outloo...Formatting Linked Cells
I have a project to do. I have to create an input worksheet that is the originator of other worksheets that are linked to the input worksheet. Is there a way to have the linked cells shown as a blank cell if the data (especially text data) is not enter in the input worksheet yet.
(Don't use my reply address - it's spam-trap)
"MT" <MT@discussions.microsoft.com> wrote in message
> I have a project to do. I have to create an input ...Macro Help #18
Well I think this is a macro. I have searched my excel book and i can not
seem to figure out what to do.
I want to write something that if this statement is true, then the font
color changes. But here is the potential problem. THe location of the text
will change. So i need it to search for this text and then change the color.
Does that make sense? Is this possible? If this can be done it will really
help me. Thanks in advance.
This is exactly what i am trying to do.
You type in a persons name into cell a1. you also type a name into cell a2.
These names will transfer over ...Retrieve old e-mails
I recently had a hard drive crash on me and had to have
the data recovered through a data recovery specialist.
All the data on my old drive was recovered and put onto
my new hard drive. I did have to install WindowsXP on the
new drive. I want to know how to get the e-mails I had in
my inbox folder from the files from the old drive so I
can respond to them as there were some which had not been
read and others which were of importance.
Thanks for the help,
Brian <email@example.com> wrote:
> I recently had a hard drive crash on me and had to have
> the...Curious Mail Loop (and brain teaser)
I just experienced an enigmatic mail looping issue, anybody have any ideas
to keep this from happening again?
Here is the Scenario...
We have a user whom works for my organization and another government agency,
both organizations use Exchange 2000 but there is no interoperability
between our systems other than standard SMTP email through the internet, not
same AD root, forest or even remotely similar namespace. We are able to
induce a loop under the following conditions.:
1. User has an exchange mailbox at both Organization A & Organization B
2. User creates an "Out of the Off...Conitional Formatting
I have two fields in a subform, "User" and "IT Announcement"
I would like to do conditional formatting to this effect:
On ther "User" field:
If "IT Announcement" = Yes then make the "User" field turn blue (I would
choose the color blue from the conditional formatting selection.
How would you write this?
On Tue, 23 Oct 2007 14:59:01 -0700, Iram wrote:
> I have two fields in a subform, "User" and "IT Announcement"
> I would like to do conditional formatting to this effect:
> On...Excel number formatting #2
I receive spreadsheets with separate columns of numbers
and text. The problem is that the numbers column is not in
number or general format (when sorting behaves like text).
Is there a way to turn those columns into numbers (except
stepping into each one separately)? When I just highlight
the number in the cell and hit enter, the cell
automatically becomes numeric (I'm looking for a more
You can do this:
1. Type 1 (the number 1) into a blank cell. Highlight this, select Edit,
Copy. Now highlight entire column(s) that you want changed to numeric, and
sel...Newbie needs help with new Exchange 2003 installation
I am TOTALLY new to Exchange. We just installed Exchange Server 2003
on a Windows 2003 domain.
I have one (test) account set up and it appears to work OK but I keep
getting an error message that says "Task "Microsoft Exchange Server"
reported error (0x8004010F): 'The operation failed. An object could
not be found.'
I know, I know...How could I possibly not understand THIS message?
I appear to be getting mail but I' can't be sure. How can I check to
see what's causing this (and more important...what object it's looking
Thanks for any help!
...Unable to send E-Mails #3
I have recently installed broadband and when I attempt to send an E-Mail I
get the following message.
554 <E-Mail Adress>: Recipient address rejected: Relay access denied
Any help would be gratefully appreciated
On Mon, 20 Dec 2004 13:27:03 -0800, LarryM wrote:
> I have recently installed broadband and when I attempt to send an E-Mail I
> get the following message.
> 554 <E-Mail Adress>: Recipient address rejected: Relay access denied
> Any help would be gratefully appreciated
You probably need to authenticate to your outgoing server. Set that up on