=?Utf-8?Q?E-mails_disappearing_after_hitti?= =?Utf-8?Q?ng_Comcast=E2=80=99s_mail_server=28s=29_-_OP?= =?Utf-8?Q?MLOG.LOG_question?=

Hello,

Outgoing emails from Outlook 2007 intermittently do not reach their 
recipients. I'm no email expert, but based on my OPMLOG.LOG file, Outlook 
seems to successfully send the message to Comcast's mail servers using SMTP. 
I'm having a really hard time convincing Comcast to look into this and they 
keep pointing fingers back at Outlook. I do not believe Outlook is at fault 
and I strongly doubt that the problem is with the recipients ISPs, as none 
of them gets the problematic emails and they are on different domains 
(aol.com, microsoft.com, hotmail.com). The emails show up in my sent folder, 
there are no bounced messages and my outbox is empty. Also, typically, if I 
resend the email, it makes it the second time. I suspect the emails are 
being deleted/filtered out by Comcast's mail servers. So first off, I'd like 
to have someone confirm that, based on my log file below, the email really 
did successfully leave my client. I've also looked at a netmon trace of 
this, and see no transport issues.

2007.03.23 13:31:52 hans.ravnaas@comcast.net: Synch operation started (flags 
= 00000001)
2007.03.23 13:31:52 hans.ravnaas@comcast.net: UploadItems: 1 messages to 
send
2007.03.23 13:31:52 SMTP (smtp.comcast.net): Begin execution
2007.03.23 13:31:52 SMTP (smtp.comcast.net): Port: 587, Secure: TLS, SPA: 
yes
2007.03.23 13:31:52 SMTP (smtp.comcast.net): Finding host
2007.03.23 13:31:52 SMTP (smtp.comcast.net): Connecting to host
2007.03.23 13:31:52 SMTP (smtp.comcast.net): Connected to host
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 220 comcast.net - 
Maillennium ESMTP/MULTIBOX sccrmhc14 #10
2007.03.23 13:31:53 SMTP (smtp.comcast.net): [tx] EHLO HKDC
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-comcast.net
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-7BIT
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-8BITMIME
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-AUTH CRAM-MD5 LOGIN 
PLAIN
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-DSN
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-HELP
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-NOOP
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-PIPELINING
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-SIZE 15728640
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-STARTTLS
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-VERS V05.21c++
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250 XMVP 2
2007.03.23 13:31:53 SMTP (smtp.comcast.net): Securing connection
2007.03.23 13:31:53 SMTP (smtp.comcast.net): [tx] STARTTLS
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 220 ready to start TLS
2007.03.23 13:31:53 SMTP (smtp.comcast.net): Securing connection
2007.03.23 13:31:53 SMTP (smtp.comcast.net): Connected to host
2007.03.23 13:31:53 SMTP (smtp.comcast.net): [tx] EHLO HKDC
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-comcast.net
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-7BIT
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-8BITMIME
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-AUTH CRAM-MD5 LOGIN 
PLAIN
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-DSN
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-HELP
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-NOOP
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-PIPELINING
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-SIZE 15728640
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-STARTTLS
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250-VERS V05.21c++
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250 XMVP 2
2007.03.23 13:31:53 SMTP (smtp.comcast.net): Authorizing to server
2007.03.23 13:31:53 SMTP (smtp.comcast.net): [tx] AUTH LOGIN
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 334 VXNlcm5hbWU6
2007.03.23 13:31:53 SMTP (smtp.comcast.net): [tx] aGFucy5yYXZuYWFz
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 334 UGFzc3dvcmQ6
2007.03.23 13:31:53 SMTP (smtp.comcast.net): [tx] *****
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 235 Authentication 
successful
2007.03.23 13:31:53 SMTP (smtp.comcast.net): Authorized to host
2007.03.23 13:31:53 SMTP (smtp.comcast.net): Connected to host
2007.03.23 13:31:53 SMTP (smtp.comcast.net): [tx] MAIL FROM: <*****>
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250 ok
2007.03.23 13:31:53 SMTP (smtp.comcast.net): [tx] RCPT TO: <*****>
2007.03.23 13:31:53 SMTP (smtp.comcast.net): <rx> 250 ok; [simple] forward 
to <*****>
2007.03.23 13:31:53 SMTP (smtp.comcast.net): [tx] DATA
2007.03.23 13:31:54 SMTP (smtp.comcast.net): <rx> 354 ok
2007.03.23 13:31:54 SMTP (smtp.comcast.net): [tx]
..
2007.03.23 13:31:54 SMTP (smtp.comcast.net): <rx> 250 ok ; 
id=20070323203209014004p0gle
2007.03.23 13:31:54 SMTP (smtp.comcast.net): End execution
2007.03.23 13:31:54 hans.ravnaas@comcast.net: ReportStatus: RSF_COMPLETED, 
hr = 0x00000000
2007.03.23 13:31:54 hans.ravnaas@comcast.net: Synch operation completed


