Can't Send Messages Until I Press F9 Key
This is a multi-part message in MIME format.
Content-Type: text/plain; charset=us-ascii; format=flowed
After I compose a message and click Send, the message does go its way
until I press F9 or choose Tools|Send/Receive. I'm using Outlook 2003 on
Windows XP. In case it matters, there's a toolbar for ZoneAlrm Outlook
Addin with Junk filters (I use the Zone lite firewall freebie). Is there
a setting in Outlook I need to set to automatically send messages?
Should I disable the Zone addin? If so, how?
---...Baseball Stats question: How can I get the RBI's?
I have a data table that looks like this:
STR-S SNK-S STR-K STR-F SNK-S STR-3 STR-2 STR-F SNK-S SNK-4 SNK-S STR-3 SNK-F STR-4 STR-O
"STR", etc at the beginning are pitch types, SNK is Sinker for example
The end character is the result of the pitch, a 4 would be a home run,
3 a triple, and so forth. O is out, F is foul, S is strike --- you ge
How can I figure the amount of RBI's? I know that it's 5, but I can'
think of any automated way to calculate this, anyone got any ideas?
THANK YOU!! :confused
AVER...How do I send a welcome message to a new created mailbox automatically?
My exchnage send a message automatically but I need to change the message
where do I change it?
On Tue, 21 Jun 2005 16:35:53 -0700, "Ron" <email@example.com> wrote:
>My exchnage send a message automatically but I need to change the message
>where do I change it?
Exchange doesnt do that unless you have something scripted.
If you are referring to the welcome message in Outlook, its called
welcome.msg , but I dont think its been used since Outlook 2002.
So where would I plug in the script? Also I searched for welcome.ms...How can I wrap text across merged cells?
I'm using Excel 2000. I have a set of merged cells A5-
E5. I have several lines
of text in the cells and I want them to wrap across the
merged cells and it is not working. All I get is the
first line of text showing and the rest is cut off. It
works if the cells are not merged, but I really need to do
it in my merged cells. Is there a way to this other than
manually resizing the height of the row?
Instead of merging cells, have you tried the "Center Across Selection"
The appearence is just about identical to what you would get using merged
cells, although I d...How many Server-side rules can you put on one mailbox?
I am using Exchange Server 2003 and want to setup 52 rules on one of the
mailboxes, is this possible?
the hardcoded limit on space for rules is 32K...i doubt you'll be able to
get 52 rules on one mailbox...
Susan Conkey [MVP]
"jmareel" <firstname.lastname@example.org> wrote in message
> I am using Exchange Server 2003 and want to setup 52 rules on one of the
> mailboxes, is this possible?
MVP - Exchange
www.zenpris...Can't edit print styles in Outlook 2007
Weekly calendar view to print - Define print Styles - Edit "CANNOT DISPLAY
THE DIALOG BOX"
I'm using trial version - shouldn't be the case????
I'm having the same problem where I cant edit the print syles ... please let me know what ou find out.
I think being able adjust the format and print the calendar is important, as I usually print my calendar.
EggHeadCafe.com - .NET Developer Portal of Choice
This is an Excel newsgroup. I would suggest posting this to an Outlook one
Microsoft MVP - Excel
Southampton...can't open files
I have Microsoft Office 2003 ~ all of a sudden when I go to my documents
and try to open a file, I get this message "problem sending command to the
program". Error 0646 and dt000
See the article "How to re-register Word when problems crop up opening
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Lost in Vegas" <Lo...how to turn off automatic format in Excel?
Excel automatically change the first character in a cell to be
uppercase. I just want lowercase. How can I turn off this function?
Go to Tools / Autocorrect and uncheck Capitalize first letter of sentence.
"ngoc" <email@example.com> wrote in message
> Excel automatically change the first character in a cell to be
> uppercase. I just want lowercase. How can I turn off this function?
...Comparing first and last names in two lists
I have two data sources that each contain about 8000 names in seperate
fields for first and last name. I can put them on seperate worksheets
or append one to the other. I need to make them match and find out
where they don't. Messed with consolidate but not sure if that will
work for more than one column at a time. FYI data set one is from a
school transportation database and data set two is from the main
student database from the same school district.
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages dir...Can you separate information by House?
I have two homes and want to track expenses for each home separately as well
as roll up reports by category (utility, phone, etc.) for both. Is that
In microsoft.public.money, MT wrote:
>I have two homes and want to track expenses for each home separately as well
>as roll up reports by category (utility, phone, etc.) for both. Is that
One way to do that is to use a classification.
As Cal notes, Classification is tailor-made for this. Look it up in online
help and then come back with questions.
"MT" <MT@discussions.microsoft.com> wrot...can't find project or library
encounter this error : can't find project or library
when try to run a code which contains Calendar1.Value
Read the info on this page
It is possible you don't see it in the list, because it is installed with Access.
So if you don't have that program installed you possible don't have the control.
You can download the control if you don't have it (See link on the bottom of this page).
Regards Ron de Bruin
"Lynn" <firstname.lastname@example.org> wrot...How refresh imported data automatically?
In Excel, I've imported data into a worksheet. I know I can click Data..
Refresh Data to requery the source, but I want to be able to do it in a more
Is there some sort of macro I can write when opened or something?
Select the cell the data starts in, select Data/Import External Data/Data
Check the box "Refresh on file open" and anything else that needs checking
Other than that, you could record a new Macro that selects your cell,
refreshes data, and assign the macro to a keystroke, or even an icon.
...List Running Horizontally-Pivot Table Possible?
I just had a customer ask this one and I'm not so sure
1) The customer has setup a list of information that is
running horizontally instead of the typical list running
2) I just taught him how to do pivot tables and he wants
to generate a pivot table with his "horizontal" list.
3) I know he can copy and paste special and use the
Transpose feature to change the list from horizontally
oriented to vertically oriented.
4) the question is: can he leave the table in its original
orientation and still generate Pivot tables? I can't seem
to make it work ...Can I delete everything on MSN Money?
I seem to have lots of problems syncronizing my MSN Money
information with the web. It seems to work fine for a few
months, then, for no reason, I start to get syncronization
errors. I have signed up for multiple passports, because
when these problems start, it seems that I get tons of
multiple accounts. For example, on my one MSN Money
account I have 15+ old accounts that I can't delete.
1. How do I delete ALL of the information out on MSN
Money for my passport account?
2. How do I keep the syncronization from breaking in the
future? Any tips or advice would be g...I can no longer convert my files to pdf
I have Publisher 2003 and yesterday, my pdf menu on the top left disappeared
and I can no longer convert my Publisher files to pdf. I've even
uninstalled/reinstalled the Adobe Acrobat 7 and have also updated to 7.8 but
still no luck.
The next step was to uninstall and reinstall Publisher and still no luck.
Any one know what may be the problem? Thanks.
How are you trying to convert your files? When happens when you try?
MVP Microsoft [Publisher]
"darrellm" <email@example.com> wrote in message
news:A78B7B52-981D-4FB7-8625-EAD9...stop automatically changing formula!
i have a countif function
when i copy this and paste it to the next cell, the formula automatically
change to COUNTIF(Locking!J16:J40,"f")
How do I stop it from changing column I to J?!?!?!
MS Excel MVP
"caryn" <firstname.lastname@example.org> wrote in message
> i have a countif function
> when i copy this and paste it to the nex...Can't get rules to run.
I can't get Outlook 2003 rules to run. I am getting my mail from a pop3 account and would like to have new mail sorted to specific folders when it arrives. I set up the rules as I did in previous versions of outlook, but they do not run automatically. I can run the rules manually and they will move the mail.
I have this rule (for example
Apply this rule after the message arrive
and on this machine only
move it to the somefolder folde
I have tried deselecting on this machine only
Do you have an Exchange service in this profile? Are you using Cache...Rule to automatically mark header to download based on contact list?
Is there a way to do this, or an add-in?
On Tue, 26 Apr 2005 04:44:35 -1000, rmc <email@example.com> wrote:
> Is there a way to do this, or an add-in?
What version of Outlook are you using?
Ben M. Schorr, MVP
"Ben M. Schorr - MVP" <firstname.lastname@example.org> wrote in message
> On Tue, 26 Apr 2005 04:44:35 -1000, rmc <email@example.com> wrote:
> > Is there a way to do this, or an add-in?
> What version of Outlook are you using?
>...How can I reset the default pie chart label "Other" to "Equity"?
I show Cash, Equities, and Fixed Income in the large pie to the left. The
equity slice is further split into large, medium, and small. The problem is
that the Equity slice gets relabeled as "Other". When I manuallly change it
back to Equity, I lose the ability to link to any new data...so I can't use
the pie chart as a template that would allow me to put new data in the table
and have the pie chart adjust automaticially. How can I reset the default
pie chart label to "Equity"? or is there another solution.
Instead of making pie charts (which are notor...Combo
I am able to create a list of items with a drop down menu. I can
select specific item but how do I select all item to get a query
Your help would be much appreciated.
You can't select multiple items from an Access combo box. To do that would
require a listbox with it's MULTI-SELECT property set to SIMPLE or EXTENDED.
See more info about list boxes here:
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post ...List folders to file
Does anyone have a macro that would list all the folders (with path) and
subfolders to an excel sheet but not the files?
There's a function called CELL() that should return your filename (or
any of a number of parameters) but I can't get it to work properly on
my machine, so I can't make it work for you. The syntax is
=CELL("filename") which ought to return the path and filename of the
current file, and which you could then trim down to show just the path.
Can anyone provide some guidance here?
If it isn't working for you, it pro...Combining Lists within excel.
I'm hoping someone can help here. I'll try to explain the
problem I have.
I have 2 worksheets both containing a product list. I have
entries on one worksheet which I need on the other, so
basically my question is... might there be a way of
combining these two lists so one updates the other with
the missing entries.
Help on this would be great, as they are very large lists
which I dont much fancy the thought of looking through
Are you familiar with the VLOOKUP function? I use it all the time for this type
vlookup(Product cell in first sheet, Array...Disable people picker in a sharepoint list
I would like to disable the users/groups picker field in a SharePoint list
I managed to disable the field itself (text box) but it's still possible to
click on the "Browse" button and search for people that then get eneterd in
Is there a way to disable the browsing?
Thank you in advance,
I think you will delete that column.
1. Settings>List settings>Click you wnat column name on Colums category.
2. Click "delete" button.
And then you can make other column.
> ...Emails are automatically opening
When I select an email in outlook xp the emails are automatically opening the first highlighted email. Yes, ;) I have checked my settings in folder views - double click is selected, even if I reset it to single then back to double still no go. Also once I close a message, the next one automatically opens - just close not move or deletes.
...Services Invoices Get "DROP SHIP" box checked Automatically
This is a multi-part message in MIME format.
Hello Everybody, Here is another story.
we are GP 10 SP3 and we also a Field Service (Depot Module) installed =
for which we use an Invoice ( SVC000000) and our type is Service type =
At the time of posting the Service Charges being generated by the Depot =
Module, the Drop ship box gets checked automatically for which we can't =
charge the customer for shipping charges.
Basically we eve...