splitting one column into two columns ... not what you think
i have fixed column widths that can't be changed; nor can any other columns
be added to the worksheet ...
i've got data in one column that represents "results" ... within the results
column though, i need two columns (starting directly below the "results"
cell, one that reads "in range" and that other that reads "out of range" ...
if i'm on [column a] [cell 1] i want: "results" ... in [column a] [cell 2] i
want: "in range" AND "out of range" with a line down the middle. "text to
column" is ...Finding duplicates in column
I have Excel 2002 and have 6000 emails addresses in a column.
How can I find if there are any duplicates in that column?
Assuming the data is in column A, add a formula in column B of
Cpy that down, then you can filter column B for Duplicate
Sorry to be so newby Bob, but when you say 'copy' down, what exactly do
I have entered the formula in B1 but..
Bob Phillips wrote:
> Assuming the data is in column A, add a formula in column B of
> =IF(COUNTI...HELP!! Viewing email images
I have just recently switched to using Outlook rather than
Outlook Express as my email program.
I now find that any image attachments (.jpg, .bmp etc.) I
receive are not visible onscreen as they used to be in
I have to click on each attachment icon to view...
It's annoying, especially if I get a series of pics...I
have to manually ope each one...
Does anyone know how to set Outlook so that it shows me
these images onscreen???
...I'm missing all past years emails in my hotmail account
For some reason i logged in into my hotmail account and noticed that all my
past years are gone. I havent deleted anything. I'm missing emails from 2006
till 2009 all of them? Please help....what can i do?
If the Hotmail account is set as your primary store, could it be that you
have AutoArchive enabled?
Tools-> Options-> tab Other-> button AutoArchive...
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and more
Real World Questions, Re...links in emails
When I try to open a link included in an email nothing
This problem can be caused by several different things. Do you receive an error message when you click on a hyperlink, or does nothing happen at all? Can you use hyperlinks in other programs,
such as Word?
Please have a look at the following Knowledge Base articles to see if these resolve your problem.
OLEXP: Internet Shortcuts in Outlook Express Do Not Start Web Browser
You can access this article by clicking on the link below.
We are using exchange 2000 sever. and we have one user on
one machine that her emails take awhile to process, up to
3hrs possibly. She is running outlook 2002, with all
updates as of 10/9/03. I have figured in the past that it
was just the other servers the mail was going through that
was slowing it down. But when she uses, another persons
acount on another machine it runs fine. Is this and
outlook/machine problem, a server problem, or a problem
that is out of my hands? Or is there a problem at all?
>We are using exchange 2000 sever. and we ha...New emails with attachments not being delivered
When I send a NEW email with an attachment to my husband, it is NOT getting
delivered, however, when I FORWARD an email with an attachment, it IS being
delivered. I've tried sending different types of attachments (Word, JPG,
Acrobat) and it doesn't seem to matter. None of them (as new messages) are
delivered. I can send the same message to his home computer and it gets
delivered, it's just his work Outlook that seems to be the problem.
My email address is on his list of safe senders. He can receive emails with
attachments from others, including his home compute...Trouble sending emails #2
I am recieving emails, but every time I try to send one I get an error
message saying, "The server does not support the required HTTP methods. Ther
server responded 'Not Implemented'." I have no idea wht that means or what I
need to change. Help!
On Thu, 30 Dec 2004 15:05:06 -0800, Tina wrote:
> I am recieving emails, but every time I try to send one I get an error
> message saying, "The server does not support the required HTTP methods. Ther
> server responded 'Not Implemented'." I have no idea wht that means or what I
> need to change. ...How can I tell if an email I have sent has been opened?
As per subject.
You can try using a Read Receipt but many users block the return of them
"AT" <AT@discussions.microsoft.com> wrote in message
> As per subject.
you pay for it:
you can try it out for a short time...then you pay...but it's pretty
much guaranteed to get you the results you want...
"AT" <AT@discussions.microsoft.com> wrote in message
> As per subject.
Request a read receipt.
it...How do I export my emails and folders from Outlook to Thunderbird
I'm trying to export my email from and all personal folders from Outlook to
Thunderbird. Any help would be appreciated. Thanks, Sam
...email set up in publisher
I set up a newsletter and tried to email it, a setup wizard came up and I
cancelled it. now I dont have the send button for emails. how do I get the
wizard or send button back? Cassandra
> I set up a newsletter and tried to email it, a setup wizard came up and I
> cancelled it. now I dont have the send button for emails. how do I get the
> wizard or send button back? Cassandra
Start either Outlook Express or Windows Mail (whichever you have); this
should prompt you.
You have to have Outlook Express, Outlook, or Windows Mail set as your
default mail client to ...How to forward emails (unchanged) from one account to another
Assume I manage two different profiles and eMail accounts with my Outlook.
How can I adjust in one of them that all arriving eMails should automatically be forwarded (unchanged !!)
to the other account ?
"Sven Claasen" wrote:
> Assume I manage two different profiles and eMail accounts with my Outlook.
> How can I adjust in one of them that all arriving eMails should automatically be forwarded (unchanged !!)
> to the other account ?
Automatically forward messages to another e-mail account - Outlook -
Microsoft Office Online:
http://of...How can I choose alternate rows in a column?
My requirement is to be able to create a column whose elements consist of
difference between adjacent elements in a column, say column A. If I can
choose alternate elements and create 2 new columns then I can just subtract
the 2 columns easily.
"pnair" <firstname.lastname@example.org> wrote in message
> My requirement is to be able to create a column whose elements consist of
> difference between adjacent elements in a column, say column A. If I can
> choose alternate elements and create 2 new colum...Assign values for one column to another.
I have in column T certain numbers and texts that that I require to assign a
value to as below, in the adjacent column. Again any pointers would be much
Well, imagine that two-column table occupies cells Y1:Z20. Put this
formula in U1:
and copy down.
Hope this helps.
On Oct 14, 4:26=A0pm, Celticshadow
>...Column styles doesn't appear on the worksheet
one of my customers has changed the windows xp designs to its own. From this
moment excel doesn't show the font color and the background color of a cell
in the worksheet. Only in the print preview you can see the color settings of
I'm not shure if this problem belongs to the changing of the windows xp
designs, but from this moment it did occur.
This occurs on new excel-documents and on existing ones. With another user
account on the same machine the problem doesn't occur.
I have reinstalled Office 2003 and even deleted user registry entries for
Office...multiple revieve of emails
I recieve multiple copys of emails in outlook. In some
cases I get 100 copys of the exact same message, in other
cases it is ok, then others many times Only one message on
Jim <email@example.com> wrote:
> I recieve multiple copys of emails in outlook. In some
> cases I get 100 copys of the exact same message, in other
> cases it is ok, then others many times Only one message on
Usually caused by 1) Send/receive interval too small or 2) server timeout
value too small or 3) rules that don't contain the "stop processing more
rules...Delay receiving email
We use Exchange 2000 and Windows 2000.
I have recently been expeirencing intermitent delays in receiving email from
two seperate domains.The delays are usually 3 hours but sometimes even
longer. In the header info the delay happens at the last hop before reaching
our domain. I have checked the exchange logs as well as the logs on our
gateway but they do not indicate any delay once we receive the email. I am
not sure what else I should do.
Any help would be appreciated.
...can you see what i am writting?
...How to get a macro to do what i want?
I have designed a form in Excel and the data that is inputted i want to be
able to save in a separate worksheet. The problem i am having is that
eveytime i record the macro, it over writes the same row each time (if that
makes sense). For example if i copied every cell in the form and paste them
into the database Row 1, i then want the new piece of information inputted
into the form to go into Row 2 and then Row 3 etc.... But it keeps going
into Row 1, it wouldnt move down the rows.
Hopefully this makes sense to someone and someone can give me some advise.
Calculate the last row
...I want to read,but:
The web display:
Directory Listing Denied
This Virtual Directory does not allow contents to be listed.
could you tell how to access another web like this?
"LeeTow" <firstname.lastname@example.org> wrote in message
> The web display:
> Directory Listing Denied
> This Virtual Directory does not allow contents to be listed.
> could you tell how to access another web like this?
looks like the link got wrapped, you may have to copy it out and put it back
or you could try this:
...Hide columns if there are no entry's in column
I have a workbook with multiple sheets. One sheet is a overview from
all the sheets and had all dates in it.
Is there a VBA to hide columns when there are no entry's in it?
The code has to work when I open the sheet "overview"
Hope someone can help me with it!
Thanks in advanced!
If you have a row that when blank would indicate which columns to hide, you could use
On Error Resume Next
Rows("1:1").SpecialCells(xlCellTypeBlanks).EntireColumn.Hidden = True
MS Excel MVP
<email@example.com> wrote in message news:118...Missing column letters
I have lost the letters at the top of my columns and the
numbers to the left.
I don't know what I have clicked! Any help is appreciated!
tools / options / view tab
ensure row & column headers are ticked
"Julia" <firstname.lastname@example.org> wrote in message
> Hello there,
> I have lost the letters at the top of my columns and the
> numbers to the left.
> I don't know what I have clicked! Any help is appreciated!
...How can I cut data out of HTML table, into msExcel and just take the data & columns? (but NOT the formatting & URLs!)
This is driving me ABSOLUTELY NUTS!
How can I keep the rows & columns of data that I am copying and pasting
off a website (my own in this case!), into a spreadsheet... WITHOUT
taking all the data formatting?
If I paste out of Ms IE v6 into Ms Excel (2003), it does at least keep
columns (something that doesnt happen if I paste out of FireFox, fwiw).
But it pastes with all the formatting & URLs etc - which I DONT WANT!
OK, I can save as .CSV, close, 2 warnings, and re-open but when done
REPEATEDLY this is a damned nuicance!
ship w...cant send emails 02-14-10
I have tried everything you guys have suggested in the other posts, including
uninstalling and reinstalling the mail software. I have two email accounts &
neither will send. It had been working since Nov 09 and just suddenly
stopped. I have windows 7 & windows live mail. Here is the error I keep
Your server has unexpectedly terminated the connection. Possible causes for
this include server problems, network problems, or a long period of
This is the local server I use.
Subject 'Fw: Fwd: xoxo'
Window...Exchange 2K: Controlling incoming email formats....
AFAIK (and correct me if I am wrong), Exchange natively only lets you
control message formats for messages that are downloaded to POP\IMAP
For security reasons, I would like Exchange to convert all incoming\outgoing
email from\to external domains, as well as INTRA-domain email , to plain
text format. In other words, I do not want to see anymore html email on my
server going in and out, just plain text.
Is there a setting for this for Exchange to handle this natively? If not,
what (if any) 3rd party solutions are out there for this?
Here's the Re...