Thanks in advance
Hans


0
3/25/2007 1:46:42 AM
outlook 87535 articles. 11 followers. Follow

3 Replies
454 Views

Similar Articles

[PageSpeed] 32

Hans Ravnaas wrote:
> So first off, I'd like to have someone confirm that, based
> on my log file below, the email really did successfully leave my
> client. I've also looked at a netmon trace of this, and see no
> transport issues.

Yes, based on the log, the message was successfully accepted by Comcast. 
However, keep in mind, it could have lost its way in many more places than 
just Comcast.

I would personally tell the Comcast support person that you have a network 
packet trace showing their server accepting the message and that you would 
like to speak to a second level support technician if they are not able to 
help you with the problem.  But, again, it may not be their problem.  If you 
can readily reproduce the problem (ie, a certain message always disappears) 
then they should be able to see the message come and, theoretically, go out.

-- 
f.h. 


0
f.h.muffman (751)
3/25/2007 1:56:23 AM
Thanks for the quick reply. I am working on getting a second level support 
person engaged. I don't know what kind of mail servers they are using, but 
I'm hoping they are able to look at server logs to first determine if the 
message was received by their servers or not. I'm wondering if some server 
mail filter is deleting the messages? I can't repro the problem at will and 
it happens with random messages, but I can usually repro it with a couple 
emails per day. Again, I still suspect Comcast, because when an email gets 
lost, 100% of the recipients do not receive it. I would really like to find 
out once and for all if the message really leave their server. I suspect 
not. Come to think of it, I should also point out that if I'm on the to or 
cc line of the problematic message, I don't even get it, even though it was 
sent to myself. I believe this eliminates other devices between the Comcast 
servers and the recipients.

Hans

"F.H. Muffman" <f.h.muffman@hotmail.com> wrote in message 
news:OqAelDobHHA.260@TK2MSFTNGP02.phx.gbl...
> Hans Ravnaas wrote:
>> So first off, I'd like to have someone confirm that, based
>> on my log file below, the email really did successfully leave my
>> client. I've also looked at a netmon trace of this, and see no
>> transport issues.
>
> Yes, based on the log, the message was successfully accepted by Comcast. 
> However, keep in mind, it could have lost its way in many more places than 
> just Comcast.
>
> I would personally tell the Comcast support person that you have a network 
> packet trace showing their server accepting the message and that you would 
> like to speak to a second level support technician if they are not able to 
> help you with the problem.  But, again, it may not be their problem.  If 
> you can readily reproduce the problem (ie, a certain message always 
> disappears) then they should be able to see the message come and, 
> theoretically, go out.
>
> -- 
> f.h.
> 

