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...getting a column name
please help me with this one ok?
lets say i have two columns. in the first raw i have the names:
the next two rows are numbers
what i need to do is to know who got the 20 in the previous row.
so the cell c3 will be "bill" because in the "b" row bill got "20" a
in the "c1" cell.
it looks like that
please help asa
mordor's Profil...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.'
...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...Max length of variable name?
Sorry if this appears twice, could not tell if first posted.
What is the maximun length of a varaible name?
x=1 not problem, but
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx=2 this is too long, yes? How long can it be?
On Mon, 12 Apr 2010 09:49:01 -0700, David <David@discussions.microsoft.com>
>Sorry if this appears twice, could not tell if first posted.
>What is the maximun length of a varaible name?
>x=1 not problem, but
>xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx=2 this is too long, yes? How long can it be?
&...Can't move tables in Relationship view
When I open Relationships in Access 2003, I can initially move just about
any table. But then some of the tables become frozen at their position, and
I have to wait several minutes before I can move them.
What causes this? Is there a work around?
I suspect the problem you describe is due to a miscommunication between
Access 2003 and Windows.
On Windows XP with themes, Access can get confused about what the mouse is
pointing to, and doesn't recognise when you are pointing to the border of
the tables in the Relationships window. This generally happens when the
window has been sc...converting 1.x database to 2.0 from DOS files
I saved the 1.x database on floppies. Now I need the
database again and need to upgrade it. How do I copy the
floppies with the 1.x database so that it will work with
access 2.0 in an XP pro environment?
...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...Path Name
I need to have the path name of the file in the footer. I
have followed the instructions from the website (which
work), but these instructions require the user to save the
file first, which is not what I want to do. Also, I want
to be able to open up a file that I didn't create and have
the path name automatically show up. Thank you.
you need to save the file first - otherwise which path should be shown?
And if you don't havel Excel 2002+ this requires VBA
> I need to have the path name of the file...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 ...Importing MYSQL databases into CRM 3.0
Our website portal - an ecommerce store that offers consumer electronics
are built on a MYSQL database.
We will like to import our Website customer database into CRM 3.0 on a daily
1) When customers email us, we can check the history of its purchases
(mapped to email address), time of purchases, date of shipment with a click
of a button.
Is this possible with Microsoft CRM 3.0; if so, is it a easy task that can
be dealt with on a daily basis or can be scheduled and automated?
Only possible by either buying a 3rd party solution like those from
...Thrid-part anti-spam and cleaner software : which the best ?
i would like to put a third-part anti-spam and cleaner software in front of
our Exchange 2003 to clean at the maximun the mail that come to our Exchange
I read that Esafe Mail from Alladin is good and i just would like to have
your opinion or your advice about these softwares (which ? best quality, low
thanks for your post ..
Maybe you should consider IMF from Microsoft. It's does good work and its
"Ouba" <email@example.com> wrote in mes...Filtering data by custom fields in pivot tables from Visual Report
I have recently upgraded to MS Project 2007 and like the visual reporting
feature, except I really need to filter and group the resulting pivot table
in Excel by custom fields. For example, for task usage, I cannot filter my
pivot table to show only the tasks that have costs > $0, thus my table ends
up showing too many lines and a lot of 0's. I would also like to group by
department/ function which I put in a custom text field. How do I do this?
I saw related posts about saving the file as an Access database and then
creating the pivot table by connecting to the datab...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
ending...Using VBA to switch to a particular Access database
Need a bit of help, please, with some VBA code that I've written in Microsoft
Outlook 2007. It is intended to call up a specific Microsoft Access database
and open a particular form and subform, so that it can then go on to take
various actions based on the values from Outlook. Here's the basic code:
Dim appAccess As Access.Application
Dim ThisDatabaseFileName As String
ThisDatabaseFileName = "C:\myFile.mdb"
Set appAccess = GetObject(ThisDatabaseFileName, "Access.Application")
appAccess...Sort First and last name in single cell
I have a mailing list of over 10,000 names, with the first name and las
name in a single cell. The first name is listed first. Is there a wa
to sort the column by last name or better yet isolate the last name t
a separate column so I can merge the data to a different application
Thank you in advance for your help. :
Message posted from http://www.ExcelForum.com
Rpielet, there's no way to sort by last name, given the way your data is
entered. Instead, use the Text to Columns command on the Data menu to put
first and last names in separate columns. It's very intuitive. Check it out...Filter drop down box in pivot table
I recently upgraded to Excel 2007 and I'm having difficulty with pivot
tables. I have a pivot table with three report filter fields. In previous
versions-2003, once I select criteria in the first filter drop down box, the
second filter drop down box would only show me a subset of the original data
based on the first filter. Once I select the criteria in the 2nd filter pull
down box, the the 3rd filter pull down box would only show me a subset of the
source data based on the first two filters applied (i.e. there are fewer
choices after each query). In 2007, I noticed that once I ...GP 10 Upgrade
I was wondering if it would be posible to run a GP 10 upgrade as follows -
- Relocate a GP8 DB to a new SQL Server (DYNAMICS and Data)
- Create a new DSN pointing ot the new SQL Server
- Install GP10 using the new DSN
- Run GP 10 Utilities to convert the db
You should really go out on the customersource site and find the
techknowledge regarding moving databases from one server to another.
(Transfer of Great Plains from one server to another.) If you are doing what
you are describing below, you will lost all your logins, (which is a pain to
recreate) and have other...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...Joining 2 Tables
How can I join 2 tables that have the same record layouts ?
On Wed, 12 Mar 2008 10:16:01 -0700, carl <firstname.lastname@example.org>
>How can I join 2 tables that have the same record layouts ?
By using an appropriate query.
Since we don't know anything about the structure of the tables, how they are
related (if at all), nor how you would like them "joined" it's hard to say.
More info please? perhaps an example of what you have and what you want?
John W. Vinson [MVP]
Thank you for helping.
Table1 is like this:
Day Product Qty
2-Jan 1...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 ...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...Workbook name as variable to another workbook
Can you save a specific workbook name as a variable, to be used in a
different macro? i need the variable to be saved and available to return to
the specific workbook open if i have a lot of books open to complete the task.
Dim myWkbkName As String
myWkbkName = ThisWorkbook.Name
If you execute runmefirst first, then runmesecond, you'll see that myWkbkname is
available in the second.
If you need to put the routines in different modules, declare myWkbkName as
Publ...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.