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,
...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" <email@example.com> 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" <firstname.lastname@example.org> 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 ...Problem with systemstate backup with DPM 2010
We running DPM 2010RC on a Windows 2008 R2
The Protected computer is:
Microsoft(R) Windows(R) Server 2003, Standard Edition
5.2.3790 Service Pack 2 Build 3790
When we installed the DPM agent the first backup of system state was
successfully, so we have one restore point. But further backups in failing,
the system state backup is in status “replica is inconsistent” and when I
running a consistent check the job failing.
In the error in DPM is:
The replica of System Protection Computer\System Protection on
sea0700smon1.xxxx.local is inconsistent with the protected data so...Questiontest-outlookwebservices problem
hi all and thanks for the support.
i'm facing a problem with test.outlookwebservices.
notice that oulook side everything seems to be pretty good: the
autodiscovery and auto-configuration of the account succeedes, the test email
autoconfiguration suceedes too.
when i launch the test, once it suceedes for certain services and after a
while it fails for those services and suceedes for other.
look the prints:
here are failing the RPC tests
Message : [EXCH] The UM is configured for this user in the AutoDiscover
response received from https://mytest-EXC1.
myt...Fewer normal template problems with Word 2000 or 2002?
I have enjoyed some things about Word 2007, but I keep having problems
with macros and templates. I am wondering if (a) macros increase the
likelihood of corrupting the normal template in 2007, or (b) if the
older versions of Word had as many template problems. I have used Word
in 2000, with Office 2003, and now with Office 2007 and I don't ever
recall having as many problems as I've had with 2007.
What I'm thinking is that if it is simply a macro problem causing
corruption, I would simply use 2007 without the macros (they're nice
but I can live without them). On the...Font problem
It seems that the Cambria Math font has recently acquired an extremely large
Ascent and Descent. Has it perhaps always been that way and I've never
noticed it before, or is it something recent, perhaps a Vista thing? Try the
following code for example. For Arial and Times New Roman (and virtually all
other fonts) I am getting pretty much exactly what I would expect (a
TextHeight that is a bit larger than the point size) but for Cambria Math I
am getting an extremely large TextHeight (I get exactly the same results
using GDI32 methods). At this end (on my Vista Business laptop...08 Mac Office activation problems
Operating System: Mac OS X 10.5 (Leopard)
Just found an article posted by michellec and I am faced with exactly the same problem - on 'activation' of the product, none of the 3 product keys seem to be correct, hence activation is unsuccessful!! Have received some help emails (and thanks Diana yours had the microsoft help number that has been good, despite the fact they can't help me and tell me I must get in touch with Digital River) but seems that what I need is another product key, and now that I'm asking for that since about 10 days, I don't get any reply ...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...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 ...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...Autoshapes' visible problem
When I add some Rectangle autoshapes above the embeded chart, I find
it's hard to control it's visibility, They maybe hide when I select
some cell or activate chart. I want to know how to make them always
visible no matter what I select.
Thank you in advance! ^_^
You need to click on the chart before you use the drawing tool. In this way
the Shape and the Chart become one.
Bernard V Liengme
remove caps from email
"fujing1003" <email@example.com> wrote in message
news:1171358292.074278.135950@v33g2000cwv...Office 2004 SP 11.1.0 installation problems
I'm trying to update Office 2004 on my brand new iBook. I installed
Office 2004 from the CD without incident. Then I downloaded SP 220.127.116.11
and 11.1.0 (which according to the MS website is to be installed 1st.)
When I try to install, I received a message, "An error prevented the
update from completing 11002:2,-14" The "Read Me" file indicates
several potential explainatins/solutions none of whice are relevant
except for uninstalling Office and then reinstalling it. I tried
dragging the Office folder to the trash and reinstalled and am having
the same problem. I've t..."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).
...RMS and/or PC Charge Problems
We are having some interesting problems with our RMS system and PC Charge:
For no apparent reason RMS will have an error message after a card is swiped
or keyed into the system:
• DENIED (With a wide variety of error messages)
• DUPLICATE use F+ to force (even when it is the first transaction)
• TIMED OUT
• Turned modem off and on
• Disconnected the modem and plugged everything back in
• Turned the server on/off
• Called PC Charge only to be told that it is RMS
• RMS said it is PC Charge
• Confirmed that everything is set up properly in PC Charge and RMS
What works:...Exchange 2007 Mailbox Folder information not updating
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: Exchange
I am using Entourage 2008 Web Services Edition in an Exchange 2007 SP1 UR4 environment. I have only been using the Web Services Edition for about a week and prior to that I was using the regular Entourage 2008 client for four months. In any case, the problem I am about to describe occurs in both versions of Entourage 2008. <br><br>Recently my employer's executive group decided to implement Managed Folder Policies to assist in controlling mailbox size. I was the first to...Outlook 2003 Signature Problem
I've created a signature with my company logo (.jpg file) using Outlook
2003. When the signature is attached in my email, the photo/icon file shows
a box with an 'x' in place of the .jpg file. I checked the location where
the files are stored and I found the .jpg file in the proper folder under
Thanks in advance for your help.
Tools - options -security tab, click on change automatic download settings.
Change to what you want.
"Mikeul" <Mikeul@hotmail.com> wrote in message
news:firstname.lastname@example.org......User accout shows new email
On start up a message shows in my user account that I have new email messages
but am using Outlook 2003 and all incoming emails have been deleted. How do I
clear the message
...Problem in restricting users from sending/receving internet email
I have found a helpful articel here:
I read it through couple times but I would like to ask some questions
before I start the work on our Exchange 2000 server.
1. The "group" I am going to create for adding users into the
restricting list, will it be a Security group or Distribution group?
What group scope should I give it?
2. Under the section of "Restricting Users from Sending Internet Base
Email", the article tells us to create a *new* SMTP connector and add
the group into the "Dilivery Restriction" page.