0
3/25/2007 5:32:19 AM
What is the limit on the number of recipients that Comcast will permit. Many 
ISPs restrict the number to 50. Some ISPs have a different set for those 
with fixed IP addresses and a commercial account. Specifically, mine will 
allow 300 during the day and 1,000 after 11:00 p.m.
"Hans Ravnaas" <hans.ravnaas@comcast.net> wrote in message 
news:eTZLF8pbHHA.4544@TK2MSFTNGP03.phx.gbl...
> Thanks for the quick reply. I am working on getting a second level support 
> person engaged. I don't know what kind of mail servers they are using, but 
> I'm hoping they are able to look at server logs to first determine if the 
> message was received by their servers or not. I'm wondering if some server 
> mail filter is deleting the messages? I can't repro the problem at will 
> and it happens with random messages, but I can usually repro it with a 
> couple emails per day. Again, I still suspect Comcast, because when an 
> email gets lost, 100% of the recipients do not receive it. I would really 
> like to find out once and for all if the message really leave their 
> server. I suspect not. Come to think of it, I should also point out that 
> if I'm on the to or cc line of the problematic message, I don't even get 
> it, even though it was sent to myself. I believe this eliminates other 
> devices between the Comcast servers and the recipients.
>
> Hans
>
> "F.H. Muffman" <f.h.muffman@hotmail.com> wrote in message 
> news:OqAelDobHHA.260@TK2MSFTNGP02.phx.gbl...
>> Hans Ravnaas wrote:
>>> So first off, I'd like to have someone confirm that, based
>>> on my log file below, the email really did successfully leave my
>>> client. I've also looked at a netmon trace of this, and see no
>>> transport issues.
>>
>> Yes, based on the log, the message was successfully accepted by Comcast. 
>> However, keep in mind, it could have lost its way in many more places 
>> than just Comcast.
>>
>> I would personally tell the Comcast support person that you have a 
>> network packet trace showing their server accepting the message and that 
>> you would like to speak to a second level support technician if they are 
>> not able to help you with the problem.  But, again, it may not be their 
>> problem.  If you can readily reproduce the problem (ie, a certain message 
>> always disappears) then they should be able to see the message come and, 
>> theoretically, go out.
>>
>> -- 
>> f.h.
>>
> 


0
Chuck
3/25/2007 1:46:38 PM
Reply:

Similar Artilces:

Exchange 2003 OWA #8
Hi, please help me if I did any wrong seeting up the OWA to point to the default web site so that I do not have to type on my browser mail.mydomain.com\exchnage instade of mail.mydomain.com. Here is the step I took, Right click default web site -- Home directory -- clicked A redirection to a URL and redirect to http://mail.mydomain.com -- the client will be sent to -- A directory below URL entered. After all this I still type EXCHANGE after the URL. Please how I remove that Exchange from the URL. Thank you, Did you restart IIS? James Chong MCSE |M+, S+, MCTS, Security+ msexchangetips....

Convert ANSI to UTF-8?
Hi, I have some legacy code that saves a file to ANSI, (using FILE* fp; fopen( &fp, ..., "w"); fwrite(...)) I am writing 'char*' to the file, (not wchar). The file is saved as ANSI, a third party application uses the file, but one of their new requirement is that the file be UTF-8. Is there a way of saving my file so it is UTF-8? My application uses _UNICODE apart from that file saving class. I don't mind changing all the chars to wchars but I am not sure that it will change the format of the file, (not the way I understand UTF-8 anyway). Many thanks. Regards...

80 quiz lyrics spreadsheet
Apologies if this is not the correct forum for this thread. Sat in bar over the weekend, my pals and I were discussing the 80s lyric spreadsheet that did the rounds a couple of years ago. We all agree that the quiz was challenging, entertaining & frustrating. Frustrating? Yep, because none of us had ever seen a version of th spreadsheet with the answers. Wonder if anyone out there in ExcelTi land can help? Regards. Mark :cool -- mday3 Perpetual traveller - enjoying lif ----------------------------------------------------------------------- mday36's Profile: http://www.excelfo...

