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.'
...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...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?
&...VNC on LAN by name?
I need to do a VNC connection to a computer on the LAN.
It seems that VNC progs need an IP address.
Is there any way to do the connection using the name of the computer?
http://www.transcendence.me.uk/ - Transcendence UK
http://www.theconsensus.org/ - A UK political party
http://www.blogtalkradio.com/onetribe - Occult Talk Show
Dirk Bruere at NeoPax <email@example.com> typed:
> I need to do a VNC connection to a computer on the LAN.
> It seems that VNC progs need an IP address.
> Is there any way to do the ...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 ...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...selecting gp company within crystal at run-time
I'm using GPv8 and Crystal 10(?).
I have a report in Crystal that I want to be able to run against any of our
multiple company databases in GP. For example, I want one of the parameters
the user would enter to be "Select Company". How can I do this? Right now
I have multiple versions of the report saved, with each pointing to a
different SQL Server Database.
Post your email address and I will send you a sample code which will let you
process data from a selected company. I had to do it for myself to create a
Consolidated Historical Trial Balance Report...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...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 ...Change the Range of a Name
Is There a possibility, to change the Range of a name-dependent of the value
of a Variable(perhaps Startrow rsp. Endrow)-with with a VBA-statement?
Thank you for a good hint!
dim Startrow as long
dim endrow as long
.range(.cells(startrow,"B"),.cells(endrow,"c")).name = "myName"
if myName already exists, this'll reassign it. If it didn't exist, it'll get
(Did I misunderstand the question?)
"H�lzl Otto" wrote:
> Is There a possibility, to change the Range of a name-dependent of the value
&g...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...Named Cell Ranges #4
I have a number of workbooks (B) that, through various formulae, look at
another workbook (A) for salary information.
I've added some rows to a named range in (A) and as a result the formulae in
(B) now throw up errors.
Is there an easy way to fix this and how do I avoid the problem in future?
Thanks for any help.
Please ignore this!!! It's a repeat!!
> I have a number of workbooks (B) that, through various formulae, look at
> another workbook (A) for salary information.
> I've added some rows to a named range in (A) and as a re...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.
...Companies sharing report dictionary
We have 3 total companies set up in our Microsoft Dynamics GP 10 application
When company1 was first setup there were a handful of customizations
developed (modified forms/reports). The issue is, after installing company2
all of those customizations that were done for company1 are also in company2
My question is, how do I separate these? I want company2 to have its own
reports dictionary completely as there are modifications needed for it as
well (different logo's...etc) Is there an easy way to achieve this?
Also, when i change a modified ...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...Merging Two Columns Containing Names
I need to merge two columns (first name and last mane),
how can I do this?
Assuming you have your first names in col A and last names in col
place this formula in col C and copy down as far as you need it:
Message posted from http://www.ExcelForum.com
> =A1&" "&B1
Perhaps just wrap a TRIM() around the above
to clean up any stray leading / trailing spaces
in the inputs in cols A and B
: =TRIM(A1&" "&B1)
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" <firstname.lastname@example.org> wrote in message
> Is it possible to search on the results on a cell?
> For example, a cell may have a formula such as
>...Search Form Problems
I have a form that has two fields in it. The first field is for a ID
number, and the other is for the projects name. I am having a problem
with using the form for as a search tool.
Some of the values are duplicates in the drop down, I wanted to know
how to properly filter the combo box so that the values can only be
The Row Source is the name of the table that the fields are from,
however this only words for the ID combo box and not the project name
one. For some reason the values are from the ID column in the project
name's combo box as well. To counter this problem, I si...Account not selected when coverting leads
There are 3 options to chose when converting a lead - account, contact and
opportunity. If you do not select the account, can you do so at another time?
Is there any way to create the account after converting if it was not
The Opportunity has to be linked to a particular account as it is a
required field in Opportunity.
The best thing to do is to create a default account and call it "None"
or anything you like and get the users to set the opportunities that has
no accounts when creating the opportunities to it as a temp account then
insert the correct info in the...