2 site/1 e-mail domainOk here is the setup at the moment
2 sites - different locations no direct link
domain1.local (2003 server) using company.co.uk
domain2.local (2003 server) using company.co.uk
domain1 collects the e-mail from an external source and uses mailgate
to sort mail (users pop in)
domain1 has an account for domain2 with alias users that are at domain2
domain2 then uses the same mailgate program to collect from domain1 and
users at domain2 pop to that.
both sites are moving to exchange but both use the same company.co.uk
for e-mail
is there a way to setup domain1 to recieve mail but also have doma...
make column lists for select query.sheet1
table1 col1_1
table1 col1_2
table1 col1_3
table1 col1_4
table1 col1_5
table1 col1_6
table2 col2_1
table2 col2_2
table2 col2_3
table2 col2_4
....
....
sheet2
table1 col1_1,col1_2,col1_3,col1_4,col1_5,col1_6,
table2 col2_1,col2_2,col2_3,col2_4,
....
....
I want to make column lists for some table listed in sheet1.
for example, select column_lists from table1
without vba is it possible?
thanks.
I think you may want some dependent lists.
http://www.contextures.com/xlDataVal02.html
HTH,
Barb Reinhardt
"kang" wrote:
> sheet1
> table1 col1_1
> table1 col1_2
>...
Table not listed in Table Names / Table Descriptions windowHi,
I am missing a 3rd party table in the Table Names window. I'm trying to
view the table via the Tools > Resource Descriptions > Tables navigation but
my table does not display here. I can view the table under the SQL
Maintenance window (Tools > Maintenance > SQL). Does anyone know why it does
not appear under the Resource descriptions for Tables? I have other 3rd
party tables that appear here just fine.
Thanks in advance,
Jacqy
What module is it?
Frank Hamelly
MCP-GP, MCT, MVP
East Coast Dynamics
www.eastcoast-dynamics.com
blog: www.gp2themax.blogspot.com
I ch...
Quirky recent file list #2
Debra---
I do tend to open from Windows Explore more then File>Open. But I am
saving the file.
It's more that it is annoying when I close a file by accident and don't
quite remember where it got saved on the server.
Stacie
--
SPenney
------------------------------------------------------------------------
SPenney's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1079
View this thread: http://www.excelforum.com/showthread.php?threadid=267592
Well, I guess you weren't the only one who wanted this behaviour
changed. <g>
If/when you upgr...
Illegal operation error while printing EXCEL or WORD FilesHi,
I am facing an illegal operation error when i try to print any file from
excel (any no. of pages), this happens in stand alone printer as well as a
networked printer.
When we press the print button, it flashes this message, but still prints,
but once the printing is completed, i will have to restart the PC. Due to
this error other applications PRINTING also will NOT HAPPEN and the only way
out is, restart the PC.
This happens not only in EXCEL, it happens in all the MS applications
(outlook, access, front page, powerpoint also).
When I check the print manager (before restart),...
Exchange 2007 Evaluation version #2Can I install it on 64 bit platform and run it as production?
On Fri, 23 Feb 2007 09:55:13 -0800, RG <RG@discussions.microsoft.com>
wrote:
>Can I install it on 64 bit platform and run it as production?
There isn't an evaluation version as such.
You can install Exchange 2007 without a key for 120 days.
...
Getting List of Visible WindowsHi All,
I am working on a problem that requires me to know whether or not any
part of a particular window is visible (even if it's like a one pixel
corner). In my misunderstanding, I thought that ::IsWindowVisible
would cover it, but it looks like that call just verifies that the
hWnd actually has a dialog box. I was able to take it a step further
and find out whether or not a window is minimized using
::GetWindowPlacement, but I really need to find out if a window is
visible or not (in other words, not completely covered by higher
z-order windows).
Is there some sort of API call that ...
List Shows Private FilesDID ANYONE ELSE NOTICE THIS?
Whenever I save an attachment, and go to the drop down
menu for file name, I am shown a list of dozens of files
recently accessed on the computer (not just files
accessed by Outlook Express). This occurs even if recent
cocuments is turned off in Windows XP and even if the
recent documents folder for Windows XP has been cleared.
This shows too much! Others using Outlook Express on the
same computer can potentially view the file names of
every document, image, and device recently accessed.
Where is the folder to clear this data out of?
duncan <anonym...
Unable to create more Windows NT accounts for Exchange mailboxesHi Guys,
Currently our Exchange server stopped allowing the creation of more Windows
NT Accounts with the following error"Insufficient System Resources exist to
complete the requested service".Pls is there a way out of this?
We run Exchange 5.5 SP3 on Windows NT Server.
--
Buchi
...
Edit Microsoft Exchange System Object with ADSIWhen I applied a new recipient policy to add a 2nd domain name to our
users, I applied it to all rather than using a filter to only pick the
users in the Users OU. Everything was still fine but we have one
conflict. A public folder had the same name as a user and thus had the
same email address.
We are getting the event:Event ID: 9514
Event Type: Warning
Event Source: MSExchangeIS
Description:
Two objects in the Directory have the same proxy -
/DC=COM/DC=[DomainName]/CN=[ContainerName1]/CN=[Object1] and
/DC=COM/DC=[DomainName]/CN=[ContainerName2]/CN=[Object2]
I deleted the public folder b...
Outlook 2002/XP Folder List view questionAny assistance would be greatly appreciated. I have a user still using
Outlook XP and has the following issue.
Outlook does not remember the folder view settings. User has folders under
the Inbox folders and of those folders some are expanded and some are
collapsed. When he closes Outlook it does not "remember" the folder settings.
The user would like for Outlook to remember the settings because it has in
the past. Is there a way I can get this back?
Thanks
...
outlook 2003 memory leak? /messages display as"none" and eats up memoryHi there;
When a certian user opens outlook, and clicks on sort by
size, half of her e-mails disappear, and "none" is
displayed. She said this happened to her at home, except
she was on her normal view which is sort by date. The
only way that I can recreate the problem is to click on
sort by size.
If you click on one of the "none's" or even hover the
mouse over it, the memory will spike up! I had the
performance tab open while I was doing this, and the
memory being used was read at 1.46 GB! And if I close
outlook the memory drops down to normal. I took ...
ESM errorI'm hoping someone can help me with this.
I have Exchange2k3 SP2 running on a Win2k3 server. Our Exchange Admin is
out on medical leave so I am resuming his responsibilities.
My problem is I cannot access some of the storage groups using exchange
system manager. We have 4 mailbox stores and I get an error trying to access
3 of them. The error is "An unknown error has occurred. ID no: 80040d1b
Exchange System Manager". What is really puzzling is if I click on a storage
group a second time, I don't get the error but the storage group shows up as
empty. I have thi...
Exchange Server 2003 Fails to Start after rebootSince rebooting our Exchange 2003 server running on Windows 2003 server
it fails to start the System Attendant and any further exchange
services. The only way to logon to the server is boot in safe mode with
networking.
The server is a member server and is reporting the following errors
EVENT 2114 MSExchange DS Access
Process INETINFO.EXE (PID=1720). Topology Discovery failed, error
0x80040a02.
EVENT 2102
Process MAD.EXE (PID=2176). All Domain Controller Servers in use are
not responding:
crstgs003.CRSTG.LOCAL
crstgs004.CRSTG.LOCAL
EVENT 2114
Process MAD.EXE (PID=2176). Topology Discovery ...
Upgrading from Exchange 2000 Standard to Enterprise Cal ? #2Hello Everyone,
I know the upgrade process from exchange 2000 standard to enterprise
seems pretty straight forward. However, I have a cal question. Are my
standard cals still good with this upgrade. Say I have right now
standard 2000 with 30 cals. If I upgrade to Exchange 2000 Enterprise
with 25 cals to pass the 16mb limitation.
Would I then only have the 25 cals or 55 total cals?
Thanks
...
#Error MessageI have created a calculation to count the number of people and placed it in
the Name Footer: =count([EyNumber]) and called the unbound box, CountNames.
When there are no results it returns the #Error message. How can I remove
this error message and display a message like, "No Data", or display the true
results of a count? I have tried using the IsError function but can't seem to
get it to work.
Thanks
Hi Nigel,
Try:
=IIf(IsError([EyNumber]), "No Data", Count([EyNumber])
Clifford Bass
Nigel wrote:
>I have created a calculatio...
Contact not importing names of csv listsWhenever I import a csv file into outlook 2007 it imports only the email
addresses, nothing else. I've titled the csv columns with the exact same
headings as the outlook contact headings. Still, it imports only the email
addresses. What do I need to do to get it to import the full names as well?
Is it correct to assume that because you stated that you "titled the csv
columns the same as the Outlook contact headings" - that you used
"auto-map" to import your data?
There is absolutely no reason, benefit or value whatsoever (under any
circumstances) in ...
Exchange 5.5 <-> Exchange 2000 cannot rebuild ADCI have two servers, one is Exchange 5.5, one is Exchange 2000. They
are normally connected via the ADC. However, occasionally, these
servers will lose sync, and the only previous recourse was a reboot,
and a rebuilding of the ADC. Required a bit of extra "manpower", but
it got the job done.
So, we went through and tried it again to fix a problem, and now we
cannot get the ADC back up. When I try to set the destination or
source for the ADC to place/get information to/from the Exchange 5.5
system, I get the following error:
"The Exchange server specified does not meet the...
How do I randomize a list without repeatsI have a listing ordered from 1 to 1596 that I would like to re-order -
randomize such that no one item in the list is repeated.
I am using Microsoft Office Excel 2003
Hi,
Let's say that your list is in A1:A1596. Create a helper column, say
B1:B1596 as follows:
In B1, enter the formula =RAND(), and drag the formula down the column to
B1597. Select B2:B1596, and in the SAME column, "Copy" --> "Edit
Special"-->"Values".
Now select both the columns and sort by column B (ascending or descending).
Regards,
B. R. Ramachandran
"K9CE" wrote:...
SMTP 550 MessageHi folks,
Went I send an email via my Comcast to the following address
(dvanderwoude@nwpic.bellingham.wa.us) I get the following error.
Reporting-MTA: dns; comcast.net
Arrival-Date: 29 Jun 2006 16:19:43 +0000
Final-Recipient: rfc822; <dvanderwoude@nwpic.bellingham.wa.us>
Action: failed
Status: 5.0.0 550_#5.1.0_Address_rejected.
Diagnostic-Code: smtp; Permanent Failure: Other undefined Status
Last-Attempt-Date: Thu, 29 Jun 2006 16:19:43 -0000
I understant tha a 550 is a deny, I just don't know were should I look or
what to do in able to fix this issue. I should said also, that t...
Combo Box Value List/Query CriteriaHi Folks - I have a combo box with a value list of Option1, Option2 and ALL.
I pass this combo box info into a query. Here's a sample of the query
criteria:
IIf([Forms]![frmSwitchboard]![cboCaseType]="all",Is
Null,[Forms]![frmSwitchboard]![cboCaseType])
In other words, if the combo box selection is ALL, then display all records,
otherwise use selected option. The above criteria does not work. Any
suggestions? Thanks.
Michael
Michael,
Try... (IsNull is an operator, not a value)
IIf([Forms]![frmSwitchboard]![cboCaseType]="All",
Null,[Forms]![frmSwitchboar...
popup box message; "Publisher cannot open the file"saved as a .pub file but unable to open. popup box message "Publisher cannot
open the file"
What version Publisher do you have? Do you know what version Publisher was used to
create the file?
--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
"stature" <stature@discussions.microsoft.com> wrote in message
news:0AD1D565-743D-478D-95DD-5C5358400272@microsoft.com...
> saved as a .pub file but unable to open. popup box message "Publisher cannot
> open the file"
...
Trail Version of ExchangeHello
I have installed and i am test the trail verion of Exchange (180 days)
How do i check how many days i have left, as i cannot remember when i
installed this
Thanks
Andy
One way to do this would be to fire up ADSIEdit and find out when the
Exchange Server object was created in your Exchange Org in the Configuration
naming context.
Perhaps there are other ways as well, including app. event log...
--
Bharat Suneja
MVP - Exchange
www.zenprise.com
NEW blog location:
www.exchangepedia.com/blog
----------------------------------------------
"Andrew" <not@home.com> ...
Outlook 2002Can anyone tell me why in Outlook 2002, when I send a
message it goes to the Outbox and sits there until I click
another folder or wait for a long time. The Send Message
Immediately is checked. I did apply SP2.
Any suggestions will be greatky appreciated.
Thanks
Jim Stroyek
jim.stroyek@na.omgi.com
...
how do I stop Outlook from downloading old deleted email messages #2
...