How can I stop excel completing text when I enter data e.g. if a line above
says "study day" I enter the line below "student" when I enter "s" it will
automatically enter "study day", how do I stop this?
Tools>Options>Edit tab - uncheck 'Enable AutoComplete for Cell Values'
> Tools>Options>Edit tab - uncheck 'Enable AutoComplete for Cell Values'
You may know this, but when the autocomple...Exporting to MS DOS Text file
I have an Access Report which I am using to create a text file for upload
into a 3rd party application. When Access exports the text file it is
creating a carriage return (i.e., empty row) in the first row of the created
text file thereby making the file incompatible for upload to the 3rd party.
Is there a setting I need to select to prevent this from happening? Any
suggestion you may have would be appreciated. Thanks in advance for your help!
...Formatting Cells Containing Date Fields That Are Text
Someone here at work imported into Excel a column of text data that
looks like mm/dd/yyyy form but need to be mmddyyyy. I thought I could
simply highlight the columns, click on Format/Cells/Custom and create
mmddyyyy. I do this but the data doesn't change UNTIL I highlight
each cell and press F2 or double-click in each cell or create a
formula using Right, Mid, etc. When I press F2 or double-click, I
notice that an X and a check mark both appear to the right of the Row/
Column box. There's got to be an easier way to do this besides
'onesie-twosie' but we can't figure it...E-mail box sizes. Echange System Manger.
Now and then I need to find out the size of the various e-mail boxes in
Exchange2000. The problem is that the size indicated in the Exchange System
Manager do not reflect the same size when you look into Outlook.
Is the a way to figure out the correct e-mail size?
If not. Is this better in Exchange2003?
Thank you in advance.
I'd consider the Exchange value to be the most important given this is what
will be used for mailbox quotas, etc.
"Dag N" <email@example.com> wrote in message
> Now and then ...Problem sending e-mails with Outlook & SBC Yahoo DSL
I have been unable to fix a problem and am looking for
help. I have Outlook 2000. I also have SBC Yahoo DSL. I
have spent hours on the phone trying to fix this problem,
reloaded my software, etc. I can recieve e-mail from the
SBC Yahoo DSL server with my Outlook, but cannot send e-
mails. The error message I get is 0x800ccc0f. I know this
means the outgoing mail server does not recognize and log
me in, but does anyone know a way to change this? SBC made
sure my settings were correct, but the problem persists.
They claim it is an Outlook problem, but it never happened
with other ISP...Document map 05-12-10
The document map for one of my documents has stopped displaying headings from
the beginning of the document and instead displays headings from a point
within it. The headings that aren't displayed are correctly formatted as
Level 1. And I've entered and exited Outline view, with, unfortunately, no
benefit. What might the solution be please?
Are the headings that are shown the document map in the same style? If so,
try reapplying the style to the headings that are not showing up. If not,
make sure that it is the paragraph outline level that you have set to 1 (& if
it ...I can't receive or send mail
I try loggin into my account, but I get this message.
"The server you are connected to is using a security certificate that could
not be verified. The certificat's CN name does not match the passed value."
How do I fix this?
Please post the names of the incoming (POP3) and outgoing (SMTP)
servers you are using, and their port numbers as shown on the
Advanced tab of the account properties.
Gary VanderMolen, Microsoft MVP (Mail)
"unknown" <firstname.lastname@example.org&g...Open Word Document With Modify Password
Using VBA to open Word documents. I get a prompt if the document requires a
password to modify. I would like to use VBA code to open read only and search
the document without being prompted -- going through hunders of documents and
if certain info is found the file is logged. Current code:
Dim rstDoc As New ADODB.Recordset
Dim objWDApp As New Word.Application
Dim objDoc As Word.Document
rstDoc.Open "FileList", Application.CurrentProject.Connection,
On Error GoTo DocumentErrors
Do While Not rstDoc.EOF
...Pub Mail Merge
Does Publisher 2002 / 2003 version have it's own mail merge program.
I use Pub 97 now and I always have to bring in a pub file into MS Word in order to mail merge.
This means I need two software programs for one operation.
Ron Publisher 2002 and 2003 have the same useless database as Publisher 97
has built in.
Do you mean to say you have never found it in Publisher 97?
Publisher 2003 has significantly improved the ability of the Merge and you
can now merge multiple items and pictures on a page.
...Help! Extract the subject of all mails in outlook to a text file
How can I extract the information, such as subject, sender, time of all
the mails in my Inbox into a text file?
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
Switch to a table view that contains all the fields you need the information
from, select all items, and press CTRL+C to copy. You should be able to
paste the data in columns into a text file. Note that not all available
fields will copy in this manner, but the ones you mentioned should work.
Jocelyn Fior...Public folder for storing e-mail message
Exchange 2003 server, Outlook 2002 client. I want to set up a mail enabled public folder to store all e-mail addressed for customer support group. I also want to be able to forward e-mails from this public folder to an external address automatically. How do I set this up. Any help will be appreciated.
"Dipti" <email@example.com> wrote:
>Exchange 2003 server, Outlook 2002 client. I want to set up a mail enabled public folder to store all e-mail addressed for
> customer support group. I also want to be able to forward e-mails from this public fol...easy way to delete all rows with no text in them?
I just took on a client who sends me a multipage spreadsheet weekly with
movie times for his 10 theatres.
My guess is he just deletes the information from the previous weeks row
and adds a new row. His sheet really only needs about 16 columns and
maybe 20 rows. The sheets he sends have upwards of 1500 rows and
Many of the rows are in between the actual text rows as well.
I convert this to a webpage and post to his site. Problem is the sheets
are so large they take forever to clean up (in GoLive) and much too long
to do by hand.
Is there an easy way to delete all rows with no text in...The spacing between lines of text is not uniform; how can I fix it
Occasionally, lines of text within a paragraph end up unevenly spaced (this
has happened in Word and in Publisher). I've checked to make sure the
defaults were set to even spacing (e.g., 1 space between lines) and they
were. What else can I do to fix this problem? As it stands right now, I
think the document looks somewhat sloppy because within just one paragraph I
think I have 3 differently-sized spaces between lines.
...How can I convert a number to english text in Excel
Is there a way to convert an certain number, to english text in Excel. For
eg. An invoice total of $1000 shoul also appear in words (Dollars One
See the following:
Also check out the following add-in by astien Mensink
Super utility one of the functions converts numbers to text lik...Track source of Netsky in mail?
I have a client that uses Outlook 2000 and 2003 with POP accounts from their
ISP. They have about three users who keep getting Netsky stopped by Symantec
Antivirus Corporate Edition version 8.1 on their desktops. They get at least
a dozen a day on some users.
Is there any way to track down the sending user or computer? I suspect it is
not on their network, but possibly an unprotected home user with their
Thank you for the help!
No, otherwise, this problem would have been nipped in the bud a long time
Milly Staples [MVP - Outlook]
Post all repl...Word document format marks
Operating System: Mac OS X 10.5 (Leopard)
How do I hide format marks in my Word documents. Docs show paragraph marks, tab marks, etc. They do not print when I print the document. One day I was typing and accidentally hit a key or key combo and there they were.
You can simply click on the �-icon in the Standard toolbar (it looks
like an inverted "P"), or, if you prefer using the keyboard, hit Cmd+8.
On 30/03/10 15:52, DrJ117@officeformac.com wrote:
> Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel
> How do I h...opening a word 2003 document with word 2007
I created some documents on Word 2003 and have been unable to open them with
Word 2007. I tried saving them as .docx and .rtf on Word 2003 with no luck.
The posts that I have seen thus far have not helped. Does anyone have any
What happens when you try? Word 2007 should have no difficulty opening Word
2003 documents or RTF documents.
Word 2003 can only save docx format if it has the compatibility pack
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word...E-Mails Bouncing from Server
E-mails that are sent to one of my users bounce intermittently, however,
they bounce with the name of another user, i.e., an e-mail sent to
firstname.lastname@example.org bounces back with a reply, i.e.:
Your message did not reach some or all of the intended recipients.
Subject: Technology Update
Sent: 6/1/2005 3:07 PM
The following recipient(s) could not be reached:
Jane N. Doe on 6/1/2005 3:07 PM
The e-mail account does not exist at the organization this message
was sent to. Check the e-mail address, or contact the recipient directly
to find out the correct address.
<mail.mail.com #5.1...E-mail Delivery Issues to Group within a Group
Here is an example of a prevailing issue we are experiencing. Our Exchange
servers are running Windows 2003, EX2003SP1, and PCs using Office 2003.
We have a distribution group called BPMI_PME_MGRS in our address book in
Outlook. The problem is that this group does not always deliver e-mails to
all the members in the group unless the user sending the email clicks the
pluses (expands the groups) repeatedly so that all names within the
distribution list appear in the email. If they do not click the pluses, the
email is not always received by all the group members and no failure notice
i...Access word document from external app while it is open
I open a text file with ms word 2003 (i.e. a common txt file) and I need to
edited from ms word which is ok, but I need also in parallel access it by an
external application and I cannot (I get a message permission denied). I
imagine that ms word lock the file. So what I can do to override this
setting? in order to edit the file from another application while the file is
opened in word?
There is nothing you can do. Word will lock the file. Word is not a
<>>< ><<> ><<> <>>< &...I can't type in the third column of my landscape document.
I set up a legal-size, landscaped document in 3 columns. I have typed in the
first two, but I can't type anything in the third. It's as if the document
ends. When I look at the page in Print Preview, it looks perfect: the first
two sections are there, but the third one is blank. Messing around with the
margins hasn't helped me.
Have you filled the first two columns? They should automatically spill over
to the third, or you can insert a column break (Ctrl+Shfit+Enter).
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://w...How do I change the words that pop up when curser is over pic?
I am using Publisher and when I am sending the document words are poping up
over different sections and pictures when the curser is over it.
How can I change the hidden words and or remove them?
Thanks for your help
Is the publication a Web page?
Mary Sauer MSFT MVP
"Avi" <Avi@discussions.microsoft.com> wrote in message
>I am using Publisher and when I am sending...sharing an item across pages in word
i have a document in which i have the same table on 5 different places.
so now if i have to update this table then i have to update it on 5 places.
is there any solution so that if i update that table on one page, then all
other tables will also get updated.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> &...Keeping mail on exchange server
I have an email account on an exchange server.
I like being able to manage it via the web so that i can
check my incoming mail, sent messages and also store
attached files for viewing at remote locations.
I also would like to be able to use this account in
Is there a way to use this emal account in outlook and
not have everything downloaded that i want to keep on the
That's the way it works by default. Just make sure that your default
storage location (Tools | E-Mail Accounts | View or Change E-mail Account |
Deliver new mail to...) is set to the Exchange m...I am receiving emails but cannot send using Vista and Windows mail
Account: 'POP.ATT.YAHOO.COM', Server: 'POP.ATT.YAHOO.COM', Protocol: POP3,
Server Response: '-ERR popgate unknown command', Port: 110, Secure(SSL): No,
Server Error: 0x800CCC90, Error Number: 0x800CCC18
Wrong port number and SSL setting. Use the settings specified by your provider:
Also, go to Tools, Accounts, select that mail account, Properties, Servers.
Make sure that "Log on using Secure Password Authentication" is not enabled.
Gary VanderMolen, Microsoft MVP (Mail)