deleting info within a cell
I would like to delete ' and an s in a set of numbers within a cell how do
you efficently do this through out a data set. (example 344'6s = 3446 in
Find ' and replace with blank, then again with the s
> I would like to delete ' and an s in a set of numbers within a cell how do
> you efficently do this through out a data set. (example 344'6s = 3446 in
> cell only)
do you always have ' and s in your data if yes highlight the data, press
find what enter ', then in replace with don't enter...Forcing a view on a public calendar
A query for you. We have set up a calendar in "Public Folders", and
want to set the default view for this particular calendar to five
minute interval. Is there any way of setting this as a default either
at the server end (Exchange 2003), or rolling out a default setting to
all clients (mostly Outlook 2003)?
"Thomas Rushton" <ThomasRushton@gmail.com> wrote in message
> Good morning.
> A query for you. We have set up a calendar in &qu...How do you recover a parameter?
I would like to execute an excel file, for example, with a file name
And afterwards, in that file, I would like to recover the name zz.txt.
Could you please help me?
I'm not sure what you mean by "execute" the Excel file, or "recover the name." It sounds as
though you want to make a txt file from the xls file. If so, you'll need to open it in
Excel, then do File - Save As, with the file type set to txt.
&...outlook xp recovered data - from CD
I just received a CD with all of my recovered outlook xp
data from a failed hard drive: how do I move/copy/transfer
the recovered Calendar, address book and contacts,
personal folders, and emails from the data recovery CD to
my existing Outlook folders? Where does that data reside
on my new hard drive (windows xp pro oper system)? Would
very much appreciate any help. Thanks.
"kevinh" <firstname.lastname@example.org> wrote in message
> I just received a CD with all of my recovered outlook xp
> data from a failed hard drive: ho...Re: Public Folders permissions problem
ooops ... we're on Exchange 2003.
"JJ Runnion" <jjrNOSPAM@sinte.edu> wrote in message news:...
> somehow we've gotten "locked out" of permissions on the calendars and
> other folders in our Public Folders.
> When I right-click on the calendar in Exchange Manager Admin
> Group\Folders\Public Folders, a username/password box pops up and won't
> take any of the admin username/passwords (domain admin, enterprise admin,
> etc.). I get "the operation failed. ID no:80007005 Exchange system
> M...Sent messages are not going to the SENT ITEMS folder
When I send messages in Outlook 2000, sent messages are
not going into the Sent Items folder.
I've got the check box set at Tools, Options, E-Mail
Options, Save Copies of Sent Messages in Sent Items
It seems it was working, but not for the past three days.
Any ideas? I'm using Windows XP Home, Office 2000.
...Cannot delete Sent Items #2
I can't delete some of the older files from my Sent Items folder. Basically
everything dated 12/7/2004 and earlier will not delete. I get an error
message that says "The messaging interface has returned an unknown error.
If the problem persists, restart Outlook."
I've restarted and still get the same error. I even restarted the computer
Anybody got any ideas?
Are you able to right-click on an individual email and delete it?
Have you tried opening Outlook in safe mode and then deleting the sent items:
http://www.howto-outlook.com/Howt...Recover live calendars?
Someone was helping me cleanup an old laptop and they deleted important
calendars from my WLM. I have months worth of appointments and need some
Thanks (I hope)
Did you sign in to Live services in WLM? It will not say Sign in below the
Close X if you are signed in. calendar.live.com will have the calendars
that will sync back to WLM the next time you connect with WLM.
MS MVP- Windows Live Mail
"nimbus" <email@example.com> wrote in message
> Someone was helping ...Outlook client displaying different folders than web client
CRM 3.0 Outlook client security issue:
We limited security for several users to only see certain folders. This
works fine on the web client but in their Outlook client they see all the
folders. We have done everything we can think of to fix this including a
fresh install of the CRM Outlook client on a new machine and still have same
issue. Has anyone seen this before or have any ideas?
...HELP!!! Deleting all transactions
I get an error when I try to "delete all transactions" from the
"Store" then "Database" menu. the error says "Could not truncate table
"VitalAuthorization" becase table does not exist in database."
If it's RMS, the table name is VisaNetAuthorizaion, not VitalAuthorization.
<firstname.lastname@example.org> wrote in message
>I get an error when I try to "delete all transactions" from the
> "Store" then "Database" menu. the error says "Could ...Can't delete file in Outlook express outbox
I have a large email file in my outbox that won't send and I can'
PhoenixVPC's Profile: http://www.msusenet.com/member.php?userid=468
View this thread: http://www.msusenet.com/t-187101402
PhoenixVPC, you wrote on Fri, 26 Aug 2005 13:46:14 -0500:
> I have a large email file in my outbox that won't send and I can't
> delete it.
Close Outlook Express and search for the file "Outbox.dbx" on your
system. Delete it an restart OE.
-...selectively download folders from isp
I am having trouble with Outlook. I have a yahoo account and I have mulitple
folders on that account. I was wondering if there was a way to only download
what is in my yahoo inbox and not in my yahoo bulk folder.
I you take a look at your preferences in yahoo mail - http://mail.yahoo.com
you have the option to send bulk mail to your pop3 client. As easy as that.
"MOOSE" <MOOSE@discussions.microsoft.com> wrote in message
>I am having trouble with Outlook. I have a yahoo account and I hav...Display folder description information in a balloon or similar pop
Hi, I'm trying to find a way to quickly display the information typed in the
Description section of the folder properties in Outlook 2007.
I have several folders, sometimes up to 100, which contains documents to
approve for various chage requests. I enter the most up to date info in the
description field on the properties section of each folder - however, to view
this I have to right click on each folder and select properties to view the
I wondered if there was some way I could hover my mouse over the folder and
have the text display in a balloon or pop up (similar ...Hiding Dbase 111 Records Marked for Deletion
I will be linking several Dbase 111 Tables into a MS Access 2003 Table.
Can records that are marked for deletion be hidden?
I would add a field for Archive - Yes/No. Bring the data in separately and
those marked as 'Delete' set the Archive to Yes.
In your queries use criteria on the Archive field.
Build a little, test a little.
> I will be linking several Dbase 111 Tables into a MS Access 2003 Table.
> Can records that are marked for deletion be hidden?
...Deleting a transaction in Admin
Can someone tell me how to delete a transaction in the admin. Here's the
story, employee helped a customer with a return and ended up oweing the
customer money. Our policy is to give the return on a gift card. the
employee forgot to add a gift card item and just swiped the card on the
tender screen. Since that didn't work she just gave the customer cash back.
Now my x report says that we accepted funds for on a gift card and my cash is
short that amount. I would like to just delete the whole transaction and
redo as if I was giving the customer cash back so all my numbers a...Outlook Rules doesn't allow deletion.
Outlook Rule that I ask to permanently delete a message before I even view it
says I don't have appropriate permissions to perform the task. I am the only
user and am listed as administrator. I'm sure you've seen this before and I
think I had it corrected .... once .... before I had to do a full factory
recovery in past months. Would you be kind if you know the answer and direct
me? Thanks a gazillion! XP Outlook 2003 on Toshiba Laptop using Student and
Teacher Edition. Thanks, jack
Jack da Shack
I want to quickly delete unwanted rows from a file. I can use a custom
filter to "hide" the unwanted rows, but I'd like to delete those rows.
Instead of hiding the unwanted rows, filter to show ONLY those rows. Then
select and delete the visible rows.
> I want to quickly delete unwanted rows from a file. I can use a custom
> filter to "hide" the unwanted rows, but I'd like to delete those rows.
> Any suggestions.
You need to choose a filter option which displays only the unwanted
rows (i.e. the oppos...Office Publisher 2003 email activity opens as a print publication
Using Publisher 2003, I click on "email" and then "activity". Then when I
select a template, it opens as a "print publication" instead, which doesn't
allow me to transfer it to the body of an email.
Any ideas why this is happening and what can be done about it?
That's how it works, although I've never done it that way.
I'd usually create the document first, then File | Send Email...
Microsoft MVP Expression
"Rob" <Rob@discussions.microsoft.com> wrote in message
Ok i updated my old outlook and because it was too much
for my system (like all windows updates) i uninstalled
oulook then reinstalled the old version now i have none of
my old emails and there not in my hotmail either and they
were going into both, hotmail and my outlook ~ so can
anyone help me? or is it lost forever
What is the version of your old Outlook?
Try to search *.pst file
"Robin" <email@example.com> wrote in message
> Ok i updated my old outlook and because it was too much
> for my system (like all windows upda...Recover Unsaved
I need help. Excel closed without saving what I was working on now I need to
You do not say how Excel closed or what version you are using. The later
versions have an AutoRecover feature.
If you closed Excel without saving the file, you may not be able to recover.
Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
"Tori" <Tori@discussions.microsoft.com> wrote in message
>I need help. Exce...O/L 2007 deleting valid e-mails
"all of a sudden" (after an update?) my Outlook 2007 has been sending inward
emails apparently at random to 'Deleted' rather than Inbox. In some cases
EVEN IF it's from a trusted address or if it's a reply to an e-mail I've
sent. I can trace no pattern as to why it does so. Junk Mail filter works
100% correctly, however, and Junk ends up in the right place.
Any cure?? Previous thread was inconclusive.
> "all of a sudden" (after an update?) my Outlook 2007 has been sending
...Permanently delete recycle bin give more free space to the server?
I hav a server running NT Server with Exchange 5.5, and set 3 days to delete
permanently all Deleted Items Folders. The info. on Private IS shows deleted
items has been deleted. Why the free space on the server has not increase?
Can I get more free space on the server by deleting permanently Deleted
Thank you in advance.
Deleting items from the database increases the amount of free space in the
database, but does not shrink the DB file. Do do that , you have to take
the daatabase offline and run eseutil...
http://www.microsoft.com/technet/prodtechnol/exchang...Help! I accidentally deleted emails that I desperately need to recover... Any suggestions please?
Desperate here! I have used LACIE back up, does it save emails?
On 1/26/10 10:20 AM, in article C7847266.27FB9firstname.lastname@example.org, "Gavin
Wilding" <email@example.com> wrote:
> Desperate here! I have used LACIE back up, does it save emails?
It depends on what you backed up. Without more details, we can't help.
You can use Switch Identity to access data in a second Identity.
Diane Ross, Microsoft Mac MVP
Entourage Help Page <http://www.entourage.mvps.org/>
Entourage Help Blog <http://blog.entourage.mvps.org/>
YouTalk <...Deleting an exchange 2000 server
Does anyone have any thoughts on how to remove an Exchange 2000 server that
doesnt exist from an Exchange ORG ? I know of a way to remove it using the
ADSI EDit utlity...
Expand Configuration (Server name)-->
CN=configuration,DC=.example,DC=.COM--> CN=Services --> CN=Microsoft
Exchange --> CN=Organization --> CN= Administrative Groups --> CN=(Name of
the RG or Admin Grop) --> CN=Servers --> Rt. Click on the server which you
wannna delete and delete it.
Can I / Should I delete this server from the members in the routing group so
no email gets routed to ...cannot delete text field
I have a shape group with a sub shape that displays one of the parent
shapes custom properties via a custom formula field. I inadvertently
added two of the fields so that now the data is displayed twice. When
I right click on the extra field in the "Insert Field" dialog there
is no drop down menu, just hitting the delete key does nothing. In
the shape sheet when I select the corresponding row the delete option
on the drop down menu is grayed out?
How do I delete this field?
Hey Guy don't abuse of the fresh beer when working on Visio (Dont be angry