every email is sent to two recipients
Just changed over from an eval copy of sbs2003 to a licensed copy and have been chasing several problems that never showed up in the original setup. Now every email sent to users mailboxes has two recipients in the to: column the first is the legitimate user address and the second is 'IMB Recipient 1'. What is an 'IMB Recipient 1' and why is it getting added to the to: address column.
Any help from
> Just changed over from an eval copy of sbs2003 to a li...Any way to change the Desktop Icon?
I have tried the old right click and properties but nothing for changing the
Anyone assist these very old (81) drybones?
What Desktop icon? The Windows Live Mail icon? Right Click | Properties |
General Tab | Change Icon.
Imperial Beach, CA
"drybones" <email@example.com> wrote in message
>I have tried the old right click and properties but nothing for changing
> Anyone assist these very old (81) drybon...Large amount of text in cells
I am having a problem getting Excel to display all text in a cell. I
am using Excel 97 and need the functionality to record large amounts
of text, as well as the calculation capabilities.
I know that Excel 97 will accept 32,000 characters in a cell and I am
not using anywhere near this. When I enter my text, it is no longer
displayed in the cell. It is there when I click on it but not when the
cursor is in another cell.
I attach a small file to explain what I mean.
Thanks in advance,
Please don't attach files - this is not a binary newsgroup.
XL cells can contain 32767...##### Date in Excel
Please can anyone help me.
I Microsoft Office XP
I had a very long list (about two thousand entries).
Each entry had a date in column B
Before I reformatted my PC I saved the document.
When I put it back on my PC after the format all the dates in column B have
changed to #######.
If I point the mouse curser over each entry it shows the original date
Can anyone PLEASE tell me is there a way to get thses dates back
Many many thanks
"Mandy S" <firstname.lastname@example.org> wrote in message
> Please ca...copying colored cells
I am trying to copy lots of cells to a new worksheet. These cells have their
font color red.(they happen to be table names). Tables do not have standart
rows, so i can use a for loop thing here:( or at least can image how to set
All I want to scan just A column, find red colored text and copy the text to
another workbook. Tried to to it manually but i happen to make mistakes:(
ps:as these are the table rows, they only have data in their Ax cells.
B,C,D.. are empty:)
note: Cannot filter to sort them out cause i will copy the table footers,
which contain prices. so ...Linking cells between two workbooks
I would like to link cells in two workbooks such that whenever a change is
made in the source workbook, the destination workbook cell changes as well.
Seems like a simple task in the Help menu, and I followed the directions.
However, although the value in the destination cell changes to the same value
as in the source cell when I hit "Enter", it only works that initial time.
If I go in and make a change subsequently to the source cell, the destination
cell stays the same. If I click on the destination cell, the current value
is shown in the formula field at the top, not th...CRichEditCtrl contents from RTF file
I have a Wizard based application, in which I have some property pages. In
one of the pages, I have a CRichEditCtrl, and I try to populate its contents
from a RTF file. The porblem is, it works correctly if the RTF file is small
(about 4-5 KB), but when I use a larger file, its contents either don't
display at all, or gets truncated.
The code is shown below. What can I do to show the entire contents of the
RTF file in the control? Also, it should work for all languages - I have
UNICODE defined in the project. m_RECtrl is the rich edit control.
static DWORD CALLBACK...OWA Question
Can anyone help me with this problem?
We use Public Folders on our exchange server in order to have a central
place to post info like programs, pricelists, telephone lists, etc.
We have some external users who wish to use Outlook Web Access (OWA) in
order to be able to view their mail. Because they're not in the USA, dialup
is not an option for them. Because they're satellite connected, they cannot
The problem with it that we've seen is Public Folders (and forms), which are
really 2 problems.
The folders display fine. The contents of them, the dates, etc. sh...Histogram in Excel
I have written a macro that uses the data-analysis tool to creat a
histogram. It turns out too small and I have to manually enlarge it. I
can't seem to do it in the macro, because one has to select thee chart
and I can't figure out how to do this since it reuires a chart number
to select it. And of course the number changes every time the macro is
So my question is: In a VBA macro how do I select the only chart when
I will not know it's number. Help will be appreciated. Thank you.
Some like this will select the most recent chart object on the activesheet.
Dim objCht...Excel 2003 help doesn't work. I got both Excel 2003 and 2007 insta
I have both Excel 2003 and Excel 2007 installed. The Excel 2003 help doesn't
work, but the Excel 2007 help works fine. When trying to open help in Excel
2003, the help window open, but it's all grey.
...Best way to maintain back-up of e-mails and contact data?
Does anyone have experience in maintaining a good back-up routine for the
data within Outlook for XP? I routinely back up all data files within my
documents, but find it difficult to manage the data within Outlook
You can setup Outlook so its data files are in My Documents
> Does anyone have experience in maintaining a good back-up routine
> the data within Outlook for XP? I routinely back up all data files
> within my documents, but find it difficult to manage the data within
> gregg gaskins
>-----Original Mess...How can I change which cell is selected next, other than Down, Le.
I know there should be a simple answer to this question, but I can't find it
on the "Help" menu.
tools / options / edit
"move selection after enter"
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Bethany" <Bethany@discussions.microsoft.com> wrote in message
>I know there should be a simple answer to this question, but I can't find
> on the "Help" menu.
and select one of...Easiest Way to do this Importing method?
Hey guys- been searching for a while now, and all the posts are a little
more complex than I think this needs to be. Can you help?
Basically, I have a CSV file that I need to import into another 'Template'
file. But- here's the key- not EVERY column in the CSV file needs to import
into my template. Also, the columns in the CSV file are NOT in the same
order they need to be in the Template file. So, I need to be able to pick
and choose which columns import and go where. Does that make sense? Is there
an easy 'import mapping' system to use or any other way to do this? ...Comparing more than two variables
I have some research data I need to tally and chart. I am looking at a
group of subjects that answered a 7-question test. I want to tally the
responses, and tally the total instances of each one compared to the others
(like how many answered yes to 1, 2, and 3 (or any other combination)). I
know pivot tables can give me 2 variables and how many of each gave an
answer, but I would like to do it for the whole test. Can anyone help me out?
For instance, example questions could be (for simplicity sake):
male or female:
age (0-20, 21-30, 31-50, 50+):
hair color (brown, black, blonde, or ...Quickest way to add one more name to a rule?
In OL2003, I have created a rule that if a piece of email arrives from
anyone on a certain list of people it automatically gets delivered to a
special folder "Work email". Every once in a while, I get an email from
someone who ought to be on that lsit, but isn't. So I go into Tools/Rules,
find the rule, and manually ad their name to the ever-growing list.
IS there an easier way to do this? Is there some way I can just drag their
name to the list somewhere?
(The closest I've been able to come to a shortcut is when the email is
opened, go to Actions/Create Rule, and ...Count worksheet with specific value in a cell
I was trying to locate (or simply count) from a list of 1000 excel workbooks
(which may contain more than one worksheet) with a specific value in a cell.
Say, the value "ak" in cell <R59>.
Would anyone show me the way, please.
I took this code from Ron de Bruin's web site and changed a few lines. It
goes through each Excel file in folder "C:\data" (change to fit) and counts
how many values "AK" are found in cell R59 , sheet1 of each file. Go to
Ron's web site for other macros to search workbooks:
http://www.rondebruin...Counting entries in two columns
I have a training schedule spreadsheet consisting of 5018
rows of data. Column 'D' contains the title of the course
each participant attended and in most cases this is
duplicated on different rows. This indicates the number
of participants that attended a particular course.
Column 'E' contains the date the training course held.
Some courses run 4 times in the year.
I want to count the number of participants that attended
each course on a particular day.
Any advice would be welcomed.
I would use a pivot table for this. see the fo...Merging Two Publisher 2003 doc togther
I have a magazine that i create in Publisher and i then get some more content
in Publisher that is done by another colleague.. I always have to print it
off speratley but was wondering if anyone knew if i could merge the two
togther and print it out as one
Using MS Publisher 2003 SP2
If it were me I'd make them both pdf files and then combine them with a pdf
It can be used with any pdf files.
Also, their PDF-XChange is a great pdf converting program.
...Turn off Assistance pane in Excel
How can I turn off the Assistance pane in Excel?
Not sure what you're calling 'Assistance pane', but try this:
Tools > Options > View
Deselect 'Startup Task Pane'
> How can I turn off the Assistance pane in Excel?
...search and return cell count
I have a list of dates. (certain dates are excluded).
I need a formula that would perform like a datedif and lookup formula.
Using two cell references, I need to be able to count the number of
cells (dates) between the reference points in a formula. Sort of like
a lookup formula that finds both values and returns the number of
cells in between.
search list for value in a1, search list for value in a2, how many
cells are in between
(there's no email, no snail mail, but somewher...Proper way to enter debt accounts
I've been using Money 2002 for about a month now to track my savings and
checking accounts. Now I'd like to enter the balances on my Car loan. What
is the proper way of doing this so that I can use money to 1) Track the
balances 2) Help give me some payment strategies to help me become debt fee
1) Create a Loan Account and schedule a series of Loan Payments. This will
allow the payments to automatically include an interest component.
2) Create a Liability Account and schedule a series of Bills. You will have
to manually enter the interest component o...How do I transfer Outlook contents to new computer?
I have a new computer and need to transfer my outlook over from my laptop.
Am using 2003, which is installed on my new computer also. I've been
searching these q&a's, and see that I will need to "copy to a pst file"? What
is this, where do I find it, and how to I execute it??? And if any of you
clever people choose to help me, you will have to talk r-e-a-l-l-y
s-l-o-w-l-y, as I'm very sorry, but I don't speak your language.
See if this helps
"Sarah" <sarah@discus...When I select "Open" from the "File" menu in Excel, I get only a .
When I select "Open" from the "File" menu in Excel, I get only a beep, no
file selection window appears. All other function in Excel seem to work.
OFF2000: Error Messages Caused by Nimda Virus When You Open or Save
Files in Office Programs
Something has broken that option.
You can reset the toolbar to see if that helps.
select worksheet menubar
With #2, you'll have to re-do any customizations you've done to that toolbar.
> When I...two letters upon another for math symbols
How is it possible to get two letters at the same place?
I have to create math symbols with a dot or a dash on top of a letter.
I know I can get these symbols whith shapes, but that is cumbersomely.
I am looking for some deadkeys or a vba-macro.
Most mathematical symbols are already available in the fonts
and especially arial ms unicode
> How is it possible to get two letters at the same place?
> I have to create math symbols with a dot or a dash on top of...display web pix in a cell
I want to display web pix in a xl cell, the cell has the url in it but I wat
the pic it references to displsy
AFAIK this is not possible with Excel's build-in functions. You'll need VBA
to achieve this
> I want to display web pix in a xl cell, the cell has the url in it
> but I wat the pic it references to displsy