default appointment times problems
When i re-open outlook and go to the calender, all the appointments times
have changed to 1am on the start day - 1am on the day after it waqs meant to
finish. So a 12 day appointment is now shown as over 2 days.
How do you change the default appointment time settings so an appointment
which is just typed into the day is from 9am - 5pm for example and will stay
as a 1 day event when opening and closing outlook?
All day events are 12 -12, not 9-5. If you want it 9-5, you need to make it
All day appointment change to 1 -1 if you change the time zone or DST
settings aft...ADO recordset command text vs command
I've noticed a slight difference between the way recordset command text
works vs commands themselves where SP calls are concerned. We have many
calls to SP which also include input and output parameters. When
examining a SQL Server trace, for example, the difference is, that we
can specify command text to an ADO recordset, which includes input
parameter names. However, the ADO command object does not appear to
specify any parameter names, although it does support return of output
parameters. Is there a way for the ADO command object to also specify
the parameter names? This would ...Outlook 2003 sends my gmail through 2 steps, why??
I am using Outlook 2003 to send my gmail account through
smtp.gmail.com. When I send mail in Outlook, it goes into the Outbox
rather than get sent right away. Then from my outbox, I can send the
This seems like a redundancy in efforts, how can I get Outlook to send
it straight away?
Look at the Tools Menu, then Options, then Mail Setup Tab. Check off the box
"Send immediately when connected".
"Uncle Scotty" wrote:
> I am using Outlook 2003 to send my gmail account through
> smtp.gmail.com. When I send mail in Outlook, it goes into the Outbox...How do you stop text size increasing in email replies?
I am a new Outlook user and finding it rather frustrating that every time I
reply to an email and whenever the recipient responds to me, the text size in
each email going back in the email trail gets larger and larger. Does anyone
know how to stop this from happening?
...Adding a column in Excel 2007
Have a column with letters in it. Want to sum up how many of one
letter I have in the column. What is a formula to do this please
To count the number of cells that equal X
To count the number of cells that have at least one X in them:
> Have a column with letters in it. Want to sum up how many of one
> letter I have in the column. What is a formula to do this please
On Dec 10, 10:44=A0am, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> To count the number of cells that eq...how can text be set up to generate a number?
i would like to a word generate a number, i.e.> enter "apples"in one cell and
excel generate "352" in a different cell for items like inventory.
You will need to set up a 'Lookup' table somewhere with
In two columns. Complete this for all entries and then if you are going to
enter 'Apples' on another sheet in A1 then in A2 enter
Microsoft MVP - Excel
"jwmaes" <email@example.com...Text Boxes added to Chart Series
How do I keep text boxes that I've added to a data series with the column
they belong on? If I change the size of the chart in anyway, I have to move
the text boxes back to their respective spots on the chart.
Text boxes are not added to a series, but to the chart. This prevents their
sticking to any particular points. Could you add them as data labels? If you
use a built-in position (i.e., don't drag them around) they will stick with
their associated points
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://P...Text-wrapping horizontal axis labels
I've a small problem which I can't seem to find a solution for - I have
created a set of financial reports for a client, which includes a number of
charts. The charts are waterfall charts, which I've constructed using a form
of stacked bar chart. The labels for the horizontal axis are linked to text
alongside the calculations for the charts.
The text in the labels is of varying lengths and for some of the charts,
this text is being wrapped to two layers on the label that appear on the
chart. Every now and then, one of the labels is too long, and instead of
...Can't see text box fill colour
I have recently reloaded Office Small Business following a hard drive crash.
I made some changes to display in Control Panel Accessibility this time that
weren't there before. I've changed back to default but the problem
Previously I could fill or border text boxes and see the results in both
normal view and print preview. Now the fill/border colour is only visible in
print preview. Borders appear as black and fills as white in normal view.
Text colours are unaffected. This is making life difficult as white text in
a black fill just disappears until I go to pr...Microsoft Excel ASC II Text Files
How do I convert an Excel spreadsheet into this type of
file in order to import to another program such
as "MaiList & AddressBook"
try saving as 'CSV' file in the Save As dialog. This is a comma
separated text (ASCII) file
Bill Cadwallader wrote:
> How do I convert an Excel spreadsheet into this type of
> file in order to import to another program such
> as "MaiList & AddressBook"
...Outlook hanging #2
When I open Outlook it is slow to check send/receive.
Once open, it appears to be randomly hanging when I click
on a message to open it. Especially those with
attachments. I have to control, alt, delete to move on.
When I open the details window in the error report window
it has "szAppName:OUTLOOK.EXE szAppVer: 10.0.4510.0
szModName:hungapp szModVer: 0.0.0.0 offset:00000000". I
can't seem to get past this problem, and have been unable
to find anything to help me fix it.
...Outlook 2000 & Vista #2
Can anyone tell me whether Outlook 2000 (from Ofice 2000) is compatible with
Vista? If so, where might I find support to complete the installation? I keep
getting an "Operation Cancelled" message anytime I try to sign in or set
Outlook 2000 as my default.
Only 2003 and above is fully compatible
OL2k is out of support as is OLxp
"Steve" <Steve@discussions.microsoft.com> wrote in message
> Can anyone tell me whether Outlook 2000 (from Ofice 2000) is compatible
> Vista? I...CheckBox #2
I have a sheet with a checkbox in column A and a value in column B. There
are about 30 rows of this data. The user selects the items they want to view
and I run VBA code based on their selection.
I want to turn the checkboxes on and off within VBA but can't figure out
what each checkbox is named and how to reference it in VBA code. I just need
to do something like:
CheckBox13 = True
Checkbox 99 = False
like in Access
Can anyone help please? Thanks in advance.
ActiveSheet.CheckBox13 = True
what you need ?
"PeterM" <PeterM@discussions.microsoft...Date formatting in Excel #2
How do I format a cell to return Oct 04 when I type 10-4 in Excel...When I
type 10-4, Excel returns Oct 05.
When no year is typed, excel would assume it is the
current year. You would ahve to type the full date
(including 2004) for it to display as Oct 2004. Use
Format - cells - date and then select the particular
format you want from the options there.
>How do I format a cell to return Oct 04 when I type 10-4
in Excel...When I
>type 10-4, Excel returns Oct 05.
...Sales Pipeline Report #2
Anybody had problems with this report in terms of the group by Date function. Cannot get the date order of the report to work in terms of ordering by Estimated Close date.
Am posting here in the attempt to get anyone out there to help me please... have been pulling my hair out in looking at the query in this report to work out how to order by Estimated Close Date!
Thanks in advance,
Absolutely. The CRM 4.0 Sales Pipeline report group by Date does not work
correctly when using non-US CRM date formats.
I have logged this as an issue with MSFT support, who accept there is a
...Installed from CD, apps in "trial" mode #2
I went through the whole procedure again. Here is the list of files in
Office Font Cache (11)
Microsoft Office ACL [English]
OLE Registration Database 11
Office 11 First Run
Proofing Tool Preferences
Office Registration Cache 11
OK, the Remove Office tool is operating correctly, there's something else
Check back in a few days, I'm escalatin...Viewing 2 worksheets in the same workbook
Is there a way of viewing data on two separate worksheets in the same
workbook in a similar way to splitting a single worksheet?
Choose Window> New Window
Choose Window> Arrange
Select Tile (or one of the other options), and check the box
'Windows of active workbook'
In each of the windows, select a different worksheet to view.
> Is there a way of viewing data on two separate worksheets in the same
> workbook in a similar way to splitting a single worksheet?
Excel FAQ, Tips & Book List
http://www.contextures....Excel macros page breaks but not on row 1 and column value in footer
Hi, I have seen some posts that are similar, but no one seems to have
the problem that I am having. I will post my macro in this, for anyone
that is interested.
My users get a csv file every month, and we have to clean it up. This
macro does that.
My last issues are this:
1) having the spreadsheet create page breaks whenever the value in
column B changes. Below is just that code.
col = 2
LastRw = ActiveSheet.UsedRange.Rows.Count
For X = 2 To LastRw
If Cells(X, col) <> Cells(X - 1, col) And Cells(X, col) <> Range("B1")
ActiveWindow.SelectedSheets.HPageBreaks...Mailbox Manager and Moved Mailboxes #2
I set up a new exchange 2003 server and moved mailboxes over to it from an
old exchange 5.5 server. Then I ran mailbox manager on the 2003 server in
Report Only mode. The report came back all zeros. The only policy I set up
was a 30 day limit on deleted items, and I know there were deleted items in
the mailboxes I moved older than that.
Does it have anything to do with the fact that I just moved the mailboxes
recently, so they haven't been on this particular server for 30 days? I read
that Mailbox Manager uses three dates to see if it should process a message-
PR_MESSAGE_DELIVERY_TI...Pass a command text in pivot table
I've got a pivot table with data give back by odbc (in excel 2003).
When i pass a new sql command, it answer me the database, also if i pass the
connection string. My code is this:
.CommandText = sSelect
.Connection = "ODBC;DSN=DS;DB=" & NomeDB & ";SRVR=;UID=SYSADM;PWD="
sNamePivot --> string variable contain the correct name of the pivot table.
NomeDB --> string variable contain the database.
sSelect --> variable contain the sql command.
Why does it called me ...Excel: When printing some cells will not print text in them
Operating System: Mac OS X 10.5 (Leopard)
When I print an Excel 08 spread sheet, two of the cells that have text in them will not print the text in the cell. All the other cells with text prints fine. The text does not even show up on print preview in the print dialogue box.
Any suggestions on how to get it to include the text in these two cells?
...Find and loop help-multiple columns
I an trying to write a macro to search for a cell value in one column and see
if it occurs in other columns
I'm having 2 problems:
1. How can I look from the last used row up to row 4 in "myrange+5" as set
2. How can I look in all other columns beside the "myrange+5" column named
Am I completely off track??
'Find the last used column
myrange = ActiveSheet.UsedRange.Columns.Count
ActiveSheet.Cells(1, myrange + 2).Select
'find the last row
therow = ActiveSheet.Cells.Fi...Finding text
I am using Excel 2007, I have a column containing formulas that would return
a name if true and a zero if false. I want to search the column for the text
entry and return that text as the answer. Can I do this or should the column
formulas be changed to something else? The "T" formula seems to work only
for one cell not the whole column.
It's not real clear what you want to do. Here's my best guess...
Assume you want to know if John is in the range.
Better to use a cell to hold the criter...New personal finance resource website open #2
New Personal Finance Resource Website Open
Free articles and information on personal finance
*** Free account sponsored by SecureIX.com ***
*** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com ***
...MultiCurrency Setup #2
created an exchange rate table HKD TO CNY.
I'm stuck on #7, HKD TO CNY not available from the Exchange Table window
Here's what I have done so far.
1. Setup currencies (setup-system-currency)
2. Assign company access to currencies (setup-system-multicurrency access)
3. Setup exchange rate tables (setup-system-exchange table)
4. Assign exchange rates (cards-system-exchange table)
5. Assign company access to exchange rates (setup-system-multicurrency)
6. Set Multicurrency defaults to a company (setup-financial-multicurrency)
7. Assign rate type to rate tables (setup-financial-...