Sequentially numbered Purchase orders
In the past with Office 97. I used a purchase order template that would
basically self number itself. when it opened a small box would appear and by
clicking it the PO received a unique number. How can I accomplish this using
...forwarding in Exchange 2003 #2
I configured the server (Exchange 2003) to forward a user��s emails to
firstname.lastname@example.org. It is very strange that all messages sent from xyz.com are
rejected (please see the sample NDR below), there is not problem to other
domains. email@example.com did not receive the message while the envelope
recipient (firstname.lastname@example.org) did.
Does anyone know how to solve this? Any help would be appreciated.
S...Exchange 5.5 to Exchange 2003 Migration Question: No ADC??
I have an environment where I need do do an Exch 5.5 to 2003 Migration.
The domain has already been migrated from NT4 to 2003. The only thing
is, is that there is no Active Directory Connector setup anywhere in
the environment. That leads me to my first question I guess. How is
this possible that Exch 5.5 is even working with AD?
In terms of upgrading, what would recommendations be? It is a single
Site. I was thinking about bringing up a new Exch 2003 server, and
using "Move Mailbox" to the new exch server. Replicate all the
necessary public folders, decomission the old ...help installing exchange 2000 in one of 3 sites
I have a domain cotoso.com installed and configured as AD for 3 companies
interlinked together. and + a total of 3 DC in 3 different sites that are
connected by VPN. i have exchange installed in each site connected on the
same domain contoso.Local(+ E-mail -->contoso.com) + hosting their own
companie domain name such as x.com or y.co or z.com for each company.
I have a routing link configured + 3 administrative groups in exchange
system manger for each company.
one DC in one site that also has exchange 2000 installed on it has to be
changed because of poor performance. now i'm ...Numbers in a text field-can I add them up?
Hi everyone! Using A02 on XP.
I have a table of data with survey response fields that contain a 0,1,2,3,4
or 5. However, the fields are formatted as text, not numbers. I need to add
up certain blocks (Items 1-6, Items 7-23, etc.) and then do some averaging.
I cannot change the field types from text. Must I append to a new table or
can I do something right in my query?
I've got one field in my query like this: ES:
My result is: 553453 or 554444, etc. I want: 25 or 22, etc.
I would really appreciate any help or advice. Thanks...Restore Exchange 5.5 on 2000 using ArcServe
- Windows NT 4 Server SP6
- Exchange 5.5 SP3
- ArcServeIT 6.61 with Exchange Agent
I'm trying to restore the Exchange information (database, mailbox...
everything) on another computer.
That computer has
- Windows 2000 Server SP4
- Exchange 2000
- Brighstore ArcServe 9 (build 2020) with Exchange Agent
Now the situation: I need to verify that the backup was made correctly
(entirely) in order to confirm the total validity of the backup (to validate
my disaster recovery plan) and to update to SP4.
I tried to find documentation with both Microsoft (for Ex...hyperlinking to an item in Global Address List Options
I have had success linking via html from web page to opening a
specific contact record from Microsoft Outlook. I have done it like
However, my very large contact database also has people with basically
the same name, like John Smith. In the current "Address Card" view
inside Microsoft Outlook, one of the John Smith's is always sorted
first. If I enter
the first John Smith in the sort order is always opened.
However, I want to specify one of the other John Smith's....Change outbound server in header to fix 550 Can't verify your host name error
The headers on the outbound emails show the internal DNS name of our
exchange server; obviously this won't resolve properly at the
How/where in Exchange 5.5 can I force the IMC to use a real fqdn on
You can do this in TCP/IP properties\Advanced\DNS tab of machine. And
yes, this is not just for Exchange, so you may consider forwarding all
outgoing mail to some relay server (your firewall or ISP's server).
Professor Frink wrote:
> The headers on the outbound emails show the internal DNS name of our
> exchange server; obviously this...copy of exchange 2000
I don't suppose microsoft is providing Exchange 2000 as a free download
anywhere are they??
Until we can afford to move up to SBS 2008 (hopefully later this year), I
want to trash our SBS 2000 (too many issues with it) and simply install a
win2k server with Exchange until we can move on. We are not using any of
the other SBS components any longer anyway...
If anyone knows where I might be able to get this from, I would be very
Why not look at BPOS? $10 per user a month it's a great inexpensive
solution. You may find you do not ne...How do I set the number format to Base 12?
I would like to change the number format on my spreadsheet from Base 10 to
Base 12, eg. 12 bottles makes up 1 case. Therefore, if I were adding up three
different cells 9 bottles + 11 bottles + 6 bottles, my result should be 2
cases 2 bottles if possible 2.2 in a case column.
See http://www.cpearson.com/excel/fractional.htm for details.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Andrew Moore" <AndrewMoore@discussions.microsoft.com> wrote in
>...display name #2
i have this problem: when i send a mail massage from an application by
exchange 2003, in outlook i see the e-mail address (xx@mydomain .com) and
not display name (Customer Care)
how can i resolve it?
An application should allow you to specify display name for sender. Does it
send via SMTP or MAPI?
> i have this problem: when i send a mail massage from an application by
> exchange 2003, in outlook i see the e-mail address (xx@mydomain .com) and
> not display name (Customer Care)
> how can i resolve it?
Please re...Deleted exchange 5.5 site not replicating over the ADC to Exchange 2000 side
We are a part of a shared Exchange 5.5 organization but our site is
primarily Exchange 2000/2k3. We maintain a single 5.5 server as the
rest of the Org is 5.5. The problem we are seeing is when the folks
who control the Organization at the top level remove a site that is no
longer used, that deletion is not carrying over the CONFIG_CA agreement
to the Exchange 2000/AD side. Our Exchange 5.5 server executes the
deletion with no issue.
Any ideas on why this deletion is not replicating properly over the ADC
and throught the SRS database? In the past we have manually removed
the sites/recipie...automatically naming files for savingb
for delivery notes i would like excel to look in the relative directory for
a given customer, ie if C4 contains superspecs, files relating to this
account would be in c:\work\superspecs\
files are named superspecsdel0001,superspecsdel0002.......etc
for delivery notes and invoices.
what i would like is a line (or more) to add to a macro which will look in
the appropriate directory, add 1 to the last four digits of the last file,
enter this number into a cell on the sheet and save the new file with the
appropriate name, then close the file.
is this possible, or alte...Save As using contents of Cell in Name
Can someone help with code that changes the "save As" file name to
combination of the original File Name + the contents of a cell, an
saves file in same folder as the original.
E.G. Original File Name= Timesheet
Cells B1= Location
Cell C1 = Date in format 3-5-2004
Cell A1 = concatenate(B1,C1)
Fle Name will therefore be "Timesheet Location 3-5-2004"
The other problem is with the date. When concatenating, how do I forma
the date to avoid it looking like "Location 38051"
Any help much appreciated
Message posted from http://www.ExcelForum.com
for c...Exchange SP2 #5
I'm going to install SP2 for Exchange 2003 which is on my SBS2003. Is there
anything i should know / do before I install?
1. Read the Release Notes.
2. If you ever installed IMF v1, uninstall it.
MVP - Exchange
NEW blog location:
"Damien" <email@example.com> wrote in message
> I&...cannot uninstall Exchange 2000
Just finished a migration from Exchange 2007 to Exchange 2000, and I'm not
able to uninstall Exchange 2000 from the old server to demote it gracefully.
I realize I can manually uninstall, but I'm trying to avoid that if possible
to keep it clean.
The error I'm getting is:
Setup encountered an error while checking prerequisites for the component
"Microsoft Exchange 2000": 0x80072030 (8240): There is no such object on
The bottom portion of the log is:
[05:51:15] Entering CCompDomainPrep::ScGetEffectiveMode
[05:51:15] Leaving CCompDomainPrep::...Exchange Stops Working
1. Primary server named STECNICIL (THIS HAS WINDOWS 2003 ENTERPRISE
2. Secondary server name TEC-EXCHNG (THIS IS THE EXCHANGE SBS SERVER
All the user connect through STECNICIL to get internet and every other
All users connect to TEC-EXCHNG to get their email through OUTLOOK 2003.
I don't know what's going on but approximatly every 30mn to 1 hour, the
connections between the clients and the EXCHANGE SERVER stops working. No
more email for clients after that period of time. I have restart the server
and restart the EXCH...Auto Response with Exchange 5.5
I would like to create a auto response with Exchange 5.5. So when
someone sends mail to firstname.lastname@example.org I can have an automated
response go back. But I can't setup rules inside of outlook and keep it
attached to the server I would like to make some sort of server side
rule if possible?? Any suggestions?
On Fri, 12 Aug 2005 15:09:59 -0400, bigdogg <email@example.com>
>I would like to create a auto response with Exchange 5.5. So when
>someone sends mail to firstname.lastname@example.org I can have an automated
>response go back. But I can't ...Active Directory/Exchange problem
Before I joined my current employer the admin here upgraded from
Exchange 5.5 to Exchange 2000(Box A) and then added another Exchange
2000 box to the organisation(Box B)and migrated the data in Box A to
Box B. Box B is now the working exchange server and Box A is no longer
The problem is that if I actually shut down Box A I can add a new user
to Active Directory but I am unable to modify a users email/smtp details.
mail can still be transferred with no problems which would lead me to
believe that Exchange is Ok but there is some sort of Active Directory
link between the two bo...Mounting exchange 2000 public folder store on exchange 2003
I have been told that this is not best practice we have gone ahead and done
this we where having a great deal of difficulty getting the public folders to
replicate. The public folder mail box was incorrectly named I used ADSIedit
to change the mail box name in AD but this didn't work.
So in the end we went for a dirty fix (users had lost access to public
folders for one day already) and dismounted then copied the exchange 2000
public databases to the 2003 box and mounted them there with apparent success.
I'm wondering if anyone has any experience with this? Can I expect this
s...Exchange 2003 with SP2 problems...
I installed the SP2 for exchange 2003 server tonight, and I'm getting
some problems. I added the registry key to increase the DB size to
30GB per the instructions, but I don't get a confirmation in eventid
1216 as it says I should. In fact, the message in eventid 1216 looks
mised up. See insert:
The Exchange store '16384' is limited to First Storage Group\Mailbox
Store (ATL-SBS) GB. The current physical size of this database (the
..edb file and the .stm file) is %3 GB. If the physical size of this
database minus its logical free space exceeds the limit of First
Storage Gro...Foreign Exchange
With Excel 2003, is there a way to have a cell automatically update th
foreign exchange rate of yen to British pounds from the internet, an
then use that cell to do calculations
peterthistle's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2892
View this thread: http://www.excelforum.com/showthread.php?threadid=48664
Here's something to get you started:
Open a new workbook
On Sheet1, enter the following:
B3...Consulta Exchange 5.5 Mails con fondo
Alguien sabe si es posible configurar un servidor Exchange 5.5 para que los
mails enviados salgan con un fondo (bacground) predeterminado?
...formula to get sheet name
can a formula retreive a worksheet name or does it need to be macro based?
This formula that takes care of the possible situation whereby you have only
one sheet in the workbook and its name is the same as the workbook's. Note:
CELL("filename") will only work if the file has been saved at least once and
if the file is opened in a different language system, the argument
"filename" will need to be changed manually to the corresponding word (e.g.
in Spanish "nombrearchivo"):
=LOOKUP(REPT("z",255),SUBSTITUTE(MID(CE...changing a name in mulit parts of a document
I am setting up a word document.
This will be used as a template
In this document I wish to insert the same "name" throughtout this document.
Is it possible to change the name in one spot and all of the others change
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>...