Our CEO has several email aliases configured on his Exchange account. For many months he has one email address that is receiving all spam emails. The problem is that when you open the message,...
Hello
Following Example :
=A1*E20 : A200 * E200
But i get a VALUE error.
Some of the cells are blank i..e no value and no space
I want the formula to first to a1 * e20 and do it...
Please i need to add the bloomberg toolbar in outlook 2007. Is there a way to do it?
There might be an easier way of doing this but
I have an excel sheet with columns A and B frozen so they are visible when scroll right.
I have a text in row 1 merged across columns A to ...
In an update query can i trim off the end characters in a field? My field (add3) contains city state zip. (Dallas TX 750921111 or Dallas TX 75092) I need to split the data into 4 different C...
Hello,
I need some insight and how to do this.
File 1, worksheet1 - 153 rows, File 2, worksheet1 - 132 rows.
the 1st column name in each worksheet file is "Customer" contains all Cu...
I use VBA to run the shell command to open a new access database from my current database. If the directory name is one word I have no problem. If the name has a space in it I keep getting an ...
I have UserForm1 that has a ComboBox1 on it. I would like to use a VLOOKUP on the result of the combobox to see if that value already exists anywhere in column D of the current sheet. If it ...
I have one user on a Terminal server that is missing all of her tabs in Word 2007, except 1 tab from an add in product. How do I get the other tabs back?
I have a power point presentation w/ graphics that is 19MB. I have used the compress option to compress all pictures for WEB; however, this had a minimal change. Is there a way it identify w...
I have an HP Pavilion dv2000 notebook. When I press the power button all the blue LED Lights come on (Volume +, Volume -, Mute, power, ... ect) but screen stays blank. I hear the HDD spin up, ...
I have a budget sheet I am creating and I have a row which will have a header which says either ACTUAL or ESTIMATE. Just below this header is a DATE (MMM-YYYY). I want to compare the date to "...
Hi,
I would like to place application shortuts (i.e. Word, Access, Excel) on the menu bar at the bottom of the screen.
I create the shortcuts, place them on the desktop, and then try t...
I have the following expression that only works in some fields: Expr1: ([YOS]-[YNOS]+[Grandfathered Time]). The YNOS is created based on dates, could it be that should there not be any dates...
I made a boo boo and need to go revert back to an earlier version AFTER saving the file. Can it be done?
I have just installed Microsoft Office Professional Plus 2007 on Windows Vista Ultimate, but the spellchecker is not working. When I try to spellcheck in Outlook or Word I get a message that s...
I need to convert an .HTML page to a Word 2003 document. Save As does not work. There is an image on the page that comes up as a red X.
Anything else I can try?
Thanks.
I'm having a hxxx of a time trying to use vlookup to look up values.
sheet 1 I have a column with a text string (names)
Sheet 2 I have a mulitple columns of text and values (names and payr...
I have a client trying to open a word document off the network drive. He is running XP and Office 07, the server is Win 2k3.
Whenever he opens a document off the network it begins to load a...
Installed Adobe 9 and all my word document changed to PDF format, how to change it back?
Hello,
What would be the Pro's and Con's of upgrading everyone in the office from Office 2003 to Office 2007? Would this be a major ordeal?
I have two columns in Excel, ie. A2 and B2.
if B2 is not blank, I want to make A2 blank.
If B2 is blank, I do not want to change the value of A2.
Greetings,
I upgraded my Office suite from 2003 to 2007. I understood that Outlook 2007 would perform an upgrade, leaving all previous calendar data intact, however, it seems that appointmen...
Hello,
Here is my problem. I have a basic summary data reflected in two columns (A & B). Column A has ID# and column B has numerical values. ID# is connected with multiple numbers. For ex...
Experts,
I've set several task reminders in Outlook 2007. I can see them with the little alert bells if I open the Tasks section, but I never get a popup window that tells me about the eve...