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...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...Looking Up the First Nonzero Value in a Column
I am looking for a function that can return the first nonzero value in
a column. I have a table that has months across the top and down the
leftmost column. The data in the table are balances as of each month,
It looks like this:
J F M A M
F 2 1
M 3 2 1
A 4 3 2 1
M 5 4 3 2 1
Is there a way to say, "Look in the column labeled "F" and return the
first nonzero number"? Then the cell below it will need to be the
number directly below that first number, and so on. I'd appreciate
any help. Thanks!
T...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...How do you add straight lines to a candlestick chart?
I created a candlestick chart for foreign exchange rates, but I want to add
several horizontal lines indicating the high for the range (using formula
MAX), the low for the range (using formula MIN) and an additional trade rate
line (manual input) without having to manually draw the three lines each
So for example, I would create a candlestick chart for Currency A within the
past two weeks. Let's say the 2-week range is between 115 and 130, and the
trade rate is 120. I want to automatically add horizontal lines at 130 and
115 (indicates the range) and a line at 120. This ...Copying only the numerical values
Is it possible to have a summary worksheet in an Excel spreadsheet and then
copy this worksheet on its own to another document but with the numerical
I have a worksheet which is a summary of various other Excel documents
linked together. I wish to email this summary page with the numerical values
only. I don't particularly want the file paths showing in the document I
email - I just wish the numerical values - not the formulas which produce
these values. Is this possible? Without going through complicated
"SM" <theesel1994REMOVE@googlemail...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 ...How to add a .jpg signature to entourage
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: pop
Hello All: <br><br>How can I add a .jpg signature to entourage. <br><br>Regards, <br><br>Alex
On 5/31/10 10:40 AM, in article 59bb9350.-1@webcrossing.JaKIaxP2ac0,
"email@example.com" <firstname.lastname@example.org> wrote:
> How can I add a .jpg signature to entourage.
There is currently no way of inserting images into Entourage. There are some
script options, but they are cumbersome for sigs.
<http://www.entourage.mvps.org/faq_topic/html_msg.h...Add-ons for CRM
Does anyone know of any email and campaign management
add-ons for CRM?
Axonom PowerTrack is supposed to be very good add-on, see link below
...Historical Stock Close Value
I'm trying to get the Historical Closing Price of stocks. I recorded a
macro that will download, and also found several scripts that will
download historical info for stocks. However it downloads a table for
the stock with "Open", "Hi", "Low", but I do not want the whole table,
I only want the "Close" price. Is there a way to do this?
I do this sort of thing often.
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the...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
ending...different values count
need some help...
each day i record one or more record
at the end of the month I must count the working day of the mount
counting only dates that are different.
working days = 4 (the 20, 21, 22 and 23)
is there any function that count different values
i'm coming crazy to solve this problem...
thanks to you al
ramalina...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?
...to add a row
i wanted to auto increment the number for the cells for which i have entered
say 1)some text
2) some text
This is possible if i enter in an individual column by dragging it where i
can fill the series wheras for the text already exising in the cell and i
have to prefix nos
can any one tell me whether can i do this?
Offhand, I would say that you should use a text concatenation function for
the text, prefixing "some text" with a number in a cell.
E.g. =ROW(B9)&" " &B9
where row(cell) returns the row number and the...Vlookup data wrong if the small value found are same
I need to find the smallest 8 amounts from hundreds of data and look up the
data of the corresponding amount. So I used the small function with
referrence to the Rank column and found two -100,000.00 and each of them
related to Joey and Keith. However, the vlookup function retrieved both data
as Joey and lost Keith's Number and Name. Same problem occurs if retrieving
the top 10 amounts with large function.
Thanks for your great help in advance.
Rank Amount Number Name
1 -156,250.00 8 John
2 -120,547.00 13 Peter
3 -103,100.00 541 Mary
4 -1...excel VBA
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...retrieving maximum value from query
I have a table of the following schema
for a simple query like
SELECT build.CL FROM build;
how can I apply a filter so that I only get the max CL value?
thanks in advanced.
SELECT Max(CL) FROM build
If you want the details about the entry with the largest value, you could
SELECT build_id, build_date, label, CL
WHERE CL IN (Select Max(CL) FROM build)
Recognize, of course, th...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 ...Filter out rows based on the value of a cell
Using Windows XP and Excel 2007
Would like to create a search box of sorts, where when I type a word
into a specific cell, let's say B2, then the rows displayed filter out
based on what I typed, so that only rows where column D equaled
"Smith" for example, would show. It would also be helpful if I could
select a value from a dropdown next to it determining which column
would be checked for the filtering. For example, I type "Smith" in
cell B2, and then select "Last Name" from the drop down so that the
rows displayed are filtered by showing only rows where the...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...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.
...Selecting Refedit value
I am using refedits and am selecting a range of
cells...i.e. more than one cells. If I select a single
cell then I can get the refedit value from the Range
(Reedit1) or Range(RefEdit1).Cells(1).Value or
RefEdit1.Value. I got this help from this user group
itself. Now my criteria is changed and now i want to
select values say for e.g. from $BO$304:$BQ$304. How can I
extract the values into a variable???? Can it be done.
thanks a lot
You can set a range or refer to a range according to the refedit value
Dim rngInput as Range
set rngInput = Range(Refedit1.Value)...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...Add SPF record to Public DNS zone or internal DNS server.
I have added a SPF record to my internal DNS servers to prevent SPAM.
However, we're still getting SPAM that looks like sent from our own domain.
I tested it on DSNstuff and Openspf.org and no SPF record is found for our
domain or mail server.
My question is should I publish my SPF record to my ISP's DNS zone or my
Windows DNS servers, or both? We hosts our own Exch server and have a MX and
A record pointing to our mail server in ISP's DNS zone.
The SPF record needs to be in public DNS, not your internal zones.
Create the SPF record on ...