Creating a group of cells. Need Help Please.
Havn't used excel in a while and I need to create a group of cell
corresponding to an input of a min and a max.
Here are the details. On one sheet I have a box where you enter th
min and a box where you enter the max. In another sheet I want
column starting at A2 to output (MIN,A2+1000,A3+1000,....MAX) ho
would I do this
Thundersixx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3055
View this thread: http://www.excelforum.com/showthread.php?threadid=50207
Name the...Two mailboxes for one user account after mailbox moved to a new server
After moving a user's mailbox from a Exchange 2003 to a new Exchange
2003 server, Outlook has listed two mailboxes with same name in the
"All Mail Folders"area. The Outlook profile only has the user mailbox
and no other mailboxes added to it. The user can send and recieve email
just fine. The mailboxes seem to be clones of each other. New mail show
up in the mailboxes at the sametime.
How can I get Outlook to only show one mailbox?
Any help would be appreciated,
...Can't Send Messages Until I Press F9 Key
This is a multi-part message in MIME format.
Content-Type: text/plain; charset=us-ascii; format=flowed
After I compose a message and click Send, the message does go its way
until I press F9 or choose Tools|Send/Receive. I'm using Outlook 2003 on
Windows XP. In case it matters, there's a toolbar for ZoneAlrm Outlook
Addin with Junk filters (I use the Zone lite firewall freebie). Is there
a setting in Outlook I need to set to automatically send messages?
Should I disable the Zone addin? If so, how?
---...error sending from 5.5 to 2000
When a user sends from an exchange 5.5 mailbox to a user in exchange 2000,
they receive the following error:
The message was undeliverable because the recipient specified in the
recipient postal address was not known at this address
The MTS-ID of the original message is: c=US;a=
The same user on the 5.5 server can send to other users on the 2000 server.
I looked the error up in technet and got 3 kb articles with only 1, kb295377
being anything close to my problem. I checked the entr...Get at messages in queue
Is it possible to get at the undeliverable messages that are held in a queue
(eg to check the message body or redirect undeliverable messages). I would
like to be able to selectively forward them to an alternate email address or
to archive them to a PST etc rather than just deleting them?
...How do I send a welcome message to a new created mailbox automatically?
My exchnage send a message automatically but I need to change the message
where do I change it?
On Tue, 21 Jun 2005 16:35:53 -0700, "Ron" <firstname.lastname@example.org> wrote:
>My exchnage send a message automatically but I need to change the message
>where do I change it?
Exchange doesnt do that unless you have something scripted.
If you are referring to the welcome message in Outlook, its called
welcome.msg , but I dont think its been used since Outlook 2002.
So where would I plug in the script? Also I searched for welcome.ms...Creating a template using Publisher
I need help creating a neighborhood directory template using Publisher and
merging an Excel spreadsheet into it. It keeps printing multiple pages of the
first page after I merge.
What version Publisher?
If you have 2003 use the catalog merge for your directory.
Otherwise you need to setup your page as though it is labels. Determine the size
of the area you need for each entry, select labels in page setup, type the size
you determined in the page setup. Adjust the gaps and margins when you are ready
to print (2000 and bel...How many Server-side rules can you put on one mailbox?
I am using Exchange Server 2003 and want to setup 52 rules on one of the
mailboxes, is this possible?
the hardcoded limit on space for rules is 32K...i doubt you'll be able to
get 52 rules on one mailbox...
Susan Conkey [MVP]
"jmareel" <email@example.com> wrote in message
> I am using Exchange Server 2003 and want to setup 52 rules on one of the
> mailboxes, is this possible?
MVP - Exchange
www.zenpris...Mailbox Restore #6
Im about to restore a SBS 2003 server with exchange (2003) after a system
I don't want to restore over my new installed machine, so what's the easiest
Im only interested in the mailboxes and public folders content.
Software for extracting directly fom edb files are to expensive, or is there
any cheap one? :-)
On Sun, 5 Mar 2006 18:36:24 +0100, "Jonas Nilsson"
>Im about to restore a SBS 2003 server with exchange (2003) after a system
>I don't want to restore over my ...How to look at raw message
In outlook express you can view at the entire raw message
but how do you do the same thing with the Outlooks that
come in office, i.e., Outlook 2000, 2002, 2003 etc.?
I hate it when you have to downgrade ti get the same
Rightclick in the (HTML) message and choose View Source.
Note that OE is not a downgrade of Outlook but a completely different
product developed by the Internet Explorer team instead of the Office team
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Serv...Sending a workbook as a mail attachment
Is there an easy way to send a workbook via email based on the date an
time? Our company uses excel for some of our reporting and rather then
having the reps remember to send the workbook i'd like to have it send
itself automatically - say on Saturdays or Sundays.
Nel post news:firstname.lastname@example.org
*Gord* ha scritto:
> Hey Folks,
> Is there an easy way to send a workbook via email based on the date an
> time? Our company uses excel for some of our reporting and rather
> then having the reps remember to send the wor...Send from Word
When I hit the send button in Word or Excell I get a pop
up that say choose profile with Outlook in the drop down.
That is the only name in the drop down. If I hit OK I get
the following Message.
The MAPI Spooler could not be started. Close and then
restartall mail-enabled applications.MAPI 103 (0000004C7)
If I choose to set up a new profile I get a Microsoft
Exchange Setup Wizard. As I try to setup a new profile I
come to the following,
The following unrecoverable error has occured:
The .DLL file for this service is either damaged or could
not be found.
What versi...how to turn off automatic format in Excel?
Excel automatically change the first character in a cell to be
uppercase. I just want lowercase. How can I turn off this function?
Go to Tools / Autocorrect and uncheck Capitalize first letter of sentence.
"ngoc" <email@example.com> wrote in message
> Excel automatically change the first character in a cell to be
> uppercase. I just want lowercase. How can I turn off this function?
...How refresh imported data automatically?
In Excel, I've imported data into a worksheet. I know I can click Data..
Refresh Data to requery the source, but I want to be able to do it in a more
Is there some sort of macro I can write when opened or something?
Select the cell the data starts in, select Data/Import External Data/Data
Check the box "Refresh on file open" and anything else that needs checking
Other than that, you could record a new Macro that selects your cell,
refreshes data, and assign the macro to a keystroke, or even an icon.
...How to view the same email message at the different PC users
My husband & I use the same PC(Windows XP) but have an
individual user accounts. We have several email addresses
for individual usages and shared usages and all enable to
receive and view by Outlook 2000 inbox. We have noticed
that the emails came in while I'm on Outlook (or
minimized at the bottom) can not view when my husband
goes to his Window user and open the Outlook. And vise
versa. We want to be able to look at all emails that came
into the Outlook inbox at both Window user's Outlook
inboxes. How can we do that?
...Outlook error message #4
Microsoft Visual C++ Runtime Error. What's the problem?
...New Named Range Created Each Time Data Imported into Excel via Macro
I have noticed that each time I import data into an Excel spreadsheet
via a macro, a new named range (for the same range) is created. This
does not pose a problem, but after a while, I'll have a huge number of
named ranges that will never be used. Why does Excel name the range
and how can I stop this? I noticed in the recorded macro, there was a
line .Name = "drd_5". I commented this out to see what would happen,
but it just renamed the range "ExternalData_5". The next one was
You could refresh with differen...why I see times new roman?
I have several html email messages composed in outlook express 6,
I'm sure I highlited all text and set it to Arial 10.
Then I drag the file to desktop, move it to vista windows mail draggin
into inbox or other folder. The result is some parts of text shows arial 10
some others Times new roman 10 or 12 what is annoying, because I use
all arial 10, so I have to manually forward the email, highligh it again and
set arial 10
and then, yes, I can see it properly.
I checked the compose default font and everything is fine.
Why is that? Is there any work around
, helo...Creating a worksheet in Spanish
Is there a way to create a worksheet on MS XP Pro running
Office 2003 Pro all in Spanish?
All valid formulas -except the ones from the Analysis Toolpack- will
automatically translate to the language of the Excel it's opened in. So any
spanish speaking Excel will translate formulas to spanish, no matter which
version it was written in.
The rest, text constants and such, has to be typed or pasted. Excel will not
translate this herself.
HTH. Best wishes Harald
"Kent" <Kent@discussions.microsoft.com> skrev i melding
news:ACCCBA3A-53B4...stop automatically changing formula!
i have a countif function
when i copy this and paste it to the next cell, the formula automatically
change to COUNTIF(Locking!J16:J40,"f")
How do I stop it from changing column I to J?!?!?!
MS Excel MVP
"caryn" <firstname.lastname@example.org> wrote in message
> i have a countif function
> when i copy this and paste it to the nex...Send 1 address to 2 mailboxes
I want to create an address and have any mail sent to that address delivered
to two separate users' mailboxes. How can I do that.
I've tried simply adding the address in the two users' "Email Addresses" tab
in the User's properties of ADU&C. But it wouldn't allow me to add the same
address to the second user ("This email address already exists in this
I've also tried creating a new user for the address and forwarding the email
to the 2 other users (Exchange General tab - Delivery Options button -
Forward To field). But ...Rule to automatically mark header to download based on contact list?
Is there a way to do this, or an add-in?
On Tue, 26 Apr 2005 04:44:35 -1000, rmc <email@example.com> wrote:
> Is there a way to do this, or an add-in?
What version of Outlook are you using?
Ben M. Schorr, MVP
"Ben M. Schorr - MVP" <firstname.lastname@example.org> wrote in message
> On Tue, 26 Apr 2005 04:44:35 -1000, rmc <email@example.com> wrote:
> > Is there a way to do this, or an add-in?
> What version of Outlook are you using?
>...Autosave mail sent from delegated mailbox
I'd like to autosave all mail sent from User Xs mailbox in his inbox. His
mailbox inbox is available to three different users who all have it added to
their Exchange account.
This way I'm able to auto-create readable conversations in his inbox and all
users can see which mail have been replied to from this mailbox and what the
You would have to write an event sink.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"Kristofer" <Kristofer@discussions.microsoft.com> wrote in message
news:DA61E72C-9405-4BF..."Organizational folder": 'new' menu is not available
I am following article:
and I try to create an organization folder. I go to my "Public FOlder",
click "System folder".
I see EFORMS listed there. I right click the option and I don't see the
What's wrong ? Exch 2000SP3.
...Default MESSAGE CLASS for mailboxes
Is it possible to change the default message-class that is attached to
Outlook(2002) folders when a new mailbox is created?
Specifically, I'd like any newly created mailbox (on our Exchange2000
server) to have IPM.Appointment.MyAppointment as the default message class
for the Calendar folder (rather than IPM.Appointment).
Alternatively - is it possible to change the default message class of the
Calendar folder from VB? (the property seems to be Read-Only, even though it
is editable via the user interface by picking the relevant form).