Format Cells Date (or any change) not working on imported data
I've just spent ages researching this and not come up with what I need
to be able to do.
I have a worksheet for some simple data that has been imported, a
date, text and number column (as they display graphically to the end
user). All are a "general" format when using Format > Cells.
The issue I have is that the date information is in an American date
format and I would like to change them into a UK date format. Format >
Cells and selecting any option (including custom and special) makes no
changes to the imported data.
I have seen the work arounds whereby you sp...Outlook Mobile Access Problem
Hi I've a big problem in Outlook Mobile Access.
I've a server exchange standalone withoput a front-end=20
I've configured the OWA web form authentication and SSL.
For OWA it's all right...everything is going right...
The problem is OMA
When I try to log on on oma I find the following error=20
message :"Unable to connect to your mailbox"
To solve my problem I've found in microsoft web site the=20
Microsoft Knowledge Base - 817379
Cannot Access Exchange Server 2003 by Using Outlook Mobile=20
Access When the
Exchange Virtual Directory Require...How do i get outlook to update hotmail account without reopening?
the tedster <the email@example.com> wrote:
Ask your question in the body of the message.
Without reopening what? Outlook? Hotmail? The short answer is "you
...outlook 2007 runs slow
Outlook 2007 runs slow. Is there a way to speed it up.
Do you have the outlook performance update installed?
Are you using a Dell laptop?
Did you upgrade from an older version and are still using that profile?
http://www.slipstick.com/outlook/ol2007/slow.htm - install the update
listed at the end - also make sure all OS and Office updates available
through Microsoft update are installed. If it's still slow, try the various
solutions that apply to your situation.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Ta...can't send anything in Outlook 2002
I just sent a post asking for help because I can no
longer send email with attachments. After sending in the
post, I went back to Outlook and clicked on the
Send/Receive button just to check if I had any new mail.
I got the same message: "The operation failed". So I am
totally out of business with Outlook. How to solve the
Did it work before? Did you change anything in yr settings? Are you sure
your internet mail account settings are valid (correct username, pw,
"Marilyn Fogelquist" <fogel@cablespeed........Illegal operation error while printing EXCEL or WORD Files
I am facing an illegal operation error when i try to print any file from
excel (any no. of pages), this happens in stand alone printer as well as a
When we press the print button, it flashes this message, but still prints,
but once the printing is completed, i will have to restart the PC. Due to
this error other applications PRINTING also will NOT HAPPEN and the only way
out is, restart the PC.
This happens not only in EXCEL, it happens in all the MS applications
(outlook, access, front page, powerpoint also).
When I check the print manager (before restart),...outlook 2000 help file
Seems after I did added SP3 from MS upgrade site my help from outlook has
quit working. message is msohelp caused error in itss.dll. help works in ALL
other programs including outlook address book. I'm running windows 98 SE,
Office 2000 SB and IE 6.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.542 / Virus Database: 336 - Release Date: 11/18/03
...allowing or disallowing changing the state of check box
what's the best moment to check if the user has right to change the state of
check box and then to allow it or cancel it. I've tried with "before update"
event procedure. It seems to work but after, when I press anything else on
the form event procedure is repeating?
The problem occurs (repeating) when Cancel = True was applied previosly.
> what's the best moment to check if the user has right to change the state of
> check box and then to allow it or cancel it. I'...ActiveX Control in Word
I have a couple of issues with an activex control developed in MFC targeted
for Office. In Powerpoint, when the user right clicks on my control and
selects "Edit", my control starts receiving mouse and keyboard input, since
it becomes active. However, in Word when the user selects Edit, the control
does not recive any input. But if I click the design toggle button in the
Control toolbar, the control goes active and recives input. I would like my
control to be activated in Word the same way as it gets activated in
Powerpoint, is this possible?
The second issue is, when...How to do a mass download of names to Outlook address book
I have about 800 names and email addresses in an Excel
spreadsheet that I need to add to my Outlook address book.
Can anyone give me a hint on how to do this?
Save the Excel Spreadsheet as a CSV (Comma Separated Value) file and then in
the Address Box, Click, File, Import, Other Address Box, then click Text CSV
file and browse to it.
"Hal Segal" <firstname.lastname@example.org> wrote in message
> I have about 800 names and email addresses in an Excel
> spreadsheet that I need to add to my Outlook address book.
> C...Excel Edit F2 button changed for Mac???
Switched to Microsofts version of Excel for Mac. Can anyone tell me
what keystroke allows me to edit a cell? Before I switched to a Mac
it was the F2 button. Please help. Thank you.
See the answers in the m.p.mac.office.excel newsgroup.
In article <email@example.com>,
> Switched to Microsofts version of Excel for Mac. Can anyone tell me
> what keystroke allows me to edit a cell? Before I switched to a Mac
> it was the F2 button. Please help. Thank you.
...MSN accounts dosen't work in Outlook.
I can't download my e-mails from MSN to Microsoft Outlook 2003.
I have setup the account correspondent to Microsoft Outlook 2003 Wizard, but
it still dosen't work.
Does anyone know where the problem can be?
Only the paid MSN and Hotmail accounts will work in Outlook and/or Outlook
Express. Are you supscribed to the paid service?
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"hardharut" <firstname.lastname@example.org> wrote in me...Entourage docx Attachments and iPhone incompatibility
Operating System: Mac OS X 10.6 (Snow Leopard)
I've tried to get a response on this in the Office forum with no results. SO, I'm trying here. <br>
Is there a solution to the problem where docx attachments sent from Entourage cannot be opened on the iPhone? <br>
Attachments from Entourage come up as invalid file format on the iPhone. <br>
If the same file is sent from Apple Mail or Google Mail, it is fine. <br>
What is the solution, and why are MS taking so long to resolve this?
On 2010-03-24 16:15:15 -0400, imacken@offic...Outlook 2003
I copied my PST file from my D: drive to my F: drive.
I then went into "Data File Management" to get the new location
recognized and to have all future mail sent to that location.
After doing this, my custom settings, like new folders, date
settings, columns, etc, are all back to their default settings.
Is there any way I can get my custom settings working again on the F:
Could you explain yourself a bit more? What custom settings are you refering
to? You mean views? And what new folder settings?
Also post your version of Outlook.
Robert Spar...Outgoing emails not sending for outlook express 2000
Can anyone help me?Everytime I try to send an email these
error messages pop up and I have no idea what to do;
The host 'SMTP' could not be found. Please verify that you
have entered the server name correctly. Account: 'POP3',
Server: 'SMTP', Protocol: SMTP, Port: 25, Secure(SSL): No,
Socket Error: 11001, Error Number: 0x800CCC0D
The host 'POP3' could not be found. Please verify that you
have entered the server name correctly. Account: 'POP3',
Server: 'POP3', Protocol: POP3, Port: 110, Secure(SSL):
No, Socket Error: 11001, Err...Default font for PowerPoint slide
PowerPoint Office 2001, Mac OS 9.1
Is there a way to set a default font so that every time I choose a blank
presentation from the options shown in the "new slide" box that appears,
the default text font and its various attributes will be as I want them
-- say, Arial 24 pt.
Right now every time I open a new blank slide, the default text font is
Times 24 pt. How did it get to be that?
Thanks for your patience - you can see that I don't use PP very much.
I've also posted this to the microsoft.public.mac.office.powerpoint
-Barb, <www.jamlady.eboard.c...deleting fonts
My computer uses Vista Home Premium. I just had to reset it to its original
state. I'm trying to delete fonts, but don't have permission. I am the only
user of this computer and its administrator.
When I've gone into the Fonts folder Properties - Security tab, the option
for Special permissions is grayed out. When I click the Advanced option
("For special permissions or advanced settings, I don't know what to do next.
Can someone please walk me through how to get permission in the Fonts folder
so I can delete fonts?
On Wed, 6 Jan 2010 07:...Outlook 2003 Contact data
Just starting using Outlook 2003.
When composing an email, when go to address the note, it appears that there
are 2 Contact files - 1 is "blank" and the other has lots of my contacts.
It is the latter contact file that I enabled to use as my address book.
Initially address book comes up the first one and I get error message. Then
I toggle to the second one and all the names are accessible.
How do I get rid of the one that appears blank, so only one contact file
appears when I go to address an email?
Les <email@example.com> wrote:
> When composing an e...powerpoint texbox issue
Sorry for posting this twice but I could not find my previous post, but I
really need some help here.
We have a ppt 2007 problem. The problem is on our CEO's computer too!
We have ppt 2007 with all updates/service packs. The user will create a
textbox in powerpoint and starts typing, then saves the ppt file. When the
user goes back into the ptt file and clicks in the textbox and starts typing,
"randomly" the font will increase and the user has to set the font back.
Why Microsoft, why? This person uses powerpoint probably more than anyone
at our company, sin...Globally change part of a field
I have a text field that holds the file location of a picture. The content
looks like this:
H:\Access Data\Personnel Pictures\picturefile.bmp
The "picturefile.bmp" is different for every record. Everything preceding
it is identical in all records.
I've moved the folder with all the pictures to a new location and need to
update this field to the following:
S:\Everyone\Member Database\Personnel Pictures\picturefile.bmp
So basically, I need to swap out "H:\Access Data" for "S:\Everyone\Member
Database" in every record.
Thanks in advance.
Jer...outlook 2003 memory leak? /messages display as"none" and eats up memory
When a certian user opens outlook, and clicks on sort by
size, half of her e-mails disappear, and "none" is
displayed. She said this happened to her at home, except
she was on her normal view which is sort by date. The
only way that I can recreate the problem is to click on
sort by size.
If you click on one of the "none's" or even hover the
mouse over it, the memory will spike up! I had the
performance tab open while I was doing this, and the
memory being used was read at 1.46 GB! And if I close
outlook the memory drops down to normal. I took ...Outlook 2002/XP Folder List view question
Any assistance would be greatly appreciated. I have a user still using
Outlook XP and has the following issue.
Outlook does not remember the folder view settings. User has folders under
the Inbox folders and of those folders some are expanded and some are
collapsed. When he closes Outlook it does not "remember" the folder settings.
The user would like for Outlook to remember the settings because it has in
the past. Is there a way I can get this back?
...Debugger comes up when attaching files to Outlook 2002
I have a pro bono non-profit client running win xp sp3 & ms office pro.
Last week she reported that every time she tried to attach a file to an
outlook email, she received a dialog asking her if she wanted to start
the debugger. It never allows her to attach the file and if she goes
through with starting the debugger, she gets a variety of errors...
never a repeating error.
Anyone have any experience with this error?
...Changing Posting Settings
I just wanted to double check that if I am currently Posting TO General
Ledger in the Purchasing Series, if I change that to Post THROUGH General
Ledger will this have any ill effects.
I would make sure everyone is off the system, however if there are batches
in the GL that were generated by the AP subledger is this ok and would it
then post through the general ledger for any new transactions posted once I
change this option?
You are fine. Manual post any GL batches. You can do this before or after you
change the option.
> I just wanted to double che...Outlook should be able to email MS CRM advanced find queries (grou
The only way to e-mail a group in MS-CRM is to use the Quick Campaign
function. The Quick Campaign has several disadvantages:
- attachments for emails are not possible
- this takes at least about 10 more clicks compared to sending a standard
- the quick campaign doesn't have the look-and-feel of Outlook to which
users are accustomed to
Therefore it would be great if you could select the emailaddresses from
groups retrieved from MS CRM into the TO:, CC: or BCC: field in a standard
Outlook email message. Actually you would make the advanced find queries
available to sel...