Problem E-Mail
Received a e-mail that when I click on to open shuts my computer down.I have Outlook Express 6 on Windows 98SE. How do I delete this e-mail as my Anti- virus program does not see it? This Newsgroup addresses issue regarding MS Office Outlook. Post your question to the Outlook Express/Internet Explorer newsgroup/ "Steve K" <Steve K@discussions.microsoft.com> wrote in message news:AA34292D-47BD-4EFD-871A-DAE6CD5B8092@microsoft.com... > Received a e-mail that when I click on to open shuts my computer down.I > have > Outlook Express 6 on Windows 98SE. How do I delete...

Forwarding e-mail
Hello, Scenario: Windows 2000 SP4 Network With AD and Exchange 2000 SP3. We have Shops acessing our e-mail system using pop3. We don't allow relay, so since they connect from outside our domain/network, they can only send mail to our network. We pretend them to send e-mail to some specific addresses, but we don't want their name to show...something like this: SHOP A --------> OUR NETWORK ---------> OUTSIDE ADDRESS (AS MYCOMPANY) I've tried using a public folder, the shop sents the e-mail to the PF then with a rule we forward it to the destination, but it appears in ...

How can you change to a different "skin" in Excel (e.g. blue)
I'm trying to change the general appearance of Excel (not the cells, not which buttons appear on the toolbars) just the overall appearance of Excel. Something like what would be called a "skin" in other applications. You can hide/show lots of things by using: tools|options|view tab And making choices there. I'm not sure you're going to find anything like skins in excel. haabs wrote: > > I'm trying to change the general appearance of Excel (not the cells, not > which buttons appear on the toolbars) just the overall appearance of Excel. > Something l...

Advanced E-mail options
I can't find anything googling for this so can anybody point me at a help source. When sending a message, if I select "Set Importance" or "Set Sensitivity" from the "Advanced E-mail Options" dialog, what do the categories mean and what do they do? For example what is the difference between "Private" and "Confidential" and what different effects do they have? Thanks -- (\__/) (='.'=) (")_(") I'll answer 1/2 about the importance function. If you set as High, the recipient gets a red exclamation mark in a c...

Rule Related Q....
I want to set a rule as follows. When I get an email from a person of interest viz xxx@xxx.com, I want to send one email to my yahoo email Id stating that 'm' from 'xxx'. How to do that? I can see the rule to farward the email message and not sure on how to send email as like notification. Is it possible to set the above rule? I am using Microsoft outlook 2002. Thanks, Hanuman I don't think you can send a separate email other than forwarding. "Hanuman Mishra" <Mishra_Hanuman@rediffmail.com> wrote in message news:e4V9ahtaFHA.2536@TK2MSFTNGP10.phx.gbl... ...

How can I read/open my new e-mails?
Suddenly I cannot open unread e-mails in my inbox; there are stored ones in there from over a year ago but no new ones. I have Outlook as my priority e-mail account so its not that reason. Any ideas? Try recreating your profile: http://www.howto-outlook.com/faq/newprofile.htm Make sure you associate it with the correct PST file. The default name is outlook.pst, unless it has been deliberately changed to something else. -- Kathleen Orland - MVP Outlook Outlook Tips: http://www.outlook-tips.net/ http://www.howto-outlook.com/ "Heather" wrote: > Suddenly I cannot ope...

"unable to opne your default e mail address"
I am gettting message saying "unable to open your default e mail address" whenever I try to open out look. How to get rid of this? Might try going thru the Mail applet in the control panel to remove/add/edit your e-mail account settings. "Soumitra" <Soumitra@discussions.microsoft.com> wrote in message news:AB10E0BA-0557-4527-87FD-4CE7CA267739@microsoft.com... I am gettting message saying "unable to open your default e mail address" whenever I try to open out look. How to get rid of this? "Soumitra" <Soumitra@discussions.microsoft.com>...

