outlook 2000 automatically changing e-mail address
how can I prevent Outlook 2000 to automatically replace a
manually entered e-mail address for a contact with the
For contact "jim" I have an e-mail address "jim@abc" and
an email 2 address of "jim@xyz".
I want a specific message to go to the email 2 address
and manually enter "jim@xyz" in the To field.
When Outlook sends the message, it replaces the "jim@xyz"
with "jim@abc" and sends the message to that last
...Hiding "0" values in pivot table
In a worksheet I have a listing of stock records with ItemNumber, Date,
StockLocation and NumberOnStock. When I make simple Pivot Table with
ItemNumber and StockLocation as rows and select a Sum of "NumberOnStock"
I would like to hide rows where the sum is "0". But this does not seem
to be possible.
Tried to follow the guidelines in the Microsoft article:
But no luck :-(
You could use conditional formatting on these cells - highlight the
cells,...Hiding formuals in cells question
Hi. I was wondering if there was a way to hide the formulas in cells without
protecting the sheet. I am making something for other teachers at my school
and I want to hide the formulas so they won't mess anything up on the
spreadsheet. Any help would be greatly appreciated. Thanks!
not without protecting the sheet but why is this a problem for you?
"JP" <JP@discussions.microsoft.com> schrieb im Newsbeitrag
> Hi. I was wondering if there was a way to hide the fo...hide my name
When replying to an email or creating one from scratch how do i hide my name
in the "from" field...thx
fred <email@example.com> wrote:
> When replying to an email or creating one from scratch how do i hide
> my name in the "from" field...thx
Are you saying you want the reply to be anonymous?
Brian Tillman [MVP-Outlook]
no, I don't mind if my email is revealed.. just my name. I have tried by
removing it from the "User Name:" field in the email account but it
continues to show up. I have also removed from the header informati...How to change the name of a style
I have used some styles and their nme is no longer descriptive. How do I
change their name?
Some are styles I created and some are built-in but I am not sure which is
I use word 2003.
You can rename custom styles using the Organizer dialog box. To open the
dialog, click Tools | Templates and Add-Ins, and then click the Organizer
Built-in styles cannot be renamed, but you can add a style name alias: In
the Modify Style dialog box, just enter a comma (or whatever is the list
separator character for your operating system) and type in the alias. Wh...How to change a Version Resource field?
Is it possible to modify the Version Info resource
programmatically? And how?
For example, I wish to modify the Comment field of the
I appreciate any help and thank you in advance,
...Hiding and Un-Hiding Data fields
I am using a form for people to select data via dropdown menus and then
having it run through a query to filter results. Is there a way that I can
have certain feilds hidden until a toggle button or something of the like is
Basically I want have three choices of buttons: Year, Quarter, and Month.
What I ideally want to happen is when someone selects the button for year, a
hidden drop down menu appears where they can then choose from the available
years to filter through the query.
I would say I am above average with using access, but I have no idea how to
hide fields and then...No Users
I find that in any picklist relating to other CRM users, there are
none. For example, when I try to assign an opportunity to another
user, the dialog for select user shows no other users. The same goes
for territories, managers, etc..
Okay...I guess I'm new. I have to hit Go first.
...can I track IRA contributions?
I have several mutual fund accounts set up as retirement accounts, and
periodically buy shares in them as a monthly IRA contribution from my
checking account. Is there any way I can get a report at the end of the year
of all my IRA contributions for the previous year? You would think that by
running Reports->Taxes->Tax Related Transactions that they would show up, but
no such luck.
The category of each transaction in my checking account is Buy Investment/CD
which generates an activity of "Buy" in the investment transactions of the
mutual fund account.
I'm still on ...How do I hide gaps in an Excel 2007 chart?
I have a bar chart that is showing gaps and i don't want them. The select
data > hidden and empty cell button does not give an option to hide gaps. I
think by default they are hidden but if you even click on this to see what it
does the gaps are shown and no way to turn off.
If you hide the actual rows then with the Plot visible cells only
setting on the gaps will be removed.
In xl2007 the setting is on the Select Data dialog, Hidden/empty cells
> I have a bar chart that is showing gaps and i don't want them. The s...Hiding a worksheet #3
I want to hide a worksheet. So, I went to the format menu and the "worksheet" option is grayed out. Why? And, how do I "ungray" it.
is your worksheet protected ?
> I want to hide a worksheet. So, I went to the format menu and the
> "worksheet" option is grayed out. Why? And, how do I "ungray" it.
I think Frank meant to ask about the Workbook--not the worksheet.
(Check under Tools|protection|Protect workbook or Unprotect workbook)
My question is: Is there another sheet in the w...HTML signature in Outlook 2007?
Is there a way to insert an HTML signature in Outlook 2007? Because if you
go to Tools -> Options -> Mail Format -> Signatures, you can create some in
the embedded editor, but there is no way to do some *REAL* HTML editing (ie:
a table, image, etc).
Thanks a lot!
If you are thinking about an (animated image or similar)then you cannot =
in Office 2007. This is still possible in Office 2003 and before but =
this was removed from Office 2007
Please Reply to Newsgroup for the benefit of others
Requests for assistance by email can not and will not be ackno...Hide images when Hiding Rows
I have inserted images into cells, but when I hide the column the images
are not hidden with that column, they just get squished between the two
cells next to the hidden cell. Is there a setting or way to tie the
image to that cell so that it hides/unhides appropriately with the row?
kurt's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35686
View this thread: http://www.excelforum.com/showthread.php?threadid=554712
You cannot insert an image into a cell.
You can overlay ...Public folders not displaying for users with Author level permissi
One Windows Server 2003 with Exchange Server 2003 installed. Outlook 2003.
I created several new public folders a couple of weeks ago, and gave a
couple of dozen users Author access to them. I have not confirmed with all of
the users, but a couple of them can't see the folder listed at all.
Are the users permissions set such that they have the 'Folder Visible' right
selected? The Author role should give this, I think, but I'm wondering if
the problematic users are not Authors, etc and don't have this role
Exchang...How-to change receipt format font for an individual element
I have made a custom receipt from the receipt.xml that prints just the Item
Description Item Comment and Quanity to print to a networked printer in a
kitchen. How can I make the Font small for the Comment element[Entry.Comment]
(it is on a separate row) and leave the Description and Qty elements the
Large Font size of the Transaction Details Table? Below is the Transaction
Details Section of the receipt format. Is there documentation for the
receipt formatting anywhere? thanks in advance for any help
=================...Hiding plot Area
I have a formatted output sheet that has a Pie Chart
embedded. The data for the pie chart comes from a second
sheet using 2 ranges B2:B6 & D2:D6 B2:B6 is always
populated and contains labels. What I want to do is, when
D2:D6 contains 0 in each cell (or Null), suppress the Pie
chart but always show the Legend (which is driven by B2:B6)
All you see of the pie when all values are zero is a single line at the
first slice. The legend still appears. To hide the line, double click on
one of the wedges and on the Patterns tab, change the Border setting to
None. ...Change of Address
Where in Money 2004 Small Biz do I change my address and phone? Can not seem
to find where that gets set.
...Message Tracking #22
I have enabled Message tracking on Exchange 2003 and all works fine. But is
there a way of seeing the message content/message body?? As this would really
handy to see what is being sent through our mail system.
On Mon, 20 Feb 2006 02:34:35 -0800, Damen Barker
>I have enabled Message tracking on Exchange 2003 and all works fine. But is
>there a way of seeing the message content/message body?? As this would really
>handy to see what is being sent through our mail system.
Be careful what you wish for howeve...how to hide an ActiveX control?
i have an ActiveX control, written in C++, which has the
OLEMISC_INVISIBLEATRUNTIME flag set, yet when i display the web page
it is attached to, i get the familiar "red cross" graphic in the
middle of the screen - how can i hide the control so nothing is
displayed at all?
can u set the size of ur control as 1x1 pixels
"bhu Boue vidya" <firstname.lastname@example.org> wrote in message
> hi there
> i have an ActiveX control, written in C++, which has the
> OLEMISC_INVISIBLEATR...Hiding rows with VBA
In my sheet called "insertsheet I have this VBA:
(thanks to some users of Google groups)
Private Sub Worksheet_Change(ByVal Target As Range)
Const nMAX As Long = 10
Dim nRows As Long
Application.ScreenUpdating = False
If Intersect(Target(1), .Cells) Is Nothing Then Exit
nRows = .Value
.Range(.Cells(1, 5), .Cells(1, _
.Columns.Count)).EntireColumn.Hidden = True
.Range(Cells(1, 5), .Cells(1, _
...Free Credit Reporting? Only for new users?
I have been using Money for several years. Used Money 2005 and upgraded to
2006 shortly after it became available. Up until this morning I never tried
to access the free credit reporting option available through Money 2006.
When I tried this morning, I started by following the "sign up now" link in
Money. After filling out the web form I was directed to, I was informed that
I already had an account. (That account has expired, so all I have is a
login that doesn't actually take me to a credit report.)
So, I went back to Money and clicked on the "Already signed up?"...Migrating to Outlook 2007 on Vista
I am not very familiar with Outlook. A friend is upgrading her computer,
she currently runs a laptop with XP, an old version of Office, Outlook
something for calender, and OE for mail, she's asked me to help. The new
system, a chunky desktop, has Vista Business edition and Office 2007 Business.
I know we can't have OE on vista, and I understand that the Vista mail
client (Windows Mail) has a somewhat limited future.
My impression has always been that the reason people used OE rather than
Outlook was that the latter mandated access to an Exchange server.
Is this still the c...Migrating Project Server 2007 from WSS 3.0 to MOSS 2007
Does anyone have experience on how to migrate from WSS 3.0 TO MOSS 2007 ?
What are the proper steps ?
Any online documents that could help the migration ?
...Add a comma at the end of a word in a cell
I have cities in a column and I would like to add a comma at the end inside
the cell. how do I do that?
Say your cities are in column A. In a helper column, enter =A1 & "," and
copy down. Then copy the helper column and paste/special value back into
your original column.
> I have cities in a column and I would like to add a comma at the end inside
> the cell. how do I do that?
I'm assuming you want a formula for this.
With the city in A1:
=A1 & ", "
The formula above also includes a space afte...hiding rows
I have data in cells A7:DK394 which all have 0 in them until totals are added
in other worksheets which then pullthrough.
At the end of the week I have to Hide all rows from A7 to A394 that still
have 0 in them as no totals have been added in other sheets so the customer
has not posted with us.
is there any way excell can recognise the cells that have no data against
them and hide them automatically by pressing a button. or if they all start
off hidden unhide as data is entered.
Hopefully this makes sense
many thanks for any help with this as again its to save me lots of...