if cell is text move left one column
ColB is a long list with sections names followed by category codes
I need to move the text into colA leaving colB with codes only (all numbers)
Dim lngRow As Long
For lngRow = 1 To Cells(Rows.Count, "B").End(xlUp).Row
If Not IsNumeric(Range("B" & lngRow)) Then
Range("A" & lngRow).Value = Range("B" & lngRow).Text
Range("B" & lngRow).Value = ""
...Monitor Server in 2003?
After installing Exchange 2003 SP1, I'm having some issues monitoring
exchange server via scripting.
1. I can no longer get any instances from
"Win32_PerfRawData_ESE_DatabaseInstances" via scripting.
2. The property "LogGenerationCheckPointDepth" does not even appear as a
property of "Win32_PerfRawData_ESE_DatabaseInstances". (I checked this with
WMI CIM studio)
I can still get the LogGenerationCheckPointDepth from performance monitor.
The following code verifies what I've seen in WMI CIM studio:
set RawProc = GetObject("winmgmts:\\r...Delete dead mailbox from active directory
We have four exchange servers - two E2K and two E2k3. One of the E2k server
just died due to corrupt array control. We had no mailboxes or anything
else on that server. One of our administrator must have created one mailbox
on that server by mistake and he never realized that until now. server died
and we deleted that mailbox from active directory but, when i try to remove
the server from system manager i get message saying can't remove because
there are mailboxes associated with this information store. Is there any
other way i can remove that server from active directory or s...OWA. CA's. and Exchange 2007
The other day, I had to renew the Certificate on my Exchange 2007
server. Everything seemed to go alright, but eventually I received
complaints that outbound email wasn't being sent. Looking at EMC
showed all of the email queued up and waiting for something. After I
relaxed the settings on my router (Allowed all outbound SMTP instead
of restricting it to the Exchange server sending to MxLogic) all of
the outbound email went though.
I also was receiving reports of Webmail being broken (which was
halfway fixed with the help of
http://www.microsoft.com/technet/support/ee/transform.aspx?Pr...Can't create Organizational Forms Library in Exchange 2003 with SP
I cannot create an Organizational Form in EFORMS REGISTRY folder (from First
Administrative Group->Folders->Public Folders->EFORMS REGISTRY in ESM). When
I right-click the EFORMS REGISTRY folder and select New, there is no
Organization Form. Instead, I only see Public Folder in the popup menu. Do
you have any idea why Organizational Form menu does not show?
My Exchange Server is Exchange 2003 with SP2. The login user is Administrator.
Could you please help me? Thank you very much.
Is that account member of "Enterprise Admins" group?
Yang Zhang wrote:
&...Multiple domains on one Exchange server / All but one domain shows up as spam #2
I am sorry if this is on the board somewhere but I have been searching
forever and havn't found a hint yet.
I have multiple domains setup on my exchange server. Lets say abc.com,
def.com, and hij.com. We only send email with @abc.com but can receive
from any domain name. Recently we merged with another company and we
brought back their email to our server, lets say xyz.com. Now I
configured a new recipient on Exchange 2003, so I now have two
policies. The first policy has the three original domains in it with
@abc.com as the primary domain. In the second policy I have configured
xyz.com t...SBS 2003 moving of users files
I run SBS 2003 and due to the amount of data on the users drive it has
become chokers and have installed a new 1tb drive to keep up with demand
I need to move all the data to the new drive but unsure of the process.
Is there an easy way of doing this? As it needs to be done asap
JimmyJames's Profile: http://forums.techarena.in/members/255792.htm
View this thread: http://forums.techarena.in/small-business-server/1357051.htm
You c...Outlook Mail via a PROXY SERVER?
If I am using a shared Internet service on a second computer using a PROXY
server on the host (first) computer. I can access the net using the PROXY
settings on the Internet explorer. However, how do I download mail with
OUTLOOK 2000? The proxy server is CCPROXY from YoungZSoft (this runs on XP)
and it has the MAIL Settings enabled but the difficulty is what to do on the
That would be determined by the proxy manufacturer - check with their
> If I am using a shared Internet service on a second computer ...Moving Exchange #5
I am needing to move my Exchange server off of the SBS box that it is
currently on and move it to another, new server. I cannot keep the servers
the same name as I need the old server to continue to run SQL. Are there
white papers on how to do this?
On Fri, 18 Aug 2006 08:43:40 -0700, scottdog129
>I am needing to move my Exchange server off of the SBS box that it is
>currently on and move it to another, new server. I cannot keep the servers
>the same name as I need the old server to continue to run SQL. Are...Backing Up Exchange Database
I am running Exchange 2003 on a Windows 2000 server. Veritas Backup 10, is
installed on the server. The Exchange Agent is also installed on this
server. A full backup with the option to clear committed logs is used to
perform the daily exchange backups.
I noticed that in the MDBDATA folder the logs are continuously being added
approximately 5MB in size. Is there a way to have these logs removed
automatically as I thought that the backup would perform that function.
On Thu, 5 Jan 2006 17:18:02 -0800, microsoft
>...Exchange 2003 IMAP and Postini
Hello all --
I have a problem and I was wondering if the smart ppl out there could come
up with a solution.
I've enabled Secure IMAP for our users with cell phones with pocket PC
installed on them... Basically, we are using Postini, and they want you to
ONLY accept connections from their servers, so as to not allow SPAMers to
directly connect to the exchange server and directory harvest attack.
However, when Idid that, my IMAP ppl can't SEND email anymore because they
aren't coming from the trusted IP range. Is there anyway around this?
Probably not, but I thought I'...Limit on Exchange 2003 version included with SBS 2003
Can anyone tell me if the version of Exchange 2003
included with Small Business Server 2003 has the 16GB
limit that exists in the Exchange 2003 standard edition?
>Can anyone tell me if the version of Exchange 2003
>included with Small Business Server 2003 has the 16GB
>limit that exists in the Exchange 2003 standard edition?
...SQL Server Connection Failed
Hi everybody, this is my scenario:
1. Windows Server 2008
2. WSS 3.0 + MOSS 2007
3. SQL Server 2008.
i'm having this problem: "Login failed for user 'sa'. Reason: An error
occurred while evaluating the password. [CLIENT: 188.8.131.52]".
in this momment i can't see any application from sharepoint. somebody knows
how can i do?
i don't change the sa password. i don't change anything in the sharepoint
configuration. since two days ago i'm having this problem. pls, is very
urgent, because i have to deliver this server the next monday to the...Troubleshooting Exchange
I'm just wanting to write some 'proof of concept' scripts relating to
Exchange that would help in troubleshooting any issues. Like the Exchange
Are there any other qualitative data that can be used in general
...Creating Exchange 2003 organization
Is it possible to have two Exchange Organizations in the same domain? I need
to reproduce a problem and was hoping to install an Exchange server to an
existing domain however I need the organization to be different. Is this
possible? When I installed EX 2003 I wasn't prompted for information other
than location of files.
Thanks in advance
On Mon, 28 Feb 2005 08:09:03 -0800, "RP"
>Is it possible to have two Exchange Organizations in the same domain? I need
>to reproduce a problem and was hoping to install an Exchange server...Exchange server crashed, please help....! Need to restore two priv.edb and pub.edb files into one....!
I was wondering if I could get some help with the following problem we are
having on our company.
Here is the scenario; Our Windows NT 4.0 SP4a server running Exchange 5.5
SP4 crashed (Server 1) due to the exchange database reaching its 16 Gig's
max limit. I went ahead and moved some mailboxes' e-mails to a few .pst
files in order to make some space. This worked ok. Then, I decided to build
another exchange server (Server 2) to moved some mailboxes and alleviate the
load. Once the server was ready and configured as part of the current
exchange site, I went ahead and move...Changing ip address of exchange server #2
I have a back-end server and a smtp server in DMZ.
I want to change ip address of back-end server. are there any issues?
all incoming and outgoing emails are going via smart host.
No issues at all as long as you remember to change all the references to
this server in your firewall, SMTP scanner etc.
"Jack Dorson" <JackDorson@discussions.microsoft.com> wrote in message
> I have a back-end server and a smtp server in DMZ.
> I want to change ip address of back-end server. are ...Outlook, Palm Pilot, and Exchange Server
I'm using Outlook with an Exchange Server (2000 Small
Business). I installed the software for the Palm Pilot
and now it prompts with a dialog box for the user to
chose the following when they reply, forward or reply to
all on an e-mail message.
A Program is trying to access e-mail addresses you have
stored in Outlook. Do you want to allow this?
If this is unexpected, it may be a virus and you should
Allow access for (if you check the box) it gives 1, 2, 5
and 10 minutes.
If you say no it lets you reply, forward, and reply to
This is a nuisance more than ...Migrating Exchange servers
We are in the process of migrating to a new exchange server. The issue we are
having is transfering the user's outlook (xp, 2k) address book/contact list
to the new server without manually having to log into everyone's computer and
pointing their address books to the new server.
Is there a way to do this authomatically server-side?
You're moving the mailboxes, right? The user's "address book" is the
Contacts folder in the mailbox. So, there's nothing extra to move.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
...IMAP address on exchange sever #2
how can I find the IMAP address of my exchange server?
...Link Outlook 2003 to Exchange 5.5 over VPN
How do you do it?? I have a VPN, I can ping the ip of the
mail server (NT4) but cannot see it when I test from
within Outlook 2003 exchange account
Put the IP address and server name of the Exchange server in your local
computer's hosts file and see if you can then ping by name - if you can, you
ought to be able to access the mailbox. That's just one quick way to do
it....but it ought to work.
> How do you do it?? I have a VPN, I can ping the ip of the
> mail server (NT4) but cannot see it when I test from
> within Outlook 2003 e...Can not open additional mailboxes in my mailbox after a exchange 2003 rebuild database
To Exchange 2003 Gurus
I have a exchange server that serve a lot of users. 3 week ago I had
to repair the database with great success. But now I noticed a problem
that in the past I was able to acomplished
I can not open additional mailboxes in my mailbox.(right click on my
mailbox>properties>advanced>Advanced tab> and
when I click on add I get THE NAME COULD NOT BE RESOLVE. THE ACTION
COULD NOT BE COMPLETED.
This message appear eventhough I did not type anything
Here is more info
-I am able to open additional mailboxes if I use a computer with my
profile that I created before I r...Autoupdate.app behind proxy server.
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
Is there any way to get the autoupdate.app to work behind a proxy server/autoconfig file?
I have about 70 users that I have to email and rely them to install the patches rather than using the 'autoupdate' to do the job.
I hoping some clever bugger has found a way of making the flippin thing work...
Thanks in advance.
...Outlook 2003 on Exchange
despite of searching for days now, I couldn't find a solution to the
We are a 3-person team in a small news agency, that all three have
access to a mailbox that is hosted on an exchange system. We use
Outlook 2003 on our workstations.
If we get new emails, we sort the ones out that are worthy to read
later and drop them into a subfolder of that mailbox. Let's call that
subfolder "to_check". The chief editor then checks this folder once a
day and then deletes the emails or moves them further to other
Now, we have a new colleague in...Multiple DHCP servers
I have 2 DHCP servers setup in my domain using the 80/20 rule that Microsoft
recommends. I have problems with the 2nd DHCP server however, because it
continues to run out of available address leases as it would appear clients
default to pulling their addresses from the DHCP server with fewer addresses.
Is there a way to default clients to pull their address from a specific DHCP
server first and when unavailable, from the second DHCP server?
Welcome to the Microsoft Macintosh Office newsgroup.
Personally, I would like my computers, refrigerator and heating system to
each have th...