allowing M05 to convert your file twice!! BAAAD!
In an attempt to resolve some of my problems, I
reinstalled MS Money.
Now, I already converted my .mny file, however since it
installed, it wanted to convert my file without even
looking at it (to see it already was). I thought it
would; but, it converted it anyway and all of the
transactions were backwards (debits = credits and vice
That may be why people have wrong entries!
...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.'
...*Keeping* multiple CToolbars docked in a single row during window resize
I have an MDI app with several toolbars docked in a single row (using
I am trying to prevent the rightmost toolbars from repositioning
beneath the other toolbars in the same row as the main window frame is
resized. Currently each toolbar is automatically repositioned on the
left of the screen in order to prevent it going out of view as the
window width shrinks. I would like to keep the toolbars as they are
initially set; in a single row, during any window sizing operations.
I still need to make the toolbars *manually* draggable, floatable and
moveable by user mou...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...CSV File, change separator sign
I can not change separator sign creating CSV file in office2007 running on XP
I want to have , as separator defalt is ;
I have changed in control panel nationals setting but it still does not give
me csv fil whit , as separator it keeps give me ; as separator.
Can anyone tell me how to solve this.
I've run into this myself, and eventually found it fastest just to use
NotePad or EditPad.
1. Export your .CSV doc
2. Open it in NotePad
3. CTRL-H to activate Search/Replace feature
4. Save the .CSV file.
"Actually, I *am* a rocket scientist." -- JB...How do I save a narrated (sound embedded) PPT07 file in SCORM form
I want to allow my company's LMS (Learning Management System) to store, push,
and report viewership of narrated (Isound embedded) PPT 2007 files. The LMS
has two APIs for content: SCORM 1.2 or AICC. Has anyone found a way to
store narrated PPTs (or take intermediate steps) to create SCORM-format
output so an LMS can manipulate it?
...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...attach multiple files to an email
I am trying to send multiple small pdf files from Access 2003 via
Outlook to different districts. The problem is, that I don't know the
number of attachments -- it varies by district and by date sent. It
could be 1 or it could be up to 30.
In my email code I tried to loop through a recordset and then keep
attaching the files, but it's not working.
My code is as follows:
Dim cnnLocal as new adodb.recordset
Dim rs As New ADODB.Recordset
Set cnnLocal = CurrentProject.Connection
rs.Open "select Path from tblTemp_ToDistrict where DistrictID = " &
rsDistrict!OfficeID...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 ...Creating multiple splits
Does anyone know how to create a spreadsheet with more than 1 vertical
Cannot be done.
Try Window>New Window then Window>Arrange.
Gord Dibben MS Excel MVP
On 16 Apr 2007 09:28:37 -0700, Casmusse@gmail.com wrote:
>Does anyone know how to create a spreadsheet with more than 1 vertical
Is that a typo? <<<"Cannot be done">>>
You THEN ... described how to do it!<bg>
Please keep all correspondence within the NewsGroup, so all...Are autosave copies still there if I didn't save the file?
If you ain''t happy, change yer mind!
On Mar 10, 11:34=A0am, PoppaDick <PoppaD...@discussions.microsoft.com>
(Apparently there has been some sort of change in Word2010.)
...Exporting and Importing Named cells to and from a text file
Is it possible to export only specific cells, named or not, to a tex
Secondly, is it possible to read from that same text file in anothe
workbook to place the exported data into specific named cells
clayton's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=456
View this thread: http://www.excelforum.com/showthread.php?threadid=50264
...Images do not print when printing multiple messages
My Outlook 2003 started having a problem. I am using it under Windows
I used to be able to select several messages and hit the print button
to have them all print. This morning I tried doing that, but all the
messages printed without the images, just the text instead of the
Everything prints fine if I just select one message at a time.
Anybody have this before?
I was able to resolve this by setting Outlook to compose messages in
I guess when Outlook is set to write in Plain Text then printing
Multiple HTML messages will print them in Plain Text mode.
Paul Be...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?
...Closing Multiple Activities 05-31-06
Is there an easy way to close multiple activities? In this case, a group of
No way to do this in the CRM interface
Microsoft CRM MVP
"gwhite" <ghwhiteDELETE@pwco.com> wrote in message
> Is there an easy way to close multiple activities? In this case, a group
Is there a direct SQL way to do this? ie, Select all activity records for a
user and close them?
"John O'Donnell" wrote:
...Creating Multiple Pie Charts from Excel Sheet
Creating Multiple Pie Charts from Excel Sheet
I have an Excel sheet with the following:
-1 header row with the column names.
-5 individual rows of unique numerical data underneath.
How can I create 5 separate pie charts each using a separate row and
the header row without going through the chart wizard for each
Needless to say, I have about 75 rows in the actual example.
What version are you using? If 2007, suggest create one that looks how
you want it, save as a template. Then select the next lot of data,
click F11 to create a chart. When all are created go...Mirroring excel file content
I have an excel file with a large amount of data that i need to make
accessible to a large number of users in the office. There are also a couple
of people who need to be able to edit this file to make changes.
The porblem that we have at the moment is that those who only need read only
access are currently locking the file from being edited if they open it 1st.
I thought the solution might be to copy the data into a separate readable
workbook using copy -> paste special -> link which i did by highlighting the
entire range of rows.
When i paste this into a n...Adding Multiple Lines On A Secondary Axis?
I am working with a line-column on 2 axes chart . Columns are charted on the
primary axis and a line is charted on the secondary axis. I am trying to add
a second line to the secondary axis. Can anyone help?
One way is to use the Add button on the Series tab of the Source data
dialog. Right click chart and pick Source Data from the context menu.
If the new series is not automatically a line series simply select it,
right click and choose Chart Type. Select required line chart.
You can also use copy and Pate special to add data to a chart.
...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...Outlook 2003 multiple issues. Does this thing work?
Had Outlook 2002. Worked fine. Upgraded to Outlook
2003. Now all kinds of problems. Uninstalled,
reinstalled, ran updates, etc. still no help. Here are
1. Crashed all the time with a ntdll.dll error
2. If I send in Rich Text or HTML format the messages
arrive completely blank.
3. Cannot customize any view. The flag column is about
the 5th column over and header status is the 1st. I have
removed header status and moved flag about 2,000 times
and they don't move or go anywhere. Seems they put
customize view in there just to give you something to
click on so they ...lookup over multiple ranges
I want something to the effect:
but I want to do this without using an if iserror function. Is there a
way to do this? An array formula perhaps?
it is possible, if both Range1 and Range2 contain same number of rows
Define range name
Range1 = $e$5:$f$10
Range2 = $k$5:$l$10
Lookup Value placed in H5
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 ...HMONITOR problems with multiple monitors
I need to determine if a window I am about to open is on a valid monitor.
That is, the user may have positioned it on an external monitor that no
longer exists (laptop w/ external monitor later opened on laptop only is
typical scenario to cause this).
According to MSDN, I should be able to ask for the HMONITOR of the rectangle
of the window, and get a NULL value if the monitor does not exist. I tried:
HMONITOR hMonitor = MonitorFromRect(frame, MONITOR_DEFAULTTONEAREST);
where 'frame' is the window rect. I always get a valid HMONITOR value
though, even if I have positioned the...