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...manipulated a data file in excel
Is there any way to have a button in excel where when I click on it, i
will let me choose a data file (by pointing and clicking) that's comm
delimited and I can simply sum up an array of numbers and import tha
sum into a cell? I don't want to put the text file into th
spreadsheet, but rather just sum of the numers I want into a specifi
skinnydude's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1627
View this thread: http://www.excelforum.com/showthread.php...MS excell 2007 Data verification list
I am attempting to use the list function within data verification for drop
down menus. I need a list that is conditional upon the information in
Example: The first cell offers a drop down menu with specific Make of
equipment. From what appears in that cell I seek to offer only the Models
for that Make of equipment on a list in another cell. I considered using a
series of IF statements to run macros however I don’t know how to invoke a
macro from within a formula. Any suggestions?
See Debra D...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...password & 01 data
Hi, I bought an oem product on e-bay & can't get the free
tech. support. Any assistance appreciated.
I installed 04 & money asks for a password. Beats the
heck out of me. No recollection of using password before
in 01. Tried all kinds of e-mails, passport, .net, etc.
No go. Need assistance.
Also, once in 04 how do I access my 01 data. I
downloaded 04 trial of the ms site. Never could open the
Thanks in advance,
...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...Consoldating Data
I have a spreadsheet with 57 columns of data. I'd like to
figure out a quick way to have all the data (text) into
just one column. I don't want add or multiply anything...
just want all the data in 1 column.
You can use a function like this one
Copy the function in a normal module
Use this in the worksheet
From J.E. McGimpsey
It is working for rows an columns
Public Function RangeCat(rng As Excel.Range, _
Optional delimiter As String = "", _
Optional direction As Integer = ...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...Mailbox management Deail report data
I find that the output of the mailbox management detail reporting has a
little too much detail for my liking. I would like to see a list of the
folders containing old/big mail. I really don't care about all of the
folders with no items that qualify for my criteria.
Is there any way to get at that information that does not involve me parsing
the text report? The data is there. It's just not in a very usable form.
It a perfect world I'd love to use crystal reports to query exchange and do
some of my own reporting.
Got any ideas?
...Restore data from MDBDATA folder
i have a problem with recovery data.
On the server there was Exchange 2003 Standard SP1, but it crashed and we
saved only data from MDBDATA folder.
New server is W2k3 with Exchange 2003 Enterprise SP1 (we don`t have an
installation media of standard edition at this time). Then i flagged new
databases as rewritable with restore, unmount and replace an *.edb
databases. Then, when i want to mount databases i get error message "An
internal processing error has occurred. try restarting Exchnage System
Manager or the Microsoft Exchange IS service, or both. ID no: c1041724." The...Resizing columns [same data source]
I have created a chart where data results from the same source and of the
same kind. But the results of one column are very higher than the others
resulting in a disproportionated first columns which makes the chart
difficult to read for the readers. I often saw charts in publications where
the higher colum is "broken" in the middle, making the chart more
Can anyone help me on this?
Here is an illustrated tutorial, with links to a couple others as well:
Jon Peltier, Microsoft Excel ...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 ...Column Header that moves with Data?
Does anyone know if it is possible, and if so how to have a colum
header move with the data?
I have a sheet with a ton of data and the list is growing, I would lik
to see the column header "float" with the list instead of having t
scroll to the top and check it out.
thanks for all help
Message posted from http://www.ExcelForum.com
if i'm understanding correctly -
click in cell A2 and choose windows / freeze panes
to undo it choose window / unfreeze panes
"wendellarina >" <<email@example.com> wrote in
mess...Multiple series not plotting in their respective data ranges
I have a price comparison chart (line chart) that has multiple prices for
Price 1 has a date range of 01/01/07 - 02/06/07.
Price 2 has a date range of 01/19/07 - 01/31/07 (a subset of the Price 1
range). When Price 2 plots, it starts at the left of the overall range
(01/01/07) and stops at 01/13/07 instead of plotting in the middle of the
chart starting at 01/19/07 and ending at 01/31/07.
Is this a bug or is there a parameter setting I need to tweak?
If you want to plot one variable (price) as a function of another variable
(date), you should be using...Data Lookup or query?
I have two fields (text boxes). Text box 1 is a Location and always
has data inputed. Text box 2 is an Sub Location but only sometimes
gets data inputed.
I would like to be able to pull up that if Text box 1 is being filled
in that prior data that matches pulls up and also if there is any
matching data for Text box 2 that it would get filled in autmatically
I guess almost like a combo box where it will recognize from a query
or whatever, but then also automatically fill in the next field (text
You could change the text box 1 to a combo that has both the value for text
box 1 ...How retreive specific data from 1st Sheet and placing it on 2nd Sh
Looking to search a range of cells in Sheet1, find specific data and place it
on Sheet2. Does anyone have a way of doing this.
Range of cells in sheet one will be updated periodically and cell range will
grow with it.
Need more information: are you looking for some value such as a name and want
to return another value based on the name?
What ranges are involved, and what type of data is involved?
Is the location on the second sheet always the same or will it also be
changing over time?
Sample of "before" and "after" usually helps bigtime!...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...Data File Problem
I just switched from Quicken 2005 to Money 2005 and I was just starting to
like Money when the following happened. I had money 2005 running smoothly
when I needed to re-load windows on my PC. My Money 2005 data file resides
on a Microsoft 2003 server, where it can be automatically backed up. After
formating and re-installing Windows XP I proceded to install Money 2005.
After the Money 2005 install I tried to access my Money data and I get the
following error message.
Money cannot locate 'X:\Users\BobG\Money\my money.mny" or cannot open it,
possibly because it is a read-only fi...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"
>...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." <firstname.lastname@example.org> wrote in message
> I have tried the unsuported fix inv...Moving Row data to sheet
I have an Excel problem and I was wandering if anyone could give m
their 2 Cents worth.
Let me explain. I will have 2 worksheets Lets say A and B. In Workshee
A I have rows and rows of data. In worksheet B I want to create a for
(not excels form one written in the spreadsheet itself no VB) that wil
contain info from each row singly only. Like for example....
Sheet A : Row 1 Name, Phone, Address
Row 2 Name, Phone, Address
Sheet B: From highlighted row 1 Name Address
What I would like is each time you click a row the info changes i
sheet B. I know this is done in Access very easily with...Calendar View?
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...