Mail Messages HTML Viewing
I am using win XP and Office 2002. When I receive
messages with html format i can only see the url's and
not the pictures. I have checked all the settings, I
have the box in options/mail format/internet
settings/html format checked to receive pictures and
still just the url. I runn norton and zone alarm but
can't see any settings in these that would restrict the
downloading of pictures. Any thoughts?
What are your IE settings?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to the
Swen virus, all e-mails sent to my actual...go to next cell and paste question
I am writing a macro that is supposed to take certain cells from a
"interface" page, remove them, and paste to a string of cells o
another. That is easy, but I cant figure out how to make them go t
another set of cells, if the ones I recorded are filled.
' Macro1 Macro
' Macro recorded 8/4/2004 by Lane Lacy
ActiveWindow.ScrollColumn = 239
Application.CutCopyMode = False
Sheets("productivity&qu...the webpage you are viewing is trying to close the window
We have an internal web interface for our helpdesk system. When we finish
working with a "call" it attempts to unlock the call and we get the message
as above. More often than not, we need to say YES to the message. Any ideas
how to get it to not appear?
Which security zone does the page/popup load into?
Hint: Is IE configured to automatically detect sites in the Intranet zone?
What 'call' software are you using? Have you attempted to contact the
"Keithmeister" <Keithmeister@discussions.microsoft.co...hiding 0 from a cell
I can't figure out why this doesn't work, I keep getting circular references.
i have 3 workbooks. 1 is a summary linked to other 2 which are stored in a
different drive. The summary is I:\abc\etc\[summary.xls]sheet 1'!$d$6).
At the moment the cell inwhich this reference sits has 00:00 which is
mm:ss. I want this cell to remain empty until the cell from which it is
linked is populated with a figure.
The response is "the formula you typed contains an error etc etc.
I followed what I thought I had to but...Using custom document peroperties to creat views in Public Folders
How do I use custom document properties to create views in public folders? I
came across an article for Outlook 2000. I tried doing this for Outlook 2007
but I am unable to. Please assist.
The article I came across was
http://office.microsoft.com/en-us/publisher/HA010549541033.aspx However this
only appears to work for 2000 not 2007. Hopefully someone can help.
> How do I use custom document properties to create views in public folders? I
> came across an article for Outlook 2000. I tried doing this for Outlook 2007
> but I am unable t...m_pDocument Doc/View unique id for each view
I'm using the standard mfc mainform with a doc/view. While I'm in the
view portion I need to track the actions taken individually and
separately for each view. So when when I click on view one I track
that in a separate place than view two.
I there a unique id or index for each view? Something like
<firstname.lastname@example.org> wrote in message
> I'm using the standard mfc mainform with a doc/view. While I'm in the
> view portion I need to track the actions taken...View Webpage
How can i view a HTML page in Excel, it should also be automatically update
in 60 seconds. Is this possible?
Please note that, that page contains images
That webpage is on our intranet website.
Though I am not certain this is exactly what you are looking for, try the
Data, Import External Data, then New Web Query...
In the dialog box that appears, browse the site. You will notice that at
certain areas of the page you will see an arrow. Just click the ones that
you want to import. Click import. Select the cell you want to import the
data into and click OK.
Hope...automatically highlight cells with expired dates?!
i'm trying to automatically highlight cells in Excel with expired dates. is
this possible? i cant figure out how to do it unless i do it by hand
You can do it with conditional formatting. Format: Conditional Formatting:
Cell Value is less than e.g. 7/31/05, Format: Patterns: pick the color you
want. Apply this to your cells. You should be good to go. Only draw back
is that you wil lneed to update this way of doing it as the date changes.
> i'm trying to automatically highlight cells in Excel with expired dates. is
> this possible? ...How can I test the text content of a cell
I wish to create a logical test - an IF statement that tests whether a cell
contains H, M or L, and output the result as a number.
I cannot get the IF statement to recognise text as true or false - my Excel
2007 gives an error when I try to do something like IF(E9=H ....) is there a
way to do this?
Gord Dibben MS Excel MVP
On Tue, 16 Mar 2010 16:43:01 -0700, catefaulkes
>I wish to create a logical test - an IF statement that tests whether a cell
>contains H, M or L, and output the result as ...Forms in two differant views
Is there a way to use the same sub form showing two differant views within
the same Main Form. For example: Can I show on one tab a datasheet view and
on the other a regular form view.
Create a button on your form and under the "OnClick" event put
'Me.DefaultView = Datasheet
Alternatively you could use a checkbox
If me.checkbox1 = 0 then
Me.DefaultView = 2 ' Datasheet
Me.DefaultView = 0 'Single Form
This should flick the form between datasheet and form views.
> Is there a way to use t...Forcing a view to be the active view
I have an SDI application that has a splitter window with two views. The
first view is an CFormView and the second is a CView. I want the CFormView
to always be the Active view. Even if the user selects the CView.
How do I accomplish this?
Anders Eriksson wrote:
> I have an SDI application that has a splitter window with two views. The
> first view is an CFormView and the second is a CView. I want the CFormView
> to always be the Active view. Even if the user selects the CView.
> How do I accomplish this?
> // Anders
I'd ...OL98 start up view
I recently had to reinstall my WInXP and now my OL98 has a couple of
issues I'd like to fix.
I've set up my mail account (with POP3 and SMTP servers) but when I
try to use it I get a message saying that internet mail is not
registered properly. What do I need to do to fix this?
Also, I used to start up OL98 so that the first view was not Outlook
Today. How do I change that?
I guess I can't remember how to do things that I only do once every
Thanks for any suggestions!
You might want to have a look at this MS KB ...Changing View -- All Folders
Using Outlook 2007, Windows XP Pro. I have dozens of mail folders in
Outllook. I would like to change the view (to the right of the folder
tree) on all folders. There seems to be no apparent way to do this.
Any ideas? Thanks,
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EAS...formula in cells
I'm going to try and explain this a little better and give you the actual
cells that I am trying to calculate:
I have net pay in cell B8,
withdraws in cell C8 and
the Balance in D8.
I would like row D to add B, subtract C and display the balance.
So when I put in the next paycheck on B9, D9 will reflect the amount from
D8, add to it B9, subtract C9 if a value is there and display the balance in
D9. I would like the cells in Column D for the last value entered to be
blank until data is entered into them and not display the last balance the
whole way down the spread sheet. Does this...Coustom view
I have been given a new work station and for some reason my custom view is
not highlighted and is not working.
I don't think it is as add-in feature. Excel heip has not been of any (help).
Does someone know how to enable this feature?
Custom Views will be disabled if you have more than one sheet selected.
Do you see [group] behind the filename on title bar?
If so, right-click on a tab and "ungroup sheets".
Gord Dibben MS Excel MVP
On Wed, 11 Jan 2006 06:28:03 -0800, "Michael"
Outlook 2000. This seems like a dumb question but in the monthly calendar
view how do I get it to show a regular standard Sun-Sat week with equal
weight for each day (Sat & Sun the same size boxes as the rest of the
right click on the calendar and choose Other settings. Uncheck the option to
compress weekend days.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.ne...Copy tab name to a cell or opposite
What is the the index of the name of the tab? Who can I get the tab name
autmatic to a cell or the other way around? It will be nice to type a name
once - no mistakes and time saving when you use a lot of pages (sheets) and
refere to form the first sheet in abook.
Try the below formula to retrive the tab name to a cell...To name the tab as
per cell you would require a VBA solution
> What is the the index of the name of the tab? Who can I get ...Modifying Activities associated view 10-01-04
I have tried the unsuported fix involving:
The view opens fine but I am unable to save as is or make
changes... I get the message "the Item Id is invalid."
Make sure you include the braces around the view ID GUID.
"Sean T." <email@example.com> wrote in message
> I have tried the unsuported fix inv...Do Not count blank cells
I have been trying to figure out how to NOT have excel count blank
cells when it is counting my information that my formulas are telling
it to count. This is my current formula (array):
I have to put a space in each blank cell (which could be a bunch)
imjustme's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26854
View this thread:...Date format of cells
I am downloading a result to excel and there are date formats in that result.
When I copied thedate formatted cells and paste it to a new
workbook/spreadshhet..the dates are changing into numbers. I tried doing this
by using another computer and the results are fine, I can copy and paste the
cells as is to another workbook/spreadsheet. Is this set-up related? If so,
can you please help me configure my excel so that I don't have to re-format
the cells to date format.
Any chance you're viewing formulas in the worksheet you're pasting?
Tools|options|View|uncheck ...Custom Fields in Views.. 04-22-10
We are working with a MOPS 2007 and WSS 3.0 SP2 (no c.u.'s) environment, and have created several enterprise custom fields at the task level. We can use and see them just fine in the schedules in Project Professional 2007, but when we try to add them to the 'my assignments' and 'assignment details' views, the custom data does not show up....any thoughts?
Thanks! and have a great spring!
Submitted via EggHeadCafe - Software Developer Portal of Choice
Get Silverlight 4 Installed: Tips and Tricks
http://www.eggheadcafe.com/tutorials/aspnet/05910e...Text editing in a cell
How do I insert a line break within a cell when I am writing a line
of text?? - when I press enter I go to the next cell!! Help
> How do I insert a line break within a cell when I am writing a line
> of text?? - when I press enter I go to the next cell!! Help
...How can I set View as HTML as the default view...
I am trying to use a news group in which the dominant form of message is
based on HTML. But my Outlook news reader forces me to manually turn each
message into HTML which is a pain. It must have changed with some security
update. I want my old settings back!
Henry Stock, Network Administrator
3 Wing Drive
Cedar Knolls, NJ 07927-1006
Henry Stock <firstname.lastname@example.org> wrote:
> I am trying to use a news group in which the dominant form of message
> is based on HTML. But my Outlook news reader forces me to manually
> turn each message into HTML which is a...Filmstrip view
I have some windows that allow the filmstrip view and others that do not. I
have researched this and what I found was:
1. Select "View" - "Customize This Folder".
2. The folder properties multi-tabbed dialog box will appear. Underneath
"Use this folder type as a template" choose "Pictures" or "Photo Album" as
3. Click "OK" to close the dialog box.
The "View" - "Filmstrip" option should now be available.
I have followed the instructions, but I still don't get the option for the
fi...Calculating rents and months past in 1 cell???
I´m making a Worksheet to calculate the Residual Value of car at the time
the worksheet is open.
So i have colums with the "inicial date of the contract", "Final date of the
contract", "the monthly rent", and the "car value when purchased".
With this colums i need to calculate the value of the car at today date.
This columm as to do this:
"Value of the car when Purchased" - (MINUS) "rents payed since the begining
of the contract until todays date".
How can i make excel calculate this.
To find out the num...