I have a marketing list that contains more than one person from a company
(for some companies). I want to be able to remove the duplicates based on
title. Example: I want to be able to filter the list so if there is a CIO,
CFO and CEO I want the CIO and remove the CFO and CEO. If no CIO then keep
the CFO and remove the CEO. If no CIO or CFO then keep the CEO. The key is I
want the list to have one person per company but not exclude any companies.
I am pulling the list from Leads. Does anyone know if this is possible in
...Access 2000 to 2003 upgrade = recordset is not updatable
Tested moving application in Access 2000 to Access 2003
Access 2000 - Office XP on Windows XP
Access 2003 - Office 2003 on Windows 2003 Enterprise Server
Application first written in Access2.
Upgraded to Access 95.
Upgraded to Access 97.
Upgraded to Access 2000.
Additional objects added throughout the upgrades.
Existing objects modified.
Issues created from previous upgrades identified and resolved.
The data tables are in a separate mdb file located on a file server.
All other objects are in a second mdb file distributed to multiple desktops.
Tested upgrading to Access 2003.
This resulted ...Outlook Tempremental When Connecting!
Has anyone experienced this problem before...
When I try and connect to get new email, Outlook keeps making the
password and username box pop-up, even though it is on the setting to
It often does this for me, and even if you type the correct password
it keeps popping up over and over.
I run PopFile, but it always did this before I had PopFile anyway. It
seems to be some sort of bug with the program.
Sometimes if you go into the account setting and re-enter the
password, and then go back and connect it will do it, but other times
you have to completely exit the program...Exchange 2000/2003 coexistence problem
I stuck while Exchange 2003 configuration.
My environment is old Exchange 2000 on Windows 2000 Server and new Exchange
2003 on Windows 2003 Server. Both in 2000 domain. Both in one routing group.
All mailboxes are on the old server.
My goal is to move some mailboxes to the new one. I had done it with one
mailbox to check it worked good. Unfortunately - I am not able to send mails
from this mailbox, neither send to it. All messages wait in same queues on
both servers. On old server is queue with messages to new one and
vice-versa. The messages are not routed. The queue descripti...Remove Duplicates
How can you remove filter records which are the same in 3 to 4 columns only
the ones that have in all 3 columns same wording
> How can you remove filter records which are the same in 3 to 4 columns only
> the ones that have in all 3 columns same wording
Assume the 3 cols are cols C to E
In F2, copied down: =SUMPRODUCT(--MATCH(C2:E2,C2:E2,0))=3
Then apply n autofilter for TRUE in F1, delete these filtered rows
please explain more detailed
also if we don't want todelete only copy the filte...Calendaring and Scheduling woes
We have an exchange 2003 server that services a single domain. When people
try to schedule meetings they go to new meeting, open up the scheduling tab,
and types in the person's name, they don't get their calendar. If they type
in the person shortname, they do get the proper calendar. Also, if they try
to look up the person in an address list, they have to make sure that they
select all users and choose the person, because if they select it from
outlook contacts or another shared contact list it will be the persons name
but once again there will be no calendar. It is as if t...Cannot import data from outlook express into outlook. Help?!
My version of outlook only offers me the choice of importing from O.Express
4.x or 5. I have O.Express 6.0 and wonder if there is some patch that I need
to download in order to update my Outlook programme or am I fighting a losing
OL2003 allows for importing from OE 6.x. Not sure about OL2002.
"Seahorse" <Seahorse@discussions.microsoft.com> wrote in message
> My version of outlook only offers me the choice of importing from
> 4.x or 5. I have O.Express 6.0 and wonder if there is some ...Remove commas at end of line only
I have a column which contains part of an address eg.
"Honeyhouse, High Street,"
Is it possible to remove the comma at the end of the line but not the other comma?
for each c in selection
"Mark" <firstname.lastname@example.org> wrote in message
> I have a column which contains part of an address eg.
> "Honeyhouse, High Street,"
> Is it possible to r...Removing Hyperlinks
I am sure I have seen this question before on this newsgroup but can not
seem to find the thread.
Is it possible to remove hyperlinks in bulk from a worksheet or must they be
done one at a time?
Delete extra @ to reply
You can copy a blank cell and then Paste Special | Add to your selected cells.
However, this does add a zero to formulas...
= A1 + B1 becomes... = A1 + B1 + 0
San Francisco, USA
"john.bedford3" <john.bedford3@@ntlworld.com> wrote in message
> I am sure I have seen this ...Re-install Outlook Express 5
I up dated via download the OE version 6. Now some of my
programs do not work properly because of a lack of
available memory. Where can I find the old version 5, and
can I re-install it?
Larry <email@example.com> wrote:
> I up dated via download the OE version 6. Now some of my
> programs do not work properly because of a lack of
> available memory. Where can I find the old version 5, and
> can I re-install it?
Ask in an Outlook Express newsgroup.
i wanted to perform validation for duplication of entries in a column.
i went to chip pearson's website
and looked this up:
however, i am not getting the desired results.
it validates for only the immediately previous entry.
for example, if i enter duplicates in consecutive cells, it gives me a
error. if the cells are far apart in the column, i do not get a
thanks in advance,
Message posted from http://www.ExcelForum.com
The data validation formula works for me just fine. ...Problems with viewing Calendars from different Hotmail/Live accounts on desktop
Several Calendars from different Windows Live IDs which I have tried to
share with my primary account. However, not all the Calendars appear on the
primary calendar of my Primary ID and WLM desktop does not pick them up
either. Is there a limit to the number of Calendars that WLM desktop can
show? If no limit, what am I doing wrong?
...remove column in all email views
I put some add in to my Outlook 2003 about 8 months ago that was
supposed to help me keep track of my emails. I did not like it and
uninstalled it. However, any time I create a new mail folder now
outlook automatically makes a thread and categories column. How can I
get it to stop this behavior?
I would also like a way to remove all the categories and thread columns
in all my folders so I don't have to go into each folder and do it by
hand. I am a programmer so doing it programmatically is not an issue.
...Outlook trying to connect to strange server
I'm using Outlook 2003 running under XP home.
Every time Outlook starts, my virus checker (Kaspersky) reports
"The application C:\Program Files\Microsoft
Office\OFFICE11\OUTLOOK.EXE cannot establish connection with server
184.108.40.206. Please check your internet connection settings. If you
have a firewall installed, check that the application avp.exe is
allowed internet access"
Well, avp.exe is the virus executable and it has internet access. the
ip quoted is registered at colospace.com.
I have scanned for Trojans and adware without finding anything.
Anyone any idea what...Dotted line to remove
I have just been editing a multi-page word document and something I did has
made a dotted line appear. It goes across the page from margin to margin.
Whatever I do to try to remove it doesn't seem to work. The line was not in
the original so some I assume some key or setting I have touched has done it.
The Word I am using is MS Office Word 2007 - something I find is a lot more
fiddly than the older version I have used for years.
Any help would be appreciated.
<>>< ><&l...Remove existing property sets doesn't remove
I have created a new custom property sets in Visio 2003 Professional and it
will not allow me the remove the existing property set and replace it with my
...Removing "Maximize" from system menu.
I have a dialog based application. I want to completely remove the Maximize
and the Size entries from the system menu. They are grayed now, but I want
them totally removed. I just want a cleaner look since these will never be
How do I do this?
You could try making the main dialog have a Tool Window style set. It will
be smaller, but it looks nice.
"Paco" <firstname.lastname@example.org> wrote in message
>I have a dialog based application. I want to completely remove the Maximize
>and the Size entries f...Saving Calendar advance search criteria
We use the Outlook calendar to track call outs and schedule changes. Once a
month we query the calendar by team. Does anyone know if there is a way to
save the calendar search criteria? We see the options, but they are greyed
out. Are we missing a step after we select "find now"?
Advanced find searches can't be saved in later builds of 2003, or in all of
"default time to PM after 12:00 pm"
<defaulttimetoPMafter1200pm@discussions.microsoft.com> wrote in message
&g...Links within 2003
I am having a problem with outlook. When I get an email with a link to a
website which word wraps to a second line the whole link is not underlined
as below so I cannot click the link to access the site. how can i configure
outlook so I can get the whole like unlined then enabling me to link to a
site without cutting a pasting
wmb <email@example.com> wrote:
> I am having a problem with outlook. When I get an email with a link
> to a website which ...RMS 2.0 Mass Item Update Tool
Does anyone know of a mass update tool for RMS 2.0? What's out there,
and is there anything that will allow for updating standard items into
a matrix? Managing products one at a time and using scripts for mass
updates is a bit ridiculous. Any suggestions and feedback would be
very much appreciated.
On Jul 23, 2:11=A0pm, Nick <nicholasalexander...@yahoo.com> wrote:
> Does anyone know of a mass update tool for RMS 2.0? =A0What's out there,
> and is there anything that will allow for updating standard items into
> a matrix? =A0Managing products one at a ...ADC removal problem
I want to go to native mode now that our Exchange 5.5
server is shut down but I cannot because I get an error
saying all connection agreements need to be removed.
I was able to remove 2/3 connection agreements, but now i
can't remove the 3rd. Config CA_SITE_SERVER
The 5.5 server has already been removed from the 2003
Check out the following article, specifically step 12:
272314 XADM: Preparing a Mixed Mode Organization for Conversion to Native
You need to remove the SRS, which will automatically take care o...File & Settings transfer wizard lost my Outlook 2003 email
I used the File and settings transfer wizard to move my email to my new
OS...but, it did not restore any of my Outlook 2003 mail on the new
machine...the outlook express was restored OK, but nothing in Outlook 2003
The old machine was xp pro, and the new machine is also XP Pro.
So, I have lost all of my email (yeah I should have backed up but i
The img0001.dat file is 15gig, and I believe it may still contain my email
becuase the only items I selected to save in the wizard were the email - it
seems that many other people also have had this problem - and apparently
th...should be able to view more attributes on the item list
I would like to be able to view more options on the item list like the other
attributes on the general tab. I need to be able to distinguish between color
and size etc. and when going to item lookup, it is hard for me to do that
when just looking at the description or lookup #. It would be nice to be able
to view any of the colums on the detailed item list and choose the look of it
like on the reports (the part where we can pick what fields show up on the
report) or just an arrow and the ability to sort the way the columns show up
in the box.
Right now if I am not sure if I am choosing ...Outlook profile generator
I just have a question regarding the Office PRF file. I want to have my
users' Outlook profiles generated automatically whenever they log onto a PC
for the first time. How do I set it up so that the PRF file only runs the
first time that Outlook is opened by each user on the PC? I just need a
high-level outline of the steps and I will research the rest myself. Thank
"MartinHTN" <firstname.lastname@example.org> wrote in message
> I just have a question regarding the Office PRF file. I wan...How do I find items common to two columns in Excel?
I have two excel spreadsheets with over 1000 stock tickers each. One has
stocks with high growth-rate attributes, the other is value-oriented
attributes. Oddly, some tickers are on both lists.
I want to find a way to quickly find stocks that are unique to either list,
or more importantly, exist on _both_ lists. I've found a 'back-door' way to
do it, but it's too complex to explain succinctly, and it seems that there
must be a function for this... I just can't find it.
You can use the MATCH function for this. If your two lists are in Sheet1!A:A
and Sheet2!A:A, the...