Money 2007 E-Pay
Noticed this morning when I was paying my bills this anomaly. Perhaps I am
Paying a credit card bill. In Money 2004 (my previous version of Money) I
would use Credit Card as the category and in the subcategory use the
particular credit card account I was paying. Worked great.
Money 2007, there is a new category named Credit Cards/Transfer. When
selecting this there are no payee categories listed. However further down
the list is another category named Credit Card. Using Credit Card shows the
various payees. Not sure what the difference is between Credit
C...Excel template that lists each month's meetings w/ some detail
I'm looking for an Excel template that lists every month of the year with
room to list weekly, monthly and quarterly meetings, including some detail
for each meeting. Probably would need to be landscape oriented. The main
intent is to give the person using it an idea of upcoming meetings, the
intent of each and what prep is required.
...how do you place a spreadsheet(s) inside another spreadsheet
I am trying to setup a workbook with spreadsheets that contain other
spreadsheets. Does excel allow this? if yes, how can I do it.
not 100% sure what you're after here ... a workbook can contain multiple
worksheets. Each worksheet contains a grid of cells 256 columns wide &
65536 rows deep. This basic structure of excel can not be altered.
Please post back with additional details on what you're trying to achieve
and we might be able to suggest a solution.
"ucastores" <firstname.lastname@example.org> wrote in message
news:DDE44C32-...data value in Form field if no table entry
I have a form with a field which pulls through and concentenates 2 fields
called [ContactFirstname] and [ContactLastName]from my table
There are however some customers for whom I do not have names and therefore
instead I would like Sir/Madam to appear in the field in the form
I think I have seen this done somewhere using ELSE? but can't find it
Any help/ideas gratefully received
Perhaps something like this:
Nz(Trim([ContactFirstname] & " " + [ContactLastName]), "Sir/Madam")
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access use...hyperlinking to an item in Global Address List Options
I have had success linking via html from web page to opening a
specific contact record from Microsoft Outlook. I have done it like
However, my very large contact database also has people with basically
the same name, like John Smith. In the current "Address Card" view
inside Microsoft Outlook, one of the John Smith's is always sorted
first. If I enter
the first John Smith in the sort order is always opened.
However, I want to specify one of the other John Smith's....Pivot Table Question #15
Love pivot tables but i have a question, the table is set up as so
Month Pallet# BoxesPur BoxesSold Price Frt Gross
Jan 1 5 1.0
..3 Formula Formula
2 5 2.0
3 10 3
Jan Total 10 10 6.0
So, the problem is in the Jan Total row, is there a way...How do I create a bookfold document in Word 2007?
I am new to Word 2007. How do I create a document in booklet form? Thanks
I'm sure you'll get better answers in an MSWord forum.
> I am new to Word 2007. How do I create a document in booklet form? Thanks
How can I create a 1 page 2007 calendar in publisher?
File, new, publications for print, calendars, select one, select yearly... click
Change date range.
Mary Sauer MSFT MVP
"Angel" <Angel@discussions.microsoft.com> wrote in message
> How can I create a 1 page 2007 calendar in publisher?
...Conditional Formatting w/ a List/Icons
I am trying to allow someone to select "Green", "Yellow" or "Red" from a list
and the cell to display a green/yellow/red icon appropriately. Or, if
possible, the user could just select the icon (instead of selecting text).
Is this possible?
Use Data Validation for the list. Type in Red, Yellow, Green as the list.
This give the user the list to select from.
Use Conditional Formatting for the fill part. Set three conditions, If Cell
Value-"Green" (select a green fill), etc..
If this helps, please remember to click yes.
"...VISIO 2007 -Text direction
can some one tell me how to change text to be type in vertically. Under
tools, options there is no regional tab or under format text the change text
direction command does not work.
"kgbrat" <email@example.com> wrote in message
> can some one tell me how to change text to be type in vertically. Under
> tools, options there is no regional tab or under format text the change
> direction command does not work.
You can use the Text Tool (The A with an circular arrow around it) and gr...2007 License
I received a free Office SBA 2007 via an MS Partner Program as a download
together with key
There is no FPP, OEM or MLK designation.
(The EULA in Word being dependant on the above)
How can I determine if this is licensed to install on a second device, other
than trying? - The PID?
Contact the MS Partner Program?
"DL" <firstname.lastname@example.org> wrote in message
:I received a free Office SBA 2007 via an MS Partner Program as a download
: together with key
: There is no FPP, OEM or MLK designation.
: (The EULA...Batch converting leads to accounts
Is there a way to convert leads to accounts in batches? I need to
convert up to 500 each day and don't have the time to go through them
one at a time.
On Sat, 26 Feb 2005 01:28:44 GMT, "Who Cares!"
>Is there a way to convert leads to accounts in batches? I need to
>convert up to 500 each day and don't have the time to go through them
>one at a time.
Only way is through the SDK.
Write some code that loops through your leads and creates accounts,
contacts and opportunities as needed and marks the lead as qu...Printing Word and excel documents via excel vba
I have a document that has some Excel and some word content i would
like to use excel vba to print both a page from word and then a page
from excel. I know how to select and open the word document, however i
cant find any code to print page X from word.
basically i need to:
print page 1 of c:\xx\document1.doc
print page1 of sheet1 of c:\yy\excelwkbk1.xls
print page 2 of c:\xx\document1.doc
print page2 of sheet1 of c:\yy\excelwkbk1.xls
and so on it will require moving between word and excel - the excel
bit i get, but getting back to excel from word, and printing out in
word is slightly more...Office 2007 11-23-09
Of all the choices out there (community discussion, dashboard, live, etc.)
how can I contact someone with input on Microsoft's software. For example,
I want to know why any one would not display the most common commands on the
HOME tab in Office 2007. Print, Save, Open, Close, Spell Check, Undo, etc.
etc. etc. Yes, I know you can customize your own Toolbar, but not a
beginner. How can I emphasize how important this is, I don't suppose you can
customize the Tabs.
I would like to ask someone why they can't get input from those of us who
teach their products. ...lead import seams to be boring
Everytime I import leads from Excel I must manually map every column to the
proper CRM fileds.
Is there a way to do it once ?
In the first row of excel file I wrote the name of the labels of the fields
but it doesn't work.
Any idea ?
To automate it, you could use the Data Migration Framework, set up a
recurring DTS task to move the leads from Excel to the CDF tables, and then
a batch job to run the Migration tool at night (or whenever nobody is in the
system). Harder to set up, but easier to maintain, until the spreadsheet
w...Using Risk+ with MSP 2007
We use Risk+ as a risk simulation tool. We have discovered that it works
approximately 20 times SLOWER in MSP 2007 than MSP 2003. Has anyone else run
into this problem. If so, is there a remedy?
My hunch this not a generic issue, but surely best that you consult with
the Risk+ people on this.
On 02/03/10 18:08, Tom Mc wrote:
> We use Risk+ as a risk simulation tool. We have discovered that it works
> approximately 20 times SLOWER in MSP 2007 than MSP 2003. Has anyone else run
> into this problem. If so, is there a remedy?
W...OL2003 Master Category List
Anyone know where the master category list is hiding these
days. In 2002 it was hkcu\software\microsoft\office\10
Any help would be appreciated.
change 10 to 11. It won't exist unless the user has added something to
it and like Outlook 2002 it's a Unicode list so the value is a binary
and not a string.
[MVP - Outlook]
Author: Absolute Beginners Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
"Dan" <email@example.com...Smart List
This is a multi-part message in MIME format.
BlankIs there any way to get a report in smart list that includes the =
serial numbers using inventory transactions or sales transcations? I =
have version 7.0
charset="Wind...How can I cut data out of HTML table, into msExcel and just take the data & columns? (but NOT the formatting & URLs!)
This is driving me ABSOLUTELY NUTS!
How can I keep the rows & columns of data that I am copying and pasting
off a website (my own in this case!), into a spreadsheet... WITHOUT
taking all the data formatting?
If I paste out of Ms IE v6 into Ms Excel (2003), it does at least keep
columns (something that doesnt happen if I paste out of FireFox, fwiw).
But it pastes with all the formatting & URLs etc - which I DONT WANT!
OK, I can save as .CSV, close, 2 warnings, and re-open but when done
REPEATEDLY this is a damned nuicance!
ship w...Bizarre background window behavior in Word
I am running MS Office for Mac 2008 (12.2.4) on a 2008 Intel iMac with the
most recent version of Leopard OS. Since installing a recent upgrade to Mac
Office 2008, I have been having a frustrating problem when I keep multiple
documents open in Word. The active document will randomly be moved to the
background, while one of the inactive open documents will randomly move to
the foreground. Curiously, the inactive window now in the foreground
actually remains inactive, and if I continue typing, the text is placed in
the active window that is now hidden in the background. The only way to
b...Personal.xls not hidden in Excel 2007?
When I open a spreadsheet in Excel 2007 my Personal.xls file opens too,
in a separate window. (I get a separate "tab" in my task bar.)
If I remember correctly from Excel 2003 the Personal.xls was actually
hidden and didn't open, but the macros in it were made available to
open worksheets. In any case, that is the behavior I would like.
Is there a setting somewhere that makes the Personal.xls stay hidden?
I've tried putting it in program files/.../xlstart and in application
data/.../xlstart. I've also tried making it a .xlsb file.
I haven't tried...Access To Word Mailmerge
I have setup a Mailmerge that is run from Access. The process works like
this: 1) The proper record is selected in an Access form which automatically
starts the process. 2) Word is called up automatically, it shows both the
template and the doument with the proper data in it. 3) Access is closed
automatically. 4) The user then needs to close the mailmerge template. 5)
The document with the proper mailmerge information inserted from Access is up
on the screen. At this point a shortcut is triggered by the user that adds a
document of the users choice to the end of the curre...Retrieving sorted data from same table.
I am working on a table (mentioned below) I am looking for a query
which can get me the data according to the =93id=94 column with respect to
The condition is that I have to get three consecutive entries which
have speed > 60
Below is the sample table with data on which I have to retrieve the
data on above condition.
The output i need can be as given below
DVXC002 12/10/09 0:12 96
DVXC002 12/10/09 18:40 89
DVXC002 12/10/09 19:43 65
DVXC005 12/10/09 11:56 69
DVXC005 12/10/09 15:26 62
DVXC005 12/10/09 17:35 85
Need your help urgently....Thanks in advan...Project server 2007 Timesheet creation
We are using project server 2007. When create a new timehseet, we are
facing the following issues.
1. Sometimes the timesheet will be created with all the data filled with the
planned hours against the standard row.
1. If we try to add the a new line to the timesheet using Add Lines, it will
be added without project name and tasks.
Please help me to resolve the issues.
Are you getting add-lines dialog box when you try to add...if your able to
see then you shoud select the project task and say ok.hope this helps
...Rounded Corners in Excel 2007 Not Working?!?!
I can't get rounded corners to work in Excel 2007:
I make a chart
I right click on Char Area
I Select Format Chart Area
A Dialogue Box Pops Up with the following Selections:
- Border Color
- Border Styles
- 3-D Format
I select fill and fill the chart area with a color .. say blue
I right click on chart area again and this time select Border Styles
and the following options are available:
- Compound Type
- Cap Type (drop down menu)
- Join Type (drop down menu)
- Arrow Settings
I click Cap Type and a drop down menu appears with the following