DNS Question - two Small Biz Domains on one subnet
Hello All, I am working with a customer that has 2 Small Biz servers in the same office. These are on 2 domains, but the same subnet. I am having trouble getting mail to route between the 2 domains. Each is Small Biz server 2003. Domain A has a public IP of 72.151.19.122 and an internal IP of 192.168.200.78. Domain B has a public IP of 72.151.19.123 and an internal IP of 192.168.200.250. We are using a Netgear firewall and inbound and outbound mail between each of these domains and the rest of the world works fine. They just can't seem to talk to each other. I would think this would be a DNS problem of some sort, but nothing I have tried so far seems to help. I have tried creating a manual entry in DNS on each server using an MX record that points to the internal IP of the other server. That didn't help. I tried using the hosts file. I have also configured the external DNS servers field to point to the correct ISP DNS servers. Still no luck. All mail for the other domain just sits in the queue. Any ideas would be greatly appreciated. Thanks, Mike
MikeMiller
exchange.admin
57650 articles. 
2 followers.
2 Replies
144 Views
On each Exchange server (which is in its own AD Forest/Exchange Organization), create a SMTP Connector for the address space of the other domain. Setup the internal IP address (assuming they're behind the same firewall) of the other server as a smarthost on that Connector. -- Bharat Suneja MVP - Exchange www.zenprise.com NEW blog location: www.exchangepedia.com/blog ---------------------------------------------- "Mike Miller" <MikeMiller@discussions.microsoft.com> wrote in message news:6C726AF5-5CAF-456D-9F38-9C77C0DBF030@microsoft.com... > Hello All, > > I am working with a customer that has 2 Small Biz servers in the same > office. These are on 2 domains, but the same subnet. I am having trouble > getting mail to route between the 2 domains. Each is Small Biz server > 2003. > Domain A has a public IP of 72.151.19.122 and an internal IP of > 192.168.200.78. Domain B has a public IP of 72.151.19.123 and an internal > IP > of 192.168.200.250. We are using a Netgear firewall and inbound and > outbound > mail between each of these domains and the rest of the world works fine. > They > just can't seem to talk to each other. I would think this would be a DNS > problem of some sort, but nothing I have tried so far seems to help. > > I have tried creating a manual entry in DNS on each server using an MX > record that points to the internal IP of the other server. That didn't > help. > I tried using the hosts file. I have also configured the external DNS > servers > field to point to the correct ISP DNS servers. Still no luck. All mail for > the other domain just sits in the queue. > > Any ideas would be greatly appreciated. > > Thanks, > > Mike >
bharat3597Bharat - thank you. That worked out perfectly. Mike "Bharat Suneja [MVP]" wrote: > On each Exchange server (which is in its own AD Forest/Exchange > Organization), create a SMTP Connector for the address space of the other > domain. Setup the internal IP address (assuming they're behind the same > firewall) of the other server as a smarthost on that Connector. > -- > Bharat Suneja > MVP - Exchange > www.zenprise.com > NEW blog location: > www.exchangepedia.com/blog > ---------------------------------------------- > > > "Mike Miller" <MikeMiller@discussions.microsoft.com> wrote in message > news:6C726AF5-5CAF-456D-9F38-9C77C0DBF030@microsoft.com... > > Hello All, > > > > I am working with a customer that has 2 Small Biz servers in the same > > office. These are on 2 domains, but the same subnet. I am having trouble > > getting mail to route between the 2 domains. Each is Small Biz server > > 2003. > > Domain A has a public IP of 72.151.19.122 and an internal IP of > > 192.168.200.78. Domain B has a public IP of 72.151.19.123 and an internal > > IP > > of 192.168.200.250. We are using a Netgear firewall and inbound and > > outbound > > mail between each of these domains and the rest of the world works fine. > > They > > just can't seem to talk to each other. I would think this would be a DNS > > problem of some sort, but nothing I have tried so far seems to help. > > > > I have tried creating a manual entry in DNS on each server using an MX > > record that points to the internal IP of the other server. That didn't > > help. > > I tried using the hosts file. I have also configured the external DNS > > servers > > field to point to the correct ISP DNS servers. Still no luck. All mail for > > the other domain just sits in the queue. > > > > Any ideas would be greatly appreciated. > > > > Thanks, > > > > Mike > > > > >
Similar Artilces:
Multiple user names at one bank or brokerage
I have 3 accounts at one bank. I have 3 corresponding accounts set up in MS Money 2007. One of them is setup for online banking while the other two are not. I now want to set the other two up for online banking but I can't find a way to specify the unique login info for each of the other two accounts. ...
Access 97 Runtime question
We are using Access 97 runtime for some of our staff. I noticed today that in reports if they right mouse click, they don't get a shortcut menu. I want them to be able to Export the report they are viewing. Would Access 2003 runtime have the shortcut menu? Thanks Kelvin "Kelvin Beaton" <kelvin dot beaton at mccsa dot c o m> wrote in message news:uiQA0i7zHHA.1168@TK2MSFTNGP02.phx.gbl... > We are using Access 97 runtime for some of our staff. > I noticed today that in reports if they right mouse click, they don't get > a shortcut menu. I want them to be...
Optimiztion question
I was looking at MSDN on optimizing queries (http://msdn.microsoft.com/en-us/library/ms998577.aspx) and am unclear as to why a foreign key relationship affects the query in this case. At the beginning of the article it gives an example and starts out by saying: The sample screen shot in Figure 14.2 shows an execution plan that accesses only one table, although two tables are included in a join in the query. Because there is a declared foreign key relationship between the authors table and the titleauthor table, and the au_id column in the titleauthor table is not allowed to b...
Multiple Domain e-mail addresses
We are running Exchange Server 2003 Enterprise addition and I am having a bit of a "brain-freeze" at the moment... Where in the Exchange Admin do I configure the server to accept e-mail from more than one domain. For example, we currently accept e-mail from mycurrentdomain.ca and would also like to accept email from mycurrentdomain.com. Please note that I have updated all of our DNS MX records as required, just need to make the changes on the Exchange server. Thanks in advance... Recipient polices-email address policy. "Raymond Spitzingle" <ray(nospam)@stuff...
How do I merge two publisher files?
I am using publisher 2003. I am creating an 80 page catalog. I like to save page 1-10 as file one, pages 11-20 as file two and so on. When I am finished with my catalog I need to send one file to the printer. How can I merge all of my pages together in one file? Copy and paste. Or if you have Acrobat (not just the free Reader) you can create a single .pdf file with the parts. -- JoAnn Paules MVP Microsoft [Publisher] "screnda" <screnda@discussions.microsoft.com> wrote in message news:CF96E50B-CBC8-4A5A-A854-D7EE130CE9AD@microsoft.com... >I am using publisher 200...
Using two conditions in a formula
How do I write the following formula: I am in cell I6 If g6 AND h6 is blank, then blank, else I5 minus g6 plus h -- Richard Pit ----------------------------------------------------------------------- Richard Pitt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1533 View this thread: http://www.excelforum.com/showthread.php?threadid=27042 Richard, In cell I6, enter the formula: =IF(AND(G6="",H6=""),"",I5-G6-H6) Though you don't check for case when G6 is blank and H6 isn't, etc. HTH, Bernie MS Excel MVP "Richard ...
Macros/Signatures Question
I have an Excel Workbook that I created for a PC Order Form. I set it up to only make certain rows visible based on the Machine Model that they choose. I digital signed the Worksheets and exported the Digital Signature Certificate and installed it on the User’s PCs. The code works great. The user opens the Workbook and it runs the Macros with no problem. The problem I have is when the user goes to save the Workbook. They get an error that “Excel can not sign VBA macros when saving to this file format. Do you want to remove the digital signature and continue saving this workbook?”...
Windows and Mac have two distinctly different units for column width.
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I am trying to format columns for some data I am entering in a spreadsheet and when I enter "15.00", which is the required width for these columns given by my professor, I end up with a column 15 inches wide. What I would prefer is for the options to be like the default options in Windows version of Excel. In Windows version of Excel, when you hover over the lines between the columns it gives you two numbers (e.g. 8.43 (64 pixels)). These are the default numbers for column width in Windows Excel....
I cannot paste from one workbook to another. Copy works, paste do.
When I attempt to copy from one workbook and paste into another, copy appears to work but paste does not. The paste menu item is grayed out in the workbook to which I attempt to paste. Are there setting that can be changed to aloow the paste?? Check to see if either workbook and/or worksheet is protected. If so, unprotect. Then Copy/Paste should work. BTW, how are you copy?paste(ing) Tab or content? Dennis "JimmyMc" wrote: > When I attempt to copy from one workbook and paste into another, copy appears > to work but paste does not. The paste menu item is grayed out...
Simple IMAP question
Hi, How do I enable shared calendar with free/busy information through IMAP ? When I add the "calendar" folder in IMAP it displays as a mail folder, not a calendar. Pierrot Is this calendar a mailbox or public folder? Why are you using IMAP instead of MAPI? MAPI is much more feature complete as it applies to this sort of thing. -- Ed Crowley MVP - Exchange "Protecting the world from PSTs and brick backups!" "Pierrot Robert" <mcthepro@nospam.hotmail.com> wrote in message news:%23NzXwrV6GHA.4352@TK2MSFTNGP05.phx.gbl... > Hi, > > How do I...
Exchange 2003 Question??
Dear all, I would like to know if there is an upgrade path from Exchange 2003 Standard Edition with SA to Exchange 2003 Enterprise Edition with SA? Thank you. Regards, Kueh. This might help http://support.microsoft.com/default.aspx?scid=kb;en-us;170280 -- Santhosh Sivarajan MCSE(W2K/NT4),MCSA(W2K3/W2K/MSG),CCNA,Network+ "KA Kueh" <kka@ksm.com.my> wrote in message news:exVKwgOKEHA.1040@TK2MSFTNGP10.phx.gbl... > Dear all, > > I would like to know if there is an upgrade path from Exchange 2003 Standard > Edition with SA to Exchange 2003 Enterprise Edition wit...
Unable to delete the Dead Domain controller
Dear, Iam working on windows server 2008 Ent Ed I have two doman controllers in the domain both are GC but only one domain controller has all the fsmo roles but iam having replicattion problems with the dead DC (i.e mppkw-database) and Iam unable to delete or remove the dead domain controller from the domain and iam having follwing problems using the ntdsutil :- matadata cleanup select operation target: list domains Found 1 domain(s) 0 - DC=mediaphoneplus,DC=com select operation target: select domain 0 No current site Domain - DC=mediaphoneplus,DC=com No current server N...
Exchange error
Hello, for one week now, my exchange 2000 server crashes nearly every night at random time, the only solution to have it all restart is to restart the entire server. In the application log, multiple error events are reported like these : Event Type: Error Event Source: Userenv Event Category: None Event ID: 1000 Date: 26/07/2005 Time: 01:27:39 User: NT AUTHORITY\SYSTEM Computer: BELLINI Description: Windows cannot establish a connection to *domain name* with (1364). Event Type: Error Event Source: Userenv Event Category: None Event ID: 1000 Date: 26/07/2005 Time: 01:37:41 User: ...
IDN/ACE domains
Hello, Does anyone know if it's possible to have ACE/IDN domains in Exchange 2003 ? I want to have a domainname with norwegian characters in exchange but I doesn't allow me to type norwegian characters in the email-tab in active directory users and computers. Any ideas anyone ? Third party plugin ? Kindest regards, Rikard Strand ...
Combine small documents into one master document
Hi, I currently have an "engagement letter" that is created for our clients to set the expectations for our business relationship (I work for attorneys). We have about 10 different paragraphs that may be inserted into the letter based on different factors (3rd party payor, if a retainer is required, etc.). So I start with the basic letter and then have a userform with checkboxes where you can select the text block options (stored in Autotext). When you click OK the various paragraphs are inserted at bookmarks. While this works, I find working with Autotext cumber...
out side domains
I can not send emails to persons that do not use the same domain ISP. I recieve this message when i try to our message did not reach some or all of the intended recipients. Subject: Sent: 18/04/2004 8:43 PM The following recipient(s) could not be reached: someone@somewhere.com.au on 18/04/2004 8:44 PM 550 5.7.1 <someone@somewhere.com.au>... Relaying denied. IP name possibly forged [203.134.100.118] Has anyone got any ideas Thanks Brad .. Have you set your server settings to authenticate before sending? --� Milly Staples [MVP - Outlook] Post...
Filter two columns with criterion applying to one or the other?
Hi, I am looking for a solution to the following filtering problem: I have two adjacent columns, so using a filter for both of them is no problem. But what I want to do and don't know how to do is this: I want to filter for values greater than x (a certain number, in my case 5000) in any of the two columns. I can filter both columns for x greater than 5000 but that filters out more than I want because there may be some cells with a value greater than 5000 in only one of the two columns. Is there a solution to this problem (using Excel alone or an add-on)? Peter Hi Peter you can use th...
Excel2000: Strange behaviour for one cell in workbook
Hi The situation: There is a Excel workbook used for registering working time in firm departments, created earlier. The worksheets are protected, and I don't have the password, as author isn't working here anymore. The workbook is stored as read-only on network resource, and monthly every department is copying it to local computer and filling the table. The table's body has 2 rows data for every employee with 31 columns for month's dates, and several protected summary columns. For every date, working hours or some code string is entered into according cell. One of codes, and ...
Vlookup, multiple times in one column summing corresponding
I have a list that contains common invoice numbers that appear multipl times in column A and need to use the vlookup function to find and su the corresponding amounts in column B. As you would be aware the following vlookup functio =VLOOKUP(A3,DATA,2,FALSE) will only return the one amount once i reaches a match and I need it to continue down the column and sum al matching invoice numbers. Column A Column B 145768 356.87 145769 678.90 145880 80.87 * 145769 103.55 145770 56.90 145769 78.32 145880 54.09 * The answer I�m looking to return is 145880 134.96 It has to be a vlookup sty...
using domain account for Exch2003 services
In Chapter 3 of the MS Press Training Kit "Implementing and Managing Microsoft Exchange Server 2003", there are instructions for changing the Exchange Services to run under a domain account (with appropriate group memberships and rights) rather than the default Local System account for security & auditing purposes. However, I could not start the services after making the change and reviewed several articles stating that only the Local System account will work - KB Articles 271920, 239762, etc. Is the training kit wrong, or is there a way to do this? thanks in advance, Art ...
One front-end server multiple back-end servers
Hi, I was wondering if someone could help with the following scenerio and make some suggestions as to an answer. We have 3 exchange AG groups. 1 AG group has 3 exchange servers in it, each located in it's own AD domain. 1 AG group has one exchange server in it, it's in its own AD domain. Thirdly, the last AG group has 2 exchange servers in it, both are in the same AD domain. 1 of these 2 exchange servers in the final AG mentioned is a front-end server, that should be supporting all the exchange back-end servers. The problem we are facing is that when a user from any of the ...
Filtering question
Is there a way to expand the filter option so that it shows 1 row (or more), both above and below any row that contains the value I am looking for? Data|filter|autofilter examines each cell/row on its own. Maybe you can put the key value for each group on the rows you want. Then filter by that column. richzip wrote: > > Is there a way to expand the filter option so that it shows 1 row (or more), > both above and below any row that contains the value I am looking for? -- Dave Peterson ...
Re: limit numbers of connections to one server
hi there :-) my pop3 server is limited to 10 query per sec. and per ip. i have abou 16 mail-accounts on this server. the last 6 allways error with timeou or something. is there a way to limit the number of connections to one server i outlook 2002 on windows xp pro? thanks a lo - jazzy_ ----------------------------------------------------------------------- Posted via http://www.mcse.m ----------------------------------------------------------------------- View this thread: http://www.mcse.ms/message674073.htm Set your send/receive settings to consecutive mail checks, rather than conc...
Macro Question #10
Hi, I am working with a text file that I imported into Excel. It is a transactional report of sales by customer. The data will have the customer number and name spread out over three cells. What I want to do is to create a macro that will contatenate all three cell and then perform a paste special and paste them into another cell in another column. Since the number of transactions by customer can vary the customer name and number can appear anywhere on the page. I created a macro to do this using the first customer which appears in cell B5 through D5. The next customer appears...
question about leaving messages on server
My husband and I have 1 POP mail account. I am accessing it from a computer in Virginia, where I'm staying with relatives. He is accessing the same account from California. I have my Outlook set up to keep messages on the server, but to delete them after 1 day (so that he will still get the messages, but the server won't get clogged). His email program, Eudora, is set up so the messages will be deleted from the server after he downloads them. Is there a chance I won't get some messages because he has his computer set up that way? (He downloads it 1st, then it gets deleted off serv...
I have 3 accounts at one bank. I have 3 corresponding accounts set up in MS Money 2007. One of them is setup for online banking while the other two are not. I now want to set the other two up for online banking but I can't find a way to specify the unique login info for each of the other two accounts. ...
Access 97 Runtime question
We are using Access 97 runtime for some of our staff. I noticed today that in reports if they right mouse click, they don't get a shortcut menu. I want them to be able to Export the report they are viewing. Would Access 2003 runtime have the shortcut menu? Thanks Kelvin "Kelvin Beaton" <kelvin dot beaton at mccsa dot c o m> wrote in message news:uiQA0i7zHHA.1168@TK2MSFTNGP02.phx.gbl... > We are using Access 97 runtime for some of our staff. > I noticed today that in reports if they right mouse click, they don't get > a shortcut menu. I want them to be...
Optimiztion question
I was looking at MSDN on optimizing queries (http://msdn.microsoft.com/en-us/library/ms998577.aspx) and am unclear as to why a foreign key relationship affects the query in this case. At the beginning of the article it gives an example and starts out by saying: The sample screen shot in Figure 14.2 shows an execution plan that accesses only one table, although two tables are included in a join in the query. Because there is a declared foreign key relationship between the authors table and the titleauthor table, and the au_id column in the titleauthor table is not allowed to b...
Multiple Domain e-mail addresses
We are running Exchange Server 2003 Enterprise addition and I am having a bit of a "brain-freeze" at the moment... Where in the Exchange Admin do I configure the server to accept e-mail from more than one domain. For example, we currently accept e-mail from mycurrentdomain.ca and would also like to accept email from mycurrentdomain.com. Please note that I have updated all of our DNS MX records as required, just need to make the changes on the Exchange server. Thanks in advance... Recipient polices-email address policy. "Raymond Spitzingle" <ray(nospam)@stuff...
How do I merge two publisher files?
I am using publisher 2003. I am creating an 80 page catalog. I like to save page 1-10 as file one, pages 11-20 as file two and so on. When I am finished with my catalog I need to send one file to the printer. How can I merge all of my pages together in one file? Copy and paste. Or if you have Acrobat (not just the free Reader) you can create a single .pdf file with the parts. -- JoAnn Paules MVP Microsoft [Publisher] "screnda" <screnda@discussions.microsoft.com> wrote in message news:CF96E50B-CBC8-4A5A-A854-D7EE130CE9AD@microsoft.com... >I am using publisher 200...
Using two conditions in a formula
How do I write the following formula: I am in cell I6 If g6 AND h6 is blank, then blank, else I5 minus g6 plus h -- Richard Pit ----------------------------------------------------------------------- Richard Pitt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1533 View this thread: http://www.excelforum.com/showthread.php?threadid=27042 Richard, In cell I6, enter the formula: =IF(AND(G6="",H6=""),"",I5-G6-H6) Though you don't check for case when G6 is blank and H6 isn't, etc. HTH, Bernie MS Excel MVP "Richard ...
Macros/Signatures Question
I have an Excel Workbook that I created for a PC Order Form. I set it up to only make certain rows visible based on the Machine Model that they choose. I digital signed the Worksheets and exported the Digital Signature Certificate and installed it on the User’s PCs. The code works great. The user opens the Workbook and it runs the Macros with no problem. The problem I have is when the user goes to save the Workbook. They get an error that “Excel can not sign VBA macros when saving to this file format. Do you want to remove the digital signature and continue saving this workbook?”...
Windows and Mac have two distinctly different units for column width.
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I am trying to format columns for some data I am entering in a spreadsheet and when I enter "15.00", which is the required width for these columns given by my professor, I end up with a column 15 inches wide. What I would prefer is for the options to be like the default options in Windows version of Excel. In Windows version of Excel, when you hover over the lines between the columns it gives you two numbers (e.g. 8.43 (64 pixels)). These are the default numbers for column width in Windows Excel....
I cannot paste from one workbook to another. Copy works, paste do.
When I attempt to copy from one workbook and paste into another, copy appears to work but paste does not. The paste menu item is grayed out in the workbook to which I attempt to paste. Are there setting that can be changed to aloow the paste?? Check to see if either workbook and/or worksheet is protected. If so, unprotect. Then Copy/Paste should work. BTW, how are you copy?paste(ing) Tab or content? Dennis "JimmyMc" wrote: > When I attempt to copy from one workbook and paste into another, copy appears > to work but paste does not. The paste menu item is grayed out...
Simple IMAP question
Hi, How do I enable shared calendar with free/busy information through IMAP ? When I add the "calendar" folder in IMAP it displays as a mail folder, not a calendar. Pierrot Is this calendar a mailbox or public folder? Why are you using IMAP instead of MAPI? MAPI is much more feature complete as it applies to this sort of thing. -- Ed Crowley MVP - Exchange "Protecting the world from PSTs and brick backups!" "Pierrot Robert" <mcthepro@nospam.hotmail.com> wrote in message news:%23NzXwrV6GHA.4352@TK2MSFTNGP05.phx.gbl... > Hi, > > How do I...
Exchange 2003 Question??
Dear all, I would like to know if there is an upgrade path from Exchange 2003 Standard Edition with SA to Exchange 2003 Enterprise Edition with SA? Thank you. Regards, Kueh. This might help http://support.microsoft.com/default.aspx?scid=kb;en-us;170280 -- Santhosh Sivarajan MCSE(W2K/NT4),MCSA(W2K3/W2K/MSG),CCNA,Network+ "KA Kueh" <kka@ksm.com.my> wrote in message news:exVKwgOKEHA.1040@TK2MSFTNGP10.phx.gbl... > Dear all, > > I would like to know if there is an upgrade path from Exchange 2003 Standard > Edition with SA to Exchange 2003 Enterprise Edition wit...
Unable to delete the Dead Domain controller
Dear, Iam working on windows server 2008 Ent Ed I have two doman controllers in the domain both are GC but only one domain controller has all the fsmo roles but iam having replicattion problems with the dead DC (i.e mppkw-database) and Iam unable to delete or remove the dead domain controller from the domain and iam having follwing problems using the ntdsutil :- matadata cleanup select operation target: list domains Found 1 domain(s) 0 - DC=mediaphoneplus,DC=com select operation target: select domain 0 No current site Domain - DC=mediaphoneplus,DC=com No current server N...
Exchange error
Hello, for one week now, my exchange 2000 server crashes nearly every night at random time, the only solution to have it all restart is to restart the entire server. In the application log, multiple error events are reported like these : Event Type: Error Event Source: Userenv Event Category: None Event ID: 1000 Date: 26/07/2005 Time: 01:27:39 User: NT AUTHORITY\SYSTEM Computer: BELLINI Description: Windows cannot establish a connection to *domain name* with (1364). Event Type: Error Event Source: Userenv Event Category: None Event ID: 1000 Date: 26/07/2005 Time: 01:37:41 User: ...
IDN/ACE domains
Hello, Does anyone know if it's possible to have ACE/IDN domains in Exchange 2003 ? I want to have a domainname with norwegian characters in exchange but I doesn't allow me to type norwegian characters in the email-tab in active directory users and computers. Any ideas anyone ? Third party plugin ? Kindest regards, Rikard Strand ...
Combine small documents into one master document
Hi, I currently have an "engagement letter" that is created for our clients to set the expectations for our business relationship (I work for attorneys). We have about 10 different paragraphs that may be inserted into the letter based on different factors (3rd party payor, if a retainer is required, etc.). So I start with the basic letter and then have a userform with checkboxes where you can select the text block options (stored in Autotext). When you click OK the various paragraphs are inserted at bookmarks. While this works, I find working with Autotext cumber...
out side domains
I can not send emails to persons that do not use the same domain ISP. I recieve this message when i try to our message did not reach some or all of the intended recipients. Subject: Sent: 18/04/2004 8:43 PM The following recipient(s) could not be reached: someone@somewhere.com.au on 18/04/2004 8:44 PM 550 5.7.1 <someone@somewhere.com.au>... Relaying denied. IP name possibly forged [203.134.100.118] Has anyone got any ideas Thanks Brad .. Have you set your server settings to authenticate before sending? --� Milly Staples [MVP - Outlook] Post...
Filter two columns with criterion applying to one or the other?
Hi, I am looking for a solution to the following filtering problem: I have two adjacent columns, so using a filter for both of them is no problem. But what I want to do and don't know how to do is this: I want to filter for values greater than x (a certain number, in my case 5000) in any of the two columns. I can filter both columns for x greater than 5000 but that filters out more than I want because there may be some cells with a value greater than 5000 in only one of the two columns. Is there a solution to this problem (using Excel alone or an add-on)? Peter Hi Peter you can use th...
Excel2000: Strange behaviour for one cell in workbook
Hi The situation: There is a Excel workbook used for registering working time in firm departments, created earlier. The worksheets are protected, and I don't have the password, as author isn't working here anymore. The workbook is stored as read-only on network resource, and monthly every department is copying it to local computer and filling the table. The table's body has 2 rows data for every employee with 31 columns for month's dates, and several protected summary columns. For every date, working hours or some code string is entered into according cell. One of codes, and ...
Vlookup, multiple times in one column summing corresponding
I have a list that contains common invoice numbers that appear multipl times in column A and need to use the vlookup function to find and su the corresponding amounts in column B. As you would be aware the following vlookup functio =VLOOKUP(A3,DATA,2,FALSE) will only return the one amount once i reaches a match and I need it to continue down the column and sum al matching invoice numbers. Column A Column B 145768 356.87 145769 678.90 145880 80.87 * 145769 103.55 145770 56.90 145769 78.32 145880 54.09 * The answer I�m looking to return is 145880 134.96 It has to be a vlookup sty...
using domain account for Exch2003 services
In Chapter 3 of the MS Press Training Kit "Implementing and Managing Microsoft Exchange Server 2003", there are instructions for changing the Exchange Services to run under a domain account (with appropriate group memberships and rights) rather than the default Local System account for security & auditing purposes. However, I could not start the services after making the change and reviewed several articles stating that only the Local System account will work - KB Articles 271920, 239762, etc. Is the training kit wrong, or is there a way to do this? thanks in advance, Art ...
One front-end server multiple back-end servers
Hi, I was wondering if someone could help with the following scenerio and make some suggestions as to an answer. We have 3 exchange AG groups. 1 AG group has 3 exchange servers in it, each located in it's own AD domain. 1 AG group has one exchange server in it, it's in its own AD domain. Thirdly, the last AG group has 2 exchange servers in it, both are in the same AD domain. 1 of these 2 exchange servers in the final AG mentioned is a front-end server, that should be supporting all the exchange back-end servers. The problem we are facing is that when a user from any of the ...
Filtering question
Is there a way to expand the filter option so that it shows 1 row (or more), both above and below any row that contains the value I am looking for? Data|filter|autofilter examines each cell/row on its own. Maybe you can put the key value for each group on the rows you want. Then filter by that column. richzip wrote: > > Is there a way to expand the filter option so that it shows 1 row (or more), > both above and below any row that contains the value I am looking for? -- Dave Peterson ...
Re: limit numbers of connections to one server
hi there :-) my pop3 server is limited to 10 query per sec. and per ip. i have abou 16 mail-accounts on this server. the last 6 allways error with timeou or something. is there a way to limit the number of connections to one server i outlook 2002 on windows xp pro? thanks a lo - jazzy_ ----------------------------------------------------------------------- Posted via http://www.mcse.m ----------------------------------------------------------------------- View this thread: http://www.mcse.ms/message674073.htm Set your send/receive settings to consecutive mail checks, rather than conc...
Macro Question #10
Hi, I am working with a text file that I imported into Excel. It is a transactional report of sales by customer. The data will have the customer number and name spread out over three cells. What I want to do is to create a macro that will contatenate all three cell and then perform a paste special and paste them into another cell in another column. Since the number of transactions by customer can vary the customer name and number can appear anywhere on the page. I created a macro to do this using the first customer which appears in cell B5 through D5. The next customer appears...
question about leaving messages on server
My husband and I have 1 POP mail account. I am accessing it from a computer in Virginia, where I'm staying with relatives. He is accessing the same account from California. I have my Outlook set up to keep messages on the server, but to delete them after 1 day (so that he will still get the messages, but the server won't get clogged). His email program, Eudora, is set up so the messages will be deleted from the server after he downloads them. Is there a chance I won't get some messages because he has his computer set up that way? (He downloads it 1st, then it gets deleted off serv...