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...Outlook appearance
My "subject", "CC" and "from" fields have disappeared when
opening/sending a new message. How do I get them back?
That would depend on your Outlook version and the editor you are using,
neither of which you mentioned.
"Simonis" <firstname.lastname@example.org> wrote in message
> My "subject", "CC" and "from" fields have disappeared when
> opening/sending a new message. How do I get them back?
...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" <email@example.com> wrote in message
> I just received a CD with all of my recovered outlook xp
> data from a failed hard drive: ho...Not receiving email in outlook
Help!! Pc challenged here. I'm sending mail in Outlook with no problem, but
not receiving any new or return mail. Running XP, SP2.
Do you get any errors when you try to receive mail? Also, you mention XP. Is
that your OS or version of Outlook?
"Paula" <Paula@discussions.microsoft.com> wrote in message
> Help!! Pc challenged here. I'm sending mail in Outlook with no problem,
> not receiving any new or return mail. Running XP, SP2.
Hi Vince, and thank you for responding. XP is my ...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" <firstname.lastname@example.org> wrote in message
> Someone was helping ...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...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.
...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.
<email@example.com> wrote in message
>I get an error when I try to "delete all transactions" from the
> "Store" then "Database" menu. the error says "Could ...How do I control where the new message window appears?
Whenever I create a new message the associated window appears with the
maximise button off of my desktop.
How do I change the default position of the new message window such that all
of it is visible on my desktop?
Resize and position it accordingly and hold CTRL when press the X to close
the window. This should force storing the location and size of the window in
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, R...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.
-...outlook errror msg
I received the following error msg when trying to send a msg in Outlook 2k2.
"An internal support function returned an error"
I tried to do a search on KB, but could not find anything. This is the first
time I have received this message.
...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?
...Outlook Web Access Web Administration
I have downloaded the Outlook Web Access Web Administration package,
installed it onto a Windows XP machine that is part of the same domain as the
Exchange 2003 server we are running. I have ASP.net, .NET, IIS all running.
When I attempt to connect to our Exchange server, I get a "page not found"
error. When I connect to my own machine, I get a broken page with lots
I have read the Readme, read numerous postings online, and I cannot seem to
find anyone else that is having the same difficulty in getting to Outlook Web
Access Web Administration to run properly...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...Excel
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...Outlook XP Menu Locks
Odd issue has just popped up. Outlook XP on a few different computers this
week all ahve gotten the same issue. While working in a new email, or while
a few emails or drafts are open, the toolbars and menus all become locked.
Can't click on any of them. Hot keys like Ctrl + C don't work either. The
only option is to close down all of the drafts or messages opened to get it
working again. This just started this past week and is happening on multiple
What is weird, we have Access 97 on these computers as well. It too is
doing the same behaviour while c...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
..."File Format is not valid" message
I have a spreadsheet that I've been using successfully. I don't recall
anything that might have caused file corruption. However, now, when I try
to open the file, I get the message "File Format is not valid". But, the
excel icon is shown and in a file list, it's displayed as type Excel. Any
ideas how I can open this file??
Thanks in advance.
The message you sent later appears to have been to
cancel this post you said it was a Word file with an .xls file
extension. Opening an Excel file in word is one way of
destroying an Excel file.
If that is the ...Attachments in Outlook express #4
Does anyone know what to do when everytime you get sent
an attachment it says "OE removed access to the following
unsafe attachment" It is happening with all kinds of
attachments for example word. I know these attachments
are safe and do not contain viruses. How do I view them?
Albert <firstname.lastname@example.org> wrote:
> Does anyone know what to do when everytime you get sent
> an attachment it says "OE removed access to the following
> unsafe attachment" It is happening with all kinds of
> attachments for example word. I know these att...How to I set page 1 of 6 in Word?
In a multi-page document, I want "Page 1 of 6" in the footer, or if the
document gets longer page 1 or 7 or page 1 of 8.
Use the fields "Page" and "NumPages". The first will display the number of
the page you are on, the second will display the totall number of pages in
Assuming Word 2007, you can insert fields through the "Insert" tab, "Quick
Parts" button, "Field..."
"Ted" <Ted@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...Outlook Live and two hotmail accounts
I have just upgraded to Outlook Live (ie 2003). I run this on an XP
I have two hotmail accounts which I wish to access with Outlook. One works
fine, but the other doesn't. The two accounts have different .NET logons
(whatever that means). I go through the procedure to add the offending
account using Outlook Connector. It duly appears on the list but when I
try to open the folder, it complains with a message "This folder could not
Both hotmail accounts are Hotmail Plus. The only obvious difference is
that the misbehaving one is '@hotmail.co.uk'...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