=?Utf-8?Q?VS2005=2C_Cant_find_Window_=E2=80=9CSales_?= =?Utf-8?Q?Payment_Document_Remittance=E2=80=9D?=
Dear all I am working with VS2005, C#, Developer toolkit for GP10 I am looking for a window “Sales Payment Document Remittance” From GP menu: Transaction Sales Payment Document Remittance The physical name: “rvlrmPmntDocRemittance” I problem is I cannot find it this window at all in Dynamics.Forms. Please advise me what to do. ...

Outlook express in XP with IE 6
My wife had an XP IE6 computer with Outlook Express. Well, I got her a new computer with IE 8 and Windows 7 but now she can't access her emails. Any help would be much appreciated. Ricku\y wrote: > My wife had an XP IE6 computer with Outlook Express. Well, I got her a new > computer with IE 8 and Windows 7 but now she can't access her emails. Any > help would be much appreciated. Windows 7 doesn't include an e-mail client. You'll have to pick one and install it. When it was supported, OE came bundled with IE. OE has long been unsupported. It...

OWA #80
We are currently exploring the idea of going to OWA to allow users to check mail from home. Our concern is that we don't want to expose our main system to the outside world. My thought is correct me if I'm wrong here but we could setup another exchange server as a front end server. How would one do this? Would this require an addition licenses for the OS and Exchange? Would we need to buy additional CAL's for OWA? Do you know any good resources that would instruct on how to do this The front-end server doesn't improve security a whole lot, but it's especially ...

Restricting Inbound/Outbound E-mail per user
We're running Exchange 2003 server. Is there anyway to restrict a user so they can only e-mail internally, and not send/received external e-mails? Thanks, Andrew Uses an SMTP connector to control outbound restrictions (prohibit send), and only give the user a private address such as user@domain.local. Nue "Andrew Smith" <newsgroups@americanrocksalt.com> wrote in message news:O83fYwPdGHA.3840@TK2MSFTNGP04.phx.gbl... > We're running Exchange 2003 server. Is there anyway to restrict a user so > they can only e-mail internally, and not send/received exter...

Saving Outlook E-Mail Attachment #2
You can browse but it will not let you change folders. You can see all the available folders when you browse but you cannot get to them. Has anyone seen this problem before? "you browse but you cannot get to them" This doesn't make much sense to me as browsing is walking through the folders. Also you forgot to mention your version of Outlook -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -What do the Outlook Icons Mean? -Create an Office 2003 CD slipstreamed with Service Pack 1 ----- "Bonnie" <anonymous@discussions.microsoft.co...

Clear Junk E-mail Folder
It seems that rule cannot be set to remove messages from Junk E-mail Folder on exit Outlook. Is there any way to do that? Thanks. I'm using OL2003. ...

Canadian Payroll 8 to 9
Hi, I upgraded one of my client from 8 to 9 and now they are getting error message while running their canadian payroll batches get/change error number of results columns does not match table definition. please advise thanks syed I found some information on the below link; check it out to see if it can assist you. https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYYUSKWOTVUNVLMRYSVUKKZKQSYMKOMXZSOMQOVXWNTTKXKXLO Hope this helps, rc "Syed" wrote: > Hi, > > I upgraded one of my client from 8 to 9 > and now they are getting error message w...

Controls Theme in MFC Dialogs (VC7.1 and 8.0)
Hi All, I make one application by VC wizard MDI and Dialog APP, both in VC7.1 and 8. The controls in thease apps don't have WINXP style. Why? How I enbed XP style in buttons, edits etc.. Thanks have a look at the link below..... http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnwxp/html/xptheming.asp Hi, Welcome to MSDN Newsgroup! Making controls XP style is even easier. You don't actually have to do anything because the OS is responsible for drawing the button and if you are running the program on XP then XP will draw it in the XP style. However, there is...

