Deleting "mail to:" email address links
I have a relativly straight forward spreadsheet where I
am maintaining a large address list. It contains a
homeowner's lot number, name, address, telephone #, and e-
mail address. When attempting to select random cells for
data entry/modification, I receive and automated
message " mailto: (a random e-mail address) - click once
to follow. Click and hold to select this cell."
I have no idea where/how this message/feature/function is
being attached to these cells but would like to eliminate
it. Since seeing these messages, the size of the
worksheet has been increasing in ...Remote users cannot send e-mail through Outlook
I have a few users who do not work in our office. They
have Outlook installed on their home computers and then
dial up to the internet and do a send/receive.
I have Exchange 2k3 on a Windows 2k server and the users
are configured to allow for SMTP/POP3. All was working
fine until earlier this week when they informed me that
they could no longer "send" mail. They get the
message "The TCP/IP connection was unexpectedly terminated
by your mail server. If this problem persists, contact
your LAN Administrator or Internet Provider".
The users can still receive mail ...Email accounts are not created for new user
I had a severe system crash several days ago because of bad memory in my
domain controller (Server 2003 R2)/Exchange server 2003 (small site - no
extra systems). I had to reinstall Exchange 2003 and reload the exchange
store from backup. For existing users everything works great. Everybody can
send and receive email, the calender works correctly, etc. OWA works.
However, when I create a new user account in Active Directory Computers and
Users, the account is created and the new user can log onto a system.
However, Outlook 2003 cannot be configured to use the exchange server. In
t...Cannot delete report
I have install the report manager sometime ago, it is working fine.
Until recently we found that when i click the action menu, nothing is come
out. I can't delete or rename the report. But I can add new report.
Do anyone encouter this before?
...Categories deleted converting from Quicken
I just converted from Q2003 Premier to the Money 2005 Trial 2 days ago.
I noticed today that a number of categories have been removed from the
transactions in my checking account and credit card accounts. What I've
noticed so far:
1. All sub-accounts for Utilities were gone. This wasn't too bad
because I could use find replace since the payee name has been the same
on these for all years I have in Quicken/Money.
2. All sub-accounts under Insurance were gone.
3. The category Groceries came over, but there were no transactions in
it. Quicken had several hundred...Retrieving Current User Information from JScript (OnChange)
I am adding functionality to one of my client's OnChange scripts to append
the Current User Name into a memo field with date and action information. I
scoured the web but can not find a way to properly retrieve the Current User
information. Any information would be incredibly appreciated.
...Help with Synchronizing a user folder with a Public Folder
Hoping that someone can offer a suggestion on this one.
I'd like to be able to synchronize an email folder in a particular users'
Outlook account with a public folder. The idea is to have email
conversation threads in a particular folder (just one folder) visible to
others in the group via the public folders. Ideally, it would be great if
changes to the public folder are instantly mirrored in the users folder -
but that requirement is not critical, the core requirement is to have the
public folder mirror the user's folder (in real time).
I know that I could accomplis...Prevent users from saving music and pictures to their hard drives without folder redirection?
Hi there. I'm wondering if there is a way via GPO or anything else to
prevent users from saving music and pictures to their local hard
drives without using any type of profile or folder redirection.
...Cannot create mailbox for new user accounts
I am running Exchange 2003 on Server 2003. I was able to move all existing
mailboxes from my old Exchange 2000 server to my new 2003 server. Whenever I
try to create a new user it creates the user normally and asks if I want to
create a mailbox for the user. I check yes, and it says account created
successfully. However, the mailbox never appears in Exchange, no email
address is assigned to the new user, and I cannot send mail to the user
account either. If I try to access any Exchange properties from ADUC it
shows everyhting as if a mailbox exists, but there is no mailbox. I am
...Delete contents deletes all data and formulas
When I hit delete contents all data and formulas are deleted. How can I
delete data without deleting formulas?
You could try this
tap F5 - Special - Constants - OK
and if that selects the data you want to delete then tap the delete key
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
> When I hit delete contents all data and formulas are deleted. How can I
> delete data without deleting formulas?
First use Find...Need to retrieve a deleted Excel File
On Saturday I hide an excel sheet and then protected the
workbook. When I got into work today to open the file it
was non-existent. What do I have to do to retrieve the
file? Does it make a difference if the file extension
ended with .csv?
Thanks in advance!
Search in Windows to make sure it's still on your compute
go to the folder the file is in and look to make sure it's still ther
If you didn't do this, you might need to to text, which includes *.cs
Excel is not set to open this type of file by defaul
Did you (try to) open the file with Excel.
If so : did ...Securities with closed positions are being deleted
I am using Money 2006 Deluxe--having upgraded from the 2003 Money Business
It appears that my closed security positions are being deleted automatically
60 days after selling the last shares. Price history for these securities is
I believe that in Money 2003 (Business) that I used a setting that is
causing this (the results, however, were not my intent). Money 2006 does not
appear to have such a setting.
How can I stop this from happening now for securities that I will be selling?
How can I recover the "lost data"
How can I force Money 2006 to pic...Users cannot login to OWA after Exchange 2K3 was moved into different OU
I created a new OU named member servers, and moved the
exchange 2k3 server into it. After I moved it, only the
administrator was able to login to OWA successfully. No
users could login to OWA. I created a test account with a
mailbox, and was able to login to OWA with the newly
created test account. I then moved the exchange 2k3
server from the member servers OU into the computers OU,
and the newly created account was unable to login to OWA.
Any help with this would be appreciated.
...Backup a users mailbox in Exchange 2003
We have recently terminated a couple employees, and I would like to make a
copy of their mailboxes. How do I go about doing this?
On Mon, 30 Oct 2006 06:36:02 -0800, chb12
>We have recently terminated a couple employees, and I would like to make a
>copy of their mailboxes. How do I go about doing this?
Exmerge is always a good option.
What I normally do is open their mailbox on my outlook, then create a
PST (name it the users name). Once the PST is created I copy the
contents of their mailbox into the PST. From there you ...Deleted calendar from Public Folders
Accidentally I deleted Calendar in Public Folders on the Exchange 2000. Is
there a way to bring it back?
I tried to locate an article in Knowlege Base searching with "Recovering
deleted items from a public folder", but the article is gone.
On Mon, 3 Apr 2006 21:28:01 -0700, Daniel
>Accidentally I deleted Calendar in Public Folders on the Exchange 2000. Is
>there a way to bring it back?
>I tried to locate an article in Knowlege Base searching with "Recovering
>deleted items from a public folder", but the a...deleted items #7
Does anyone know what and how I can view and/or delete the 1129 items my
Outlook says I have in my deleted items folder. 1 says unread.
If can see the Deleted Items folder in the folder list, right-clicking on it reveals "Empty Deleted Items folder"
If you can't see the folder list, it's under the 'Go' menu in Outlook 2003, and under the 'View' menu in earlier versions
You can also empty the Deleted Items folder automatically every time you close Outlook.
Tools menu > Options > 'Other' tab. Choose the 'Empty the Deleted Items f...user forms #5
I have created a user form (click on New Employee). How do I get the
information entered in to this form to appear in the correct columns in
the Payroll data sheet? And how do I get the combo boxes to display the
drop down information from the sheet called input.
Runner77's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30388
View this thread: http://www.excelforum.com/showthread.php?threadid=500502
...Calendaring agent failed in message delete notification
We have a user who previously synchronised his calendar with a psion and has
many messages that had reminders on that he now can't delete using Outlook
(gets error) but he keeps on being reminded that they are late.
The psion has been thrown away so how can I delete these messages?
Assuming we back up his calendar can we reinitialise it? Would a mailbox
Event Type: Error
Event Source: EXCDO
Event Category: General
Event ID: 8200
Calendaring agent failed in message delete notification with err...Make sales target (quota) invisible for other users
I am setting up a MS CRM system for a pilot which focus primarily on our
I have given each user who's a salesperson given a quota in the CRM system.
These numbers are confidential and so not everybody may be given the
possibility to view this data.
But when I checked with another role, I could see the quota of erverybody
who's got quota assigned.
Is there a possibility to make these quota's only visible to the persons I
want (for example the director can see the quota's of everybody, the
salespersons can only see the quota for themselves and the rest o...User list
I'm wondering how to check the users on Exchange Server 2003, I tried it on
E2k3 by [PS] W:\>Get-Mailbox -server Exchange2k3, and I got nothing in the
list, but when I tried to remove Exchange Server 2003, I got an error,
The component "Microsoft Exchange Messaging and Collaboration Services"
cannot be assigned the action "Remove" because: - One or more users
currently use a mailbox store on this server. These users must be moved to a
mailbox store on a different server or be mail disabled before uninstalling
Any idea? Thanks.
I followed the instruc...Adding GAL users into a custom form
I have created a custom form, and am required to add a series of approvers.
What I am trying to achieve is:
* Add users from my GAL into a text field, so that when the form is sent,
they do not get initially CC'ed the form.
Is this achievable, and if so, how do I do it (if you could help by
including any appropriate code, that would be great).
...Non AD emails going to 1 user
I have an Exchange 2003 server running on SBS 2003 the issues is one user is
getting all the emails sent to him that look like they are coming from his
domain. For example his email is email@example.com but in his inbox he is
getting XYZ@mydomain.com but XYZ is not in the AD or has a email box set up
on this server. Why is getting this non AD email and how can I stop it.
Thanks in advance
Are you sure it's not a SPAM where the spammer may have simply put in
firstname.lastname@example.org and BCC it to all possible conceivable names
"LaOVis" <LaOVis@discuss...one company doesn't show $ amounts in payables for one user
I have a user who has access to multiple companies. The access for all
companies is the same. In one company when she goes to
Inquiry>purchasing>trx by vendor, the display shows $0 for all transactions.
Other companies, she sees the correct $ amount. There are no modified
windows and again her security is the same for all companies. Can anyone
tell me why this is happening?
I am having this exact problem and would appreciate a fix. I have to change
users to have the payables inquiry amounts show. I only have this problem
in one company and I am the only user in our of..."Enabel / Disable macros" message box appears no matter which .xls file the user opens....
"Enabel / Disable macros" message box appears no matter which .xls
file I open... I can't find any hidden/empty code in the xls files...
Has someone got any experience with this?
Nils Egil Lie
Stolt Offshore AS
you also have to remove the (empty) modules in the VBA editor. Also
check that there're no statements left in the worksheet modules and in
the workbook module
Nils Egil Lie wrote:
> "Enabel / Disable macros" message box appears no matter which .xls
> file I open... I can't find any hidden/emp...Deletion settings in Mailbox Store Properties
Our company would like to enforce a policy to permanently delete items
30 days or older from each mailboxes Deleted items folder.
The mailboxes all reside on the Exchange 2003 server.
Under Mailbox Store Properties, Deletion settings, the Keep deleted items
for (days) is set to 30, yet the items are not being deleted.
My thoughts are that it is because we do not have the Mailbox Manager
Is that correct?
I am a little hesitant to run it because I am worried about what else it
I only see one recipient policy and that is for email addresses.