Search last 4 digits in an (account number)
I store bank accunt and credit card numbers in various Contact Notes. For
example, a credit card # as xxxxxxxxxxxx1234.
Outlook contact search would not find this contact if I enter the search for
Is there a way to do this in Outlook 2007?
PS - this search works fine in Outlook Mobile.
outlook searches from the beginning - so it will only work if you use
xxxxxxxxxxxx 1234. Other search tools (like google desktop) may find it.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: htt...Money Questions
I've been using Microsoft Money for awhile, and I realized that there ar=
alot of things about money that I do not understand.
1. What's the difference between reconciliation and cleared? What's the =
use of the flags anyway?
2. How do I clear multiple transactions in one go?
3. If there are differences in my Microsoft Money savings bank account, =
how do I handle it? Do I create a new transaction with a new 'missing =
4. Is there a way to choose what column gets displayed in the Account =
Register view? I'd like the ...transpose question
I have a list that has, company (cell A1) street (cell B1)
city (cell C1) Province (cell D1) etc. I want it to list
them straight down row A. for example:
company (cell A1)
street (cell A2)
city (cell A3)
Province (cell A4)
Copy (or cut) the range (A1:D1)
Put you cursor in A1
Paste Special and check off transpose
"jvoortman" <firstname.lastname@example.org> wrote in message news:email@example.com...
> I have a list that has, company (cell A1) street (cell B1)
> city (cell C1) Province (cell D1) etc. I want it to list
> them straight down row...Look for: Search In => Choose folders=> Search subfolders not working
When I search for an old email using Outlook's Look for: box and specify
which folders to search in via the "Choose folders=>Search subfolders"
checking a folder does not actually cause any subfolders to be checked.
Unless there is some other setting and/or option hidden away somewhere, the
"Search subfolders" check box is not working. I must manually check all the
desired subfolders. What am I doing wrong?
Santa Monica, CA USA
To email me, just pull 'my-leg.'
...Searching for Newsgroups
I subscribe to a Usenet service for accessing various news groups.
After I download all the newsgroups from that server I can not find a way to
search for the newsgroups I have interest in.
When I put something like "RV" in the search box on the top right corner, it
searches all of my Emails rather than just the list of groups that had "RV"
in the title.
Help tells me that there is a " Display newsgroups containing" box but for
the life of me I can't find it.
Any thoughts out there?
I am running Entourage 12.2.3
Click the bar in th...Search & replace in formulae
Is it possible to do a search and replace which includes
the cell formula contents ? I have a workbook that has
cells which link to the contents of a cell in another
workbook and I'd like to know if the naming has to remain
constant or if I can replace a part of the name
periodically. ie each year.
"Iain Rhodes" <firstname.lastname@example.org> wrote in message
> Is it possible to do a search and replace which includes
> the cell formula contents ? I have a workbook that has
> cells which link to the contents of a cel...Search engine optimization
My question today regarding this issue is: I have noticed some sites have
the following on their sites "Source".
meta name= "robots" content="Index, follow"
meta name= "revisit-after" content="15 days" or (30 days)
What does this function accomplish as far as search engines go? and will it
really imporve your results ( rankings) Like for instance "robots" "index,
all" what is the difference between this and saying "robots" "index, follow"
I'm a bit confused about this. Can someone ...Can I search identical fields from multiple tables?
I have a database to log details about staff in my school. I have a tables
for staff details, courses, absence, educational visits etc.
In each table I have a date field to show when the member of staff is not
I want to produce a query to search all tables by entering a date - e.g. to
bring back all results for staff who are not in school on a certiain day
because they are either ill, on a course or on an educational visit. The
query will work by entering a date once - it will then search all the other
tables and bring back the results.
Is this possible? Do I restructure?
...What does outlook search when you search Contacts ?
When you do a search in oulook for contacts, what is the criteria that
outlook searches? Or I guess how does outlook search? Why is it not
consistant? The reason I am asking is that we have our customers
contacts in public folders. In our customers we have 6 contacts for XYZ
Foods. If you search in outlook for just "XYZ" it only comes back with
4 of the six. If you do a search for "XYZ Foods" it returns with all 6.
And if you just entered "Foods" no contacts were found. And we actually
have a few companies in our contacts who's names are a two part name
How would i search a range of a whole column instead of specific cells
Message posted from http://www.ExcelForum.com/
are a few ways.
"Zygoid <" wrote:
> How would i search a range of a whole column instead of specific cells
> like .Range("a1:a300")?
> Message posted from http://www.ExcelForum.com/
I was trying .Column(1)
i see i neede an "s" in there
Thanks a...Question on Article 822940
We have created a couple of test domains in our envoriment. When we add
Exchange users to the test domain they appear in the Default Global Address
List. I would like to prevent users in the "test" domain from appearing in
the default global address list.
I noticed in article 822940 it goes thru the steps of limiting access to the
default global address list. I would like to keep this intact and make it so
the other sub domains are not listed in the default GAL. What is the easiet
way to do this?
...Multiple fields using to search
Something i've been batteling for weeks with and theres probably such a
simple answer to it and i just cant see it:
Riiiight, i have this form (lets call it frmClientSearch)
On this form i have a 2 list box thinghys; One called lstEmployee which is
populated with Employee names and the other lstCity which is populated with
Then i have a command button (cmdSearch) which, once click and values
selected in both the lst boxes, should return only the values that are equal
to both the lst boxes in a new form called frmSearchResult.
(Hope i make sense)
So... I know how ...Final attempt save as binary question
This is about my fifth attempt since March, so far without eliciting a single
reply (last attempt seems to have disappeared into the ether):
Re Excel 2007 "Save as binary". Its supposed to save space and be quicker.
So why isn't it the default method? Is there a downside? For example, will
macros no longer work? Are there reduced functions in a file saved as binary?
I need to know before I save a large and majorly important (to me) file with
heaps of worksheets and macros and find down the track that I've lost
There HAS to be some reas...Quick Question
Im a pretty newbie to Excel
Why is it when i try and paste say 1/29 it changes to Jan-29 etc
Is there away of preventing this from happening?
Problem now sorted --
"G3�wh)zZ@" <geewhizza@( REMOVE X2X )clara.co.uk> wrote in message
> Im a pretty newbie to Excel
> Why is it when i try and paste say 1/29 it changes to Jan-29 etc
> Is there away of preventing this from happening?
Right click the cell/Format Cells/Date
"G3�wh)zZ@" <geewhizza@( REMOVE ...Mail Delivery Question
I have an Exchange behind a linksys router on an ADSL connection. My server
is configured to use DNS to deliver outgoing and my DNS has forwarding
enabled to external DNS server. I can send email to an email account of the
ISP that I'm on, while I can't send email to other domains. Is there
something else that I need to do?
What NDRs do you get, if any?
> I have an Exchange behind a linksys router on an ADSL connection. My
> server is configured to use DNS to deliver outgoing and my DNS has
> forwarding enabled to external DNS s...Search, Search, Thanks
In the last couple of weeks I have been fighting with different ways o
synching my laptop and my home pc. I have ended up with numerou
duplicate entries, duplicate address books and duplicate contact lists
ALL of my questions/problems I was able to resolve simply by searchin
through the forums. Chances are if you have a problem you're not th
first. There are some really good people on these forums that know alo
more about Outlook than I do.
Just my .02
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages dir...Display search results
Using OneNote 2010 Beta: file tabs are on the left; how can I make search
result tabs appear on the right? Now they don't appear at all: the first
search result is displayed in the middle of the screen (that's fine) but no
way to move to the next search result, nor any way to scrool them all the
search results. I'd like to see all the search result tabs listed on the
right so I can choose the one I want (as was the case with the version of
OneNote that got replaced by 2010 beta). Many thanks for any help.
I can't really visualize what you want, but h...how to find and replace a symbol in my worksheet
I need help with finding and then replacing a symbol in my worksheet. In the
find and replace box there is no way to insert a symbol there. I have tried
to cut and paste as well as to insert the symbol in the find box. If anyone
has an idea on how to replace a bullet with a comma please let me know.
In the Replace What: box you would hold down the ALT key then hit the ascii
code number on the NumPad.
Bullets are usually ALT + 0149
So.........select the cells.
what: ALT + 0149 you will not see anything in the what: box, but it is there.
Replace...Ex 5.5 DL Question
Is it possible to limit it which users can sent mail to a Distribution list
within my Exchange Org?
an example of this is I dont want just anyone to be allowed to send mail to
my "everyone" group.....I only want to allow Management & IS to have this
Thanks in advance for any help.
That's a feature of later versions of Exchange.
"Brian Ullrich" <email@example.com> wrote in message
> Is it possible to limit it which users can sent mail to a Distribution
> within my Exc...Including imap folders in outlook 2003 search folders
Is it possible to include imap accounts/folders as providers for "virtual"
search folders in outlook 2003? At the moment, I only see the option to
check folders in my personal folders but not to include imap folders.
The reason that I ask is that I would like to be able to get a complete view
of follow up tasks across all my accounts (1 pop3, 2 imap and 1 hotmail).
Only the pop3 account gets delivered into the personal folders and is
included in the follow up a nd unread search folders.
Thanks for your help in advanced.
I would like to be able to grab the row information from the first Do-While
loop (column D) and use it to create a range for the ActiveCell.Copy and
PasteSpecial (column J), instead of using a loop to find once again an empty
value. This works, but I couldn't figure out the code for the range to make
it run faster. Any help is greatly appreciated.
Do While ActiveCell.Value <> Empty
For I = 1 To 15
Can anyone explain how to setup an automatic simple increment counter. I
just want the first column in each row to increment by 1 so it would be like
4 and so on....
Your help will be greatly appreciated.
- enter 1 in A1. Then hold down the Ctrl key and fill down A1
- enter 1 in A1 and 2 in A2. Then select A1:A2 and fill down
- enter 1 in A1. Select A1:A100. Do Edit>Fill>Series Step=3D1
To fill down, point at the little black square in the bottom right =
corner of the cell and drag down.
"Chris" <firstname.lastname@example.org&g...forgot to post version for previous question posted on update quer
In my previous question I forgot to state I'm using Office 2003
I know the topic here is about Internet Explorer but I need some help on
another computer related topic: the iPhone. Is there a newsgroup that is
dedicated to that subject? My problem is that when I try to sync my iPhone
to iTunes, my computer locks up about half way through the sync process. I
have gone to my local AT & T store where I bought the iPhone and did not get
any help. So......I'm checking here to see if anyone can either offer advice
or direct me to another newsgroup. Any and all help would be most
First hit on Google:
Is it possible to search on the results on a cell?
For example, a cell may have a formula such as
You can search and find the 3 or the 5. The cell with show 8, is it
possible to search for an 8 and have it find this cell?
Yes. In the Search dialog, choose Options and select Look in Values.
Microsoft MVP - Excel
"berj" <email@example.com> wrote in message
> Is it possible to search on the results on a cell?
> For example, a cell may have a formula such as