Outlook does not save the e-mail addresses entered
I am using Outlook 2000 SR1. When entering a new contact, it does not save
the e-mail address along with the other information logged in. I have tried
substituting the contact's name with the e-mail address to send e-mail, but I
get an error message that it does not recognize the contact name. How can I
...Auto Filter problem
I am using the auto filter for a particular column to sort out differen
medical programs. When I click the drop down and click a program, i
doesnt show me ALL the lines that say this particular program. Why is
Message posted from http://www.ExcelForum.com
maybe some hidden characters in these lines 8e.g. additional space
"jkb724 >" <<firstname.lastname@example.org> schrieb im
> I am using the auto filter for a particular column to so..."Shrinkage" Problem when saving as PDF
I have a newsletter created in Publisher, which I send to the printer
as a PDF. When I create the PDF, everything on the pages gets
slightly scaled down, creating a larger margin and my nice crisp text
becomes a tad fuzzy.
I'm using Publisher 2007 and have tried
1) Publish as PDF or XPS,
2) Print, and select the printer as Adobe PDF, and
3) Save As *.pdf,
all with the same results.
I have Adobe Acrobat 9 Pro, if it matters.
Can you advise me on settings that I need to adjust when I create the
PDF? Or something else?
When you go to print, select Preferences and set the margins to 0 (z...Docmd.Save
I'm using the following code to save my record before printing it
If Me.Dirty Then Docmd.Save
I'm getting an error saying I have not specified the object
Do I have to specify 'table' and the table name each time I use this
statement, I thought it defaulted to the current object?
"mscertified" <email@example.com> wrote in message
> I'm using the following code to save my record before printing it
> If Me.Dirty Then Docmd.Save
> I'm getting an error saying I have not spec...Auto-Editing
Word 2003 has a very annoying default. It assumes too much! If I reformat a
few words in a document, it changes the entire document to that formatting.
Grr-rrr-r! I have to constantly press undo to get what I want. I know
there's a feature that's causing this annoyance but I can't find it to turn
it off! Can anyone help, please?
Microsoft Word MVP
"Connie Martin" <ConnieMartin@discussions.microsoft.com> wrote in message
news:CD959D82-F81B-4A9D-993E-73...Problem while saving a shared excel'07 document
Hi, in my bussiness, we have a shared excel 2007 document.
This document worked fine with Excel 2003, but now we're migrated to 2007,
we've got all kind of problems..
When I try to save the document, 6 out of 10 times, the saving failed with
an error that Excel could not track changes. You should close the document
and try it again, but then you loose all you're changes. You can also turn
'Share Workbook' off, and on again, then you can save the file, but all the
changes other people have made are gone...
I can't find any solution, so maybe there's...Outlook 2000 will not save password
I have exhausted all my abilities to get outlook 2000 to
save passwords. Operating system is xp.
I have checked and verified settings
I have tried the repair feature
I have uninstalled and reinstalled
I have made sure the Security Accounts Manager is running
I have tried following the instructions from microsoft
knowledge based article 235861 which involves the
None of these have worked. My associate also uses
outlook 2000 and windows xp with no password problems.
My settings are identical.
Any other suggestions are greatly appreciated!!
I have a spreadsheet that utilize the stock quote add-in from MSN. On a daily basis I refresh the add-in functions for the Highs, Lows, Last, Volume, etc. On occasion the spreadsheet reverts to manual caculation settings, and I have to press the F9 even after I updated the quotes. I've always preferred the any spreadsheets I open, blank or otherwise, the automatic setting selected for calculations. I consider this an annoyance. Has anyone experienced this glitch? Is there a fix for it?
Excel takes the calculation mode from the first workbook that opens in a
Sub...Saving or Exporting Outlook Express Sent Items
How can Sent Items in Outlook Express be saved to a
location or file that they could be retrieved when virus
or hard disk problems make access impossible? Are they
stored somewhere in Windows Explorer that is accessible?
If so, where? Can they be copied to a word document
other than by highlighting text in each message? Any
explanation would be appreciated since Help or menus
don't help with this problem. I can back up My Docs and
other files to an external drive, but don't know how to
do this with important email messages I need to save and
protect against disk or compu...Settings.settings file with settings for multiple regions
I thought of using Settings.settings feature that is new to .NET for
storing connection strings info for TEST, INT and PROD regions.
Currently we prefix the appSettings keys with TEST, INT and PROD in
web.config (or app.config). For instance in my web.config I have
<add key="TEST.Connection" value = "......" />
<add key="INT.Connection" value = "......" />
<add key="PROD.Connection" value = "......" />
When we deploy application to each region we ...How can I save Excel file to A CD
I need to save An excel file to A CD, so I can view and work with it on A
I am useing office 2003
"Juleslib" <Juleslib@discussions.microsoft.com> wrote in message
>I need to save An excel file to A CD, so I can view and work with it on A
> I am useing office 2003
Save it to your HDD and then use your burning software to put it onto a CD.
However, a CD is 700 MB - that's an absolutely ENORMOUS file. You'd be
better off with either a USB memory stick, or emailing it...
You need...How do I save a picture from word into my pictures?
I have recently installed Office 2007. I am unable to copy and paste a
picture from word 2003 onto publisher 2007. So I tried to save the picture
into my pics and then insert but I can't do that either. Please help.
> I have recently installed Office 2007. I am unable to copy and paste
> a picture from word 2003 onto publisher 2007. So I tried to save the
> picture into my pics and then insert but I can't do that either.
> Please help.
Maybe the following links will help:
(555171) WD: How To Extract Embedded
Im...auto copy self
How do I arrange for Outlook to automatically copy myself
on every new, reply or forward email?
If you mean keep a copy of all sent, see settings under Tools/Options/Email
Options and Advanced Options
"rich" <firstname.lastname@example.org> wrote in message
> How do I arrange for Outlook to automatically copy myself
> on every new, reply or forward email?
...Set minimum values for equation results
I've been searching the queries here and can't find an
answer to what I'm hoping is a simple query . . . I want
my equation to ensure that any minus values are returned
as 0 but positive values should remain true. THis needs
to be within the original equation as opposed to a
separate equation doing a find and replace. Appreciate
any answers (preferably by e-mail!).
Try using IF(), for example:
Put in C1: =IF((A1-B1)<0,0,A1-B1)
which will return 0 if (A1-B1) results in a minus value
with zero & positive values remaining true
Hope the above helps.
M...can not save altered files over network
I raised this subject previously and got helpful advice. However, a separate
problem arose - bit of history below:
I uninstalled the Windows XP update KB885250 and that removed the problem.
However, my PC immediately informed me the Windows XP update KB885250 was
available and when I let it reinstall, the problem returned.
Do you think I should just avoid installing this update (though I think my
pc will be interupting me all day to tell me about it) or is there something
else I should try?
> > "garfield-n-odie" wrote:
> >>If you ...Auto correct or Auto complete
We are all familiar witht he auto correct or auto complete functions found in
MS applications. Of course that means it is available in Access also. My
question is this ... can this function be replicated within the DB, so that
the set of auto correct items are part of the package rather than something
that would have to be set up on each individual desktop system?
It's use, for me, would primarily be within a memo field where medical
abreviations, used as a shortcut, would convert to the true meaning as the
user types them in. Ex: "prn" without quotes would change to. &qu...Auto Scale Chart Macro -- Any improvements please?
This is the best way I've found to correctly scale a chart -- the only way I
found to exclude a chart interpolating with #NA cells was to delete those
cells containing #NA, and run the chart. This takes a long time on my
computer. Wondering if there is a better way. This macro is directly taken
from 2 excel mvps and modified; i believe a mehta and ron bovarty, but could
be wrong. Thanks for taking a look.
Dim ValuesArray(), SeriesValues As Variant
Dim Ctr As Integer, TotCtr As Integer
Applic...How to set macro to run every 15 minutes?
Does anyone have any suggestions on how to set macro to run every 15 minutes?
Thanks in advance for any suggestions
"Eric" <Eric@discussions.microsoft.com> wrote in message
> Does anyone have any suggestions on how to set macro to run every 15
> Thanks in advance for any suggestions
Stolen from a very nearby universe, er, answer to a question, and modified to
Can you put a date on the sheet and only have it change automatically if the
file is saved? if so please indicate exactly how.
use the following UDF (only on workbook level):
Function DocProps(prop As String)
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties _
DocProps = CVErr(xlErrValue)
and enter in a cell
=DOCPROPS("last save time")
(format cell as date)
for more about UDFs see:
Frank Kab...OWA auto login
I am trying to use the credentials from the forms authentication login to
automaticaly log in to Outlook Web. I redirect to a URL with this format:
I have seen this example in other posts but this does not work for me. I
still get the Outlook Windows Login prompt.
Perecli Manole wrote:
> I am trying to use the credentials from the forms authentication
> login to automaticaly log in to Outlook Web. I redirect to a URL with
> this format: http://UserName:Password@mailserver/exchange
> I have seen this example in other posts but t...Auto look through subfolders
I can write a macro that will extract data from all excel files in a
What I need to be able to do is write a macro that will automatically
extract data from excel files within folders and sub folders and sub
sub folders etc
For example the data is all held on the following directory:
H:\development forms\2006 cost sheets\
And within that directory by customer - for example Tesco, Boots, Asda
etc. These customers are then subdivided into product ranges - eg
1,2,3,4 etc and some futher subdivided by national or exclusive. All
the excel files are in exactly th...How to save contents of cell range in an array?
In a VBA subroutine, how can one, for example, save the contents
(numbers) of the range A1:L12 in the array x(12,12)?
And how does one declare x()?
Thanks in advance.
dim x as variant
x = Activesheet.Range("A1:L12").value
"John Uebersax" <email@example.com> wrote in message
> In a VBA subroutine, how can one, for example, save the contents
> (numbers) of the range A1:L12 in the array x(12,12)?
> And how does one declare x()?
> ...SAVE FILE
I have developed a file with a macro which is protected by a password. A
"Save" button with the assigned macro calls the procedure in the macro and
when I am trying to save a file the following message appears
"You cannot save this file format when the VBA Project is protected
You may unprotect the VBA Project by......"
What do you suggest I do to save a file with a protected macro? The macro
must be protected, it is very important for me not to allow access to the
macro in totallity.
I am using certain cells' information to name the file
My code lo...Any way to get rid of an auto-suggestion in the login dialog box, for Exchange/OL using RPC over HTTP?
A client was using RPC over HTTP to two different Exchange servers (OL
prompting for profile on startup). Both profiles were set up to prompt for
credentials upon connection to Exchange.
There's now only one Outlook profile needed; the other is gone and OL isn't
prompting for the profile selection any longer, which is fine.
However, Outlook is remembering domain1\user and domain2\user in the login
dialog box, and I'd love to be able to get rid of the no-longer-valid
credential dropdown suggestion.
(The computer is not a member of a domain and hence always needs to be
prom...server setting don't activate
I was using outlook 2003 and I didn’t find any problem to activate my account,
But when I upgrade to the version 2007 wish is already activated , when I
tried to set my same email account it don’t work
Thanks a lot
> I was using outlook 2003 and I didn�t find any problem to activate my
> account, But when I upgrade to the version 2007 wish is already activated
> , when I tried to set my same email account it don�t work Thanks a lot
You cannot activate e-mail *accounts* at the mail server using Outlook. You
have to do that with whatever means the e-mai...