Unable to add Internet e-mail #3
Outlook 2000 (CW) When adding a new profile OR trying to add internet e-mail to a current profile I can add the Internet E-mail service but I cannot view/add the SMTP, POP3 properties, etc. When I press the Properties button, nothing happens. Any help here? -- Mike Sommers Have you tried Detect and Repair? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the SWEN virus, all mail sent to my personal account will be deleted without reading. After searching google.groups.com and finding no answer, Mike Sommers asked: | Outlook 2000...

e-mail addresses
While entering the membership information in my excel page, I entered the person's e-mail address, sometimes it goes in the same color as the rest of the document and other times it goes in BLUE. I would just like it to be all the same color and not in blue. What can I do to change this from occurring? Many thanks Donna "Donna" <djs@cogeco.ca> wrote: >While entering the membership information in my excel page, I entered the >person's e-mail address, sometimes it goes in the same color as the rest of >the document and other times it goes in BLUE. I wo...

E-Mail Addresses to New Computer..?
Hi.., how does one transfer e-mail addresses from one laptop computer to a new laptop. I'm using Outlook Express on both..!! Thanks..!! Mike Harding, you wrote on Sat, 10 Mar 2007 17:08:08 GMT: > Hi.., how does one transfer e-mail addresses from one laptop computer to a > new laptop. I'm using Outlook Express on both..!! Thanks..!! Search for a *.wab (it's your addressbook) file on the old computer. Copy it on your new one and import the addressbook: File | Import | Addressbook -- Best Regards Christian Goeller http://www.outlookfaq.net Mike Harding <rest...

Recipients Receive Duplicates of My e-mails randomly
At times, specifically when I am accessing Exchange via SSL VPN, recipients of my e-mails will randomly receive duplicate or double copies of the same e-mail. What could be causing this occurance Don't you ever get doubles of EVERYTHING from a flash synchronization with your Exchange Server. A few minutes later, if you do an F5 it prunes your inbox down to 1 copy per msg. You might ask your friends if it's only YOUR messages. If so, could you be hitting Ctrl+M or clicking [SEND] a little heavy-handedly. I'd gather some intel on who else in your WAB is experiencing the same...

Outbound E-mail Suffix CRM:xxxxxxxx
Hi everyone, How do I get rid of the tracking suffix CRM:xxxxxx from all of the outbound e-mails ? Is there any workflow issue if this tracking number is not attached in outbound e-mails ? I don't believe it makes a good impression if the cusomters receive e-mails with tracking info attached hence we want to get rid of this. Thanks in advance for any suggestions, You can get rid of the E-mail suffix CRM:xxxxxxx by following these instructions: Use an account such as systems administrator who has the correct privileges to access organizational settings. 1. At the bottom of the n...

8 Bytes support in scroll functions
Hi, GetScrollPos and SetScrollRange takes int as input and return an int value. Can we use __int64 in these functions. like __int64 GetScrollPos( HWND hWnd, int nBar );BOOL SetScrollRange( HWND hWnd, int nBar, int nMinPos, __int64 nMaxPos, BOOL bRedraw );can we make these function like this At the moment, no. Why? If you need more than 32 bits of range, rethink what you are doing. If you could add a new element every microsecond, it would take you nearly 72 hours to fill the control. If you just want a scrollbar to select a value, recall that the...

what formula do i put for column m = column k minus column l in e.
what formula do i put for column m = column k minus column i have tried to do it by put the curser on the colmn so it highlightes all the fields but this results in having the answer in row m1 and doesnt update all the rows. "jenniss" wrote: > what formula do i put for column m = column K minus column L > > i have tried to do it by put the curser on the colmn so it highlightes all > the fields but this results in having the answer in row m1 and doesnt update > all the rows. try =SUMPRODUCT((E1:E21-F1:F21)) or =SUM(E:E)-SUM(F:F) -- Don Guillett SalesAid So...