It seems that every other question on this NG is about rules but, I
haven't seen one about this.
Is there anyway to setup a rule with a script or something where,
when I get a message from a designated address, Outlook will generate
a new message and send it to a 2nd address. Having the message simply
forwarded isn't an option.
Basically what I'm trying to do is this : When I receive an order
from a client, I need Outlook to send a text message to my cell phone.
Just forwarding the original message doesn't work since it's too large
and it's rejected by T-Mobile...Convert Column Letters to Number
I'm looking for a function to convert a "large" column letters (up t
10 characters) to it's equivalent in number.
Message posted from http://www.ExcelForum.com
Here's a VBA function that gives the results you want:
Function ColumnToNumber(sText As String) As Variant
Dim Bytes() As Byte
Dim Letter As Long
Dim Multiplier As Double
Dim N As Double
Dim Total As Double
ColumnToNumber = CVErr(xlErrValue)
If L...How do I reduce the number of lines in a spreadsheet?
Simple question - how do I reduce the number of lines in an Excel spreadsheet
from say 25000 to say 45? Delete doesn't work.
You can't delete rows in excel but you can Hide them
Check out this first before you do that
Regards Ron de Bruin
"Philamon" <Philamon@discussions.microsoft.com> wrote in message news:02199B4E-70D6-4042-9B01-56E21FA92B00@microsoft.com...
> Simple question - how do I reduce the number of lines in an Excel spreadsheet
> from say 25000 to say 45? D...Message tracking doesn=?ISO-8859-1?B?uQ==?=t work
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
I�m running Exchange 2003 service pack1.
I�m unsure what�s going on but it appears the message history in the message
tracking tool in ESM is messed up.
If I attempt to look at the history of a message that was sent to an
external user It will come back and complain :
�The object �Tue,� in the message tracking logs cant be found i...Need Help with #N/A in equation
I have a set equation that needs to be run on about a thousand different
entries. A simplified version of the equation would be =A+B+C-D. The
only problem is, "B" is only found in some of the entries. So for the
majority of the times the equation is run for the different entries, it
works, but when "B" is nonexistent, the equation returns a #N/A value.
Is there anyway I can keep the set equation but make it work when B
does not exist?
mkerstei's Profile: http://www.excelforum.com...I need a template that could help me create a legal gaurdian doc.
I need to create a legal gaurdian document. Can't find one on Micrsoft
> I need to create a legal gaurdian document. Can't find one on Micrsoft
Contact a lawyer if you really care about it not being broken.
> I need to create a legal gaurdian document. Can't find one on Micrsoft
...Is 'system attendant' needed for OWA 2000 ?
I am following info below to secure my OWA server. System attendant is not
listed. Do I need System Attendant 'running' on OWA 2000 ?
Since the role of this server is to only support Web-based e-mail, many of
the Exchange services installed by the default configuration can be
disabled. The table shows the services that are configured in the OWA
Front-end Server Policy.
Table 3.5 Services configured in the OWA Front-end Server Policy
Service Name Startup Mode Reason
Microsoft Exchange IMAP4 Disabled OWA server not configured for IMAP4
Microsoft Exchange Informat...MFC Message Handling
In MFC Generally when we Override Message Handling function by a class
then we call base class function at the end like,
how this is valid??
If PreTranslateMessage() is not static function then how can we call
it by this way (i.e. ClassName::FunctionName)??
"rahul" <firstname.lastname@example.org> ha scritto nel messaggio
> In MFC Generally when we Override Message Handling function by a class
> then we call base class function at the end like,...exchange send message warming to a new mail recieved (exchange 200
it´s any possibility sending a message to a host to advise that it has a new
mail without owa or outlook opens.
How the user will know it got a message without OWA or Outlook open?
What is wrong with having Outlook running?
> it´s any possibility sending a message to a host to advise that it has a new
> mail without owa or outlook opens.
Yes, you could walk over to them and ask them to start OWA or Outlook ;)
"bartimore" <email@example.com> wrote in message
news:4D6CF1FB-F105-4524-8CD9-5FE5A8E659AB@microsoft.com.....sequential numbering of labels
I made labels that I want to use for Raffle tickets. They are two piece
tickets one horizontal and one vertical. I am trying to number each piece
(2) of them from 1-500. Is there a way to do this?
Thank You for your help
Consecutive Numbering (2002, 2003)
Mary Sauer MSFT MVP
"jodar" <firstname.lastname@example.org> wrote in message
>I made labels that I want to use for Raff...message window with an Office file attachment sticks on top of the Outlook window
When I send an Office file from the Office program file menu as an
attachment the Outlook 2002 SP3 window could not be put on top of the
appearing message window. This does not allow coping an e-mail address from
previously sent messages to the appearing message window. How to copy an
e-mail address from previously sent messages to the message window with the
Office file attachment, which sticks on top of the Outlook window?
Either save the message and then reopen it from Drafts. Or, create the
message first, then attach the document.
Sue Mosher, Outlook MVP
...Determine the number of bits in a negative number
I'd like to determine the number of bits (the position
of the highest on bit) in a negative number (say -1)
without using knowledge of its type.
Valid operations would be AND, OR, XOR, negation,
and one's compliment can be done as:
'Get a -1 of the same type as myvar
Dim minus1: minus1 = myvar - (myvar + 1)
Dim onesComp: onesComp = myvar XOR minus1
You could also use multiplication or division by 2
or other mathematical operators/functions, but
then sign extension comes into play.
The standard solution is to presume the answer
given the type of the variable, but...Not allow entering repeated references in a column
I have a table to register incoming documents. Its references ar
introduced in a column.
Each document must have a unique reference (e.g H04, H05, B01, B02
Hence, repeated references must not occur.
What should I do to make sure that repeated references are no
introduced in the column... or alternatively, what should I do to mak
the system alert the user when he/she is introducing an existen
I look forward to receiving your help.
Thanks in advance,
ritinha's Profile: http://www....How can I search for messages of an author, when I don't see one a
The help file states that I can search for "recent message posted by this
author" from within a message, but I don't see how to do it without finding a
message for the author to begin with. Doesn't make sense to me.
Peice, Love,... Many Groovies
Not an Excel question, you are using CDO, don't know what
you do there. But I expect you would have much better results
using Google Advanced Groups Search. And because most
questions have already been asked would certainly want to
encourage the use of Google Advanced Groups Search to
http:...Need help with cells
I need help. I want to be able to type in a numberin cell A1 and the
description to appear on cell B1. Just by typing the number.
Look in the Excel help for the Vlookup command. You will need to have a
table of the numbers with their descriptions saved somewhere.
"mariflor" <email@example.com> wrote in message
>I need help. I want to be able to type in a numberin cell A1 and the
> description to appear on cell B1. Just by typing the number.
> thank you
I can't seem to ge...MAXIMUM NUMBERS IN CELL
When entering more than 15 numbers in a cell, Exel automatically changes the
integers after 15 to a zero.
Example: 123456789123456789 entered into cell returns
Is there any way around this?
Excel supports only 15 digits, but if you don't want to do any calculations
on these numbers, then you can enter them as strings. A preceding ' will
convert numbers to string. e.g.
is treated as a text string.
Message posted via http://www.officekb.com
...How can I number these pages?
I have a workbook with 30 sheets. Some sheet contains more pages t
print. I have already made the setting print and the setting scale i
not the same for all sheets. I would like to
number (progressive number) and print all pages.
Ex WS1 Page1, WS1 Page2, WS2 Page3...
Someone can hepl me
Message posted from http://www.ExcelForum.com
In File - Page Setup, the First Page Number should be set to Auto for all
sheets. The pages wil now be sequential across all the sheets if all are
printed in one command.
mvpearl omitthisword at verizon period net
----------------...Contacts in Public Folder do not appear when composing a message
Hello, I have installed Exchange 2003 and all the clients have Outlook
2003.I created a folder in "Public Folders" for the contacts. I
specified that the folder contains "Contact Items". The same process
was followed also for the subfolders and the contacts were copied in
Everybody can see the contacts in "Public folders", but when someone
creates a new message and click "To:" cannot view those contacts.
At the moment they are able only to see the "Global Address List" which
contains the mails of the users in the company. All t...Need Help #2
I Am new to dynamic Gp... i need to know how i can generate a cash
report weekly, and how i can see where my revenue is recorded by
monthly.... i mean cash on hand monthly... if any1 help me out i
shall be very much thankful....
...Outlook 2000 will not display new messages
Outlook can sit open all day and no emails will display
until one that is already there is opened, then the emails
flood in. I have several customers experiencing this.
>Outlook can sit open all day and no emails will display
>until one that is already there is opened, then the
>flood in. I have several customers experiencing this.
I have 3 users who are experiencing the same exact problem
in my office - anyone over at MS have some suggestions?
We saw this too. We ran Spybot to ...do i need an internal MX record?
when i was using exchange 2000 i did not have an MX record in my internal
DNS... i dont know if thats clear.... lets say my domain is microsoft.com.
publically, there would be an MX record that pointed to the public address
of the email server. but internally, where all machines have private 192
addresses, do i need to configure an MX record? i never have before, and
things have always worked fine. now, with exchange 2003 the internet mail
wizard says that i have to have an MX record before i can send internet mail
etc. is the wizard telling me to create an internal MX record with a 192
addres...Error messages received when opening converted mdbs
I converted an accounting program (that allows me to individually access the
mdbs for each company) from Access 97 to Access 2003. However, I now have
the following problems:
1. I get warning messages about unsafe expressions and an unsafe file when
I open the mdb that contains all the program code.
2. I get a run-time error #2803 each time I exit a form in one of the
attached mdbs. The error states that I don't have the license required to
use this Active X control, but the exit routine was written by the programmer.
3. Attaching to each mdb is much slower than it was with Acces...need some suggest
I need to display a messege in screen,so I used MsgBox("hello:", 0,
does it wright
Use AfxMessageBox. Sample usage is at the bottom of the page:
Ajay Kalra [MVP - VC++]
<firstname.lastname@example.org> wrote in message
> I need to display a messege in screen,so I used MsgBox("hello:", 0,
> "virus", "");
> does it wright
> ...Store email acount messages into different Data files
I've set up 2 email accounts in Outlook: one is an
Exchange Server account and the other is a POP3 account.
I have also created 2 Outlook Data Files. Now, I want to
store email messages for each email account in its own
Data File. But this seems to be impossible because
Outlook requires all accounts' messages to be stored in
the same Data File.
Am I missing something here ? Any help is greatly
SuperKinhLuan <email@example.com> wrote:
> I've set up 2 email accounts in Outlook: one is an
> Exchange Server accoun...MROUND on a negative number.
I came up with the following formula all by myself !!
Which will successfully (If $I$2 = "TRANSFERRED") round a decimal number to
the nearest quarter.
If however, the decimal number is negative, I get the NUM error. Please can
you help me get it to return a negative rounded number.
K21 = 17.00 K22 = 0 K23 = 0 K24 = 1.28 Therefore correct at 15.75
K21 = 0 K22 = 0 K23 = 0.6 K24 = 0 I would like the result to be -0.5.
Your help is and always has been very much appreciat...