Password Protect Two Sub-contact Lists
I have a regular contact list, and within this list I have two
subcontact lists. One is personal, and the other is personal business.
How can I password protect the personal and personal business lists?
Thanks for any help!
Sorry, I just realized that there's a newsgroup dedicated to contacts.
I'll post this there.
> Hi everyone!
> I have a regular contact list, and within this list I have two
> subcontact lists. One is personal, and the other is personal business.
> How can I password protect the personal and...File opens when Excel opens
I used an excel file to import contacts into outlook.
Now everytime I open Excel, Excel opens to a file called
contacts, which is the file I used to import into
Outlook. The data is all garbled. What I want to do is
to eliminate this file from being opened and have Excel
open to a clean workbook called Book1.
Can anyone help?
The only way that could happen is for contacts be in the
xl start folder. remove it form the start folder.
where is that? varies but..
try exploring around the above path. got to be there
somewh...Importing Contacts from Excel
I have a list of email addresses in excel in a column headed Email, I have
made that into a named list.
When I import these into MS Outlook, they come across, but the display as:
has the email address in brackets
Then when I try and create a new msg from one of these addresses I get the
error msg. You must first enter a valid email address for outlook to send
your email. If I remove the brackets from the display as part the email
What do I have to import these emails from Excel??
Try creating a few new con...Send email from Excel
In Excel when I use File-Send To-Mail Recipient (as attachment) my Outlook
signature does not get inserted into the email. Why?
Maybe you should post that question in an Outlook NGs instead?
For everyone's benefit keep the discussion in the newsgroup.
"mikemo" <email@example.com> wrote in message
> In Excel when I use File-Send To-Mail Recipient (as attachment) my Outlook
> signature does not get inserted into the email. Why?
Does that mean you don't have an answer?
I would like to password protect a workbook so that when
the workbook is selected to open a dialog box pops up
asking for the password and after the password is entered
correctly the workbook will then open. Thanks for the the
Todd, do a save as and look under options, depending on what version you are
using and set a password to open
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address t...Outlook opening Word
A computer club member reported the inability to reply, reply to all, or
forward e-mail messages.
As a volunteer, I went to their home last evening and this is what I found,
Win XP Pro SP2 plus all updates applied. Office 2003 Small Business Edition.
When Outlook 2003 is opened, it takes forever (50 seconds). E-mail messages
are received. When attempting to send any message, whether reply, reply to
all or forward, a window opens that says something like "Opening Word as
your E-mail editor. Nothing happens. 5 - 10 minutes. Outlook is
unresponsive, and I used Task Manager ...Excel DDE with images
I am trying to link from Excel to a software I developed by way of DDE
Currently, we can retrieve values from the software by placing th
following formula in an Excel cell:
where Topic may be, for example Statistics, and Item may be a specifi
data item in Statistics, such as Mean.
This all work fine and well, but I would like to do that same with a
image - namely, via DDE place the current image in my software in
cell fo Excel with a similar formula.
Is this possible? Can anyone point me in the write direction as to ho
to do this
-----...how to stop excel from auto formatting whole number to decimal %
how do i stop excel from auto formatting whole numbers into decimals?
input 3 --> excel would show 0.03
From the Excel main menu:
UNcheck: Fixed decimal places
Does that help?
> how do i stop excel from auto formatting whole numbers into decimals?
> input 3 --> excel would show 0.03
ron, you are amazing!
thank you soooooo much.
"Ron Coderre" wrote:
> Try this:
> From the Excel main menu:
> <...opportunity estimated close date alert
is it possible to have an alert sent out to someone when an opportunity
reaches the estimated close date?
In a word - no.
More accurately CRM can not do this but it can be made to look as though
it does it. We have a similar requirement in that we want events
scheduled with respect to a future date in a record and not with respect
to the record creation date.
The method we have used is to create a 'lead time' field in the database
and then create a service which once a day updates all those lead times
for open opportunities to be the time until the estimated ...Passwords
Hi, I have a password field in a database. How do I set it so that a
user can only type in 7 characters for a password. and if they type
more an error message will appear?
> Hi, I have a password field in a database. How do I set it so that a
> user can only type in 7 characters for a password. and if they type
> more an error message will appear?
You may use the ValidationRule and ValidationText of the field in the
table design view. Setting ValidationRule to Len([YourField])>7) will
raise an error in your case.
--> stefan <--
...Error Printing Excel Attachment
I'm running the following code to print Excel attachments in emails. 2
things are happening. I either get the "File in Use PERSONAL.XLS is locked
for editing" or when I run this on another computer the code completes but
nothing prints. I have the same code printing .tiff attachments ( changed
the Shell program)
Any help would be greatly appreciated!
Public Sub PrintExcelAttachments()
Dim Inbox As MAPIFolder
Dim Item As MailItem
Dim Atmt As Attachment
Dim FileName As String
Dim i As Integer
Set Inbox =
GetNamespace(&q...Can i create my own fomrula made up from several excel ones?
I am using the nested functions below
"=if(vlookup(1, GRID, 3,false) = 0, (1, GRID, 4, false), (1, GRID, 3,
i.e for the row with the digit one in its first column return the value in
the third column else if empty return the value in the fourth column.
my problem is i am repeatedly using the line above exactly only changing the
value i am searching for (1 in this case ))
so ideally i'd like to do something like
define myformula(X) = if(vlookup(X, GRID, 3,false) = 0, (X, GRID, 4, false),
(X, GRID, 3, false))
is this possible?????????
I don't know if thi...Keep user passwords
We've just finished installing a new Exchange server and connecting it to a
separate DC. We used to have everything on the same server but we'd like to
be able to scale our solution better in the future - therefore the new
setup. Users are primarily connecting to Exchange by means of RPC over HTTP
from clients that are not part of our AD.
The old setup allowed users to save passwords if they configured their
clients to use NTLM authentication and followed the directions in this
This worked both for RPC...how do I import a Quottro Pro 10 notebook file (.qpw) into Excel
I would like to import my worksheets and notebooks (.qpw) that I developed in
Corel Quottro Pro 10 into excel 2003.
Thank you in advance for your help and information.
...How to retrive password protected worksheet but forgot password?
I password protected an Excel spreadsheet and now can't remember the
password. Is there any way that I can gain access to my worksheet?
There are tons of FREE good Excel password 'cracking' tools. Your favorite
search engine should get about a gazillion hits on a phrase like "crack excel
password" or "excel password cracker".
A good one that many report great success with can be found at:
> I password protected an Excel spreadsheet and now can't remember the
> p...Excel Template
We use an Excel worksheet for each day in which we fill in details of what
contractors are assigned to what jobs. The trouble is that each time a job
is changed, we have to open more than one worksheet to check/change the
details (ie, each worksheet for each day is a separate Excel spreadsheet.
I'm trying to put the worksheets together based on months rather than days
ie a worksheet for each work day, in one file instead of lots. At the
moment, I've just lumped each day's worksheet into one spreadsheet for each
month, which is an improvement. Is it possible to have a macro or s...exporting excel charts as eps files
I am wanting to know whether it is possible to export (or
save) a microsoft excel chart or graph as a vector file
(e.g. eps or emf file).
Basically i am wanting to export an excel chart or graph
as a vector-based file so that i can input it into a
desktop publishing programme like Adobe Indesign. Simply
doing a copy and paste from excel to InDesign only copies
a screen-resolution image, which is, of course, useless.
Most other graphing programmes have the option of
exporting graphs as vector files, so i am hoping that
excel is the same.
Any help would be greatly appreciated.
Cheer...I get an error message everytime I save & publisher closes
I am trying to create a web site using Publisher 2002. Everytime I try to
save, I receive the dialodue box stating:
Microsoft Publisher has encountered a problem and needs to close. We are
sorry for the inconvenience.......
The error report is:
AppName: mspub.exe AppVer: 10.0.6308.0 ModName: mspub.exe
ModVer: 10.0.6308.0 Offset: 00013012
Can anyone help?
I have just updated Publisher which has cured most of the problem. However, I
still get the same message when I try to change a picture on my navigation
bar and then it is only on page 2. It will not even let me delete the page
and ...Spreadsheet password protection
How do you password protect a spreadsheet. I can't find anything in the help
You can prevent un authorised access by giving a password to open the
workbook itself, so that no one else can open it (Go to Tools, Options and
then Security Tab). You can do it there if you have already saved the file,
or you can go to "save as" then "Tools" and "General Options" where you can
On the other hand you can protect work sheets and ranges for different
people by using "Tools" and then "Protection" Tab
M Imran Buha...Password
I am working with publisher 2007. I finished my site last Dec. and went to
It is not letting me make changes because it does not like my password. I
can not figure out how to go in a reset everything from my provider.
I was also trying to see if I could find web publishing wizard, which
doesn't seem to exsist with 2007.
If you are saying you forgot your password then contact the ISP Tech Support
and they will reset the password to something like 1 2 3 4 or something
other that is very simple. They will also instruct you to change it to
somethin...Import from Excel to Windows live outlook
How to import contacts from an Excel Spreadsheet to Windows live Outlook
No such animal as "Windows live Outlook". There is Microsoft Outlook,
and you will find the option under File, Import and Export. And there is
Windows Live Mail, and there you could probably look in Help or post
your question to the Live Mail group. Either way, "Excel" isn't actually
involved and isn't needed.
Import from Excel wrote:
> How to import contacts from an Excel Spreadsheet to Windows live Outlook
If you mean Office Outlook...............
See Ron's site ...Change Password Next Login, Enforce Password Policy and Expiration
I'm curious why are the Change Password Next Login, Enforce Password Policy
and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a
user. my client want to know how to enable it. hope for your prompt action.
Only works for SQL 2005. If you client wants to use a beta database server...
> I'm curious why are the Change Password Next Login, Enforce Password Policy
> and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a
> user. my client want to know how to enab...Outlook 2002 Error msg. after closing program
After I close Outlook 2002 I get the following error
Any ideas on how to fix this problem would be much
Based on my experience, the issue may occur in several situations and we
to completely remove Office program to check the problem. Your patience and
cooperation are appreciated.
To narrow it down, let us try the following troubleshooting steps:
1) Close Outlook, click start menu | control panel
2) Click "add/remove program".
3) Click "change or remove programs...Passwords #3
For some reason, it will not store the password. I have
checked the box that says "remember password", but, each
time I try to log in. It will ask me for it. Any ideas.
I am thinking about recreating the profile for thismailbox.
I am a consultant, and my customer doesn't know how (or
won't write down what I tell them) to do this.
...Interactive Web database with query capabilty
I see lots of questions about using Access as an interactive web database but
many of the answers seem to dance all around the question. Let me be as
precise with the question as possbile...
Here is a online database that is exactly like what I want to do with Access
This interface was created with something called Ruby on Rails.
(1) Can this same thing be done with Access and asp?
(2) Can you provide an example of an access database that offers the same
query capability and submission capability?
I have done a si...