pasting into merged cells #2
Every time I try to copy and paste data into a merged cell I get error
messages about the cells not being the same size. Even if I try to just
paste values only. Is there any workaround or fix for this???
Try pasting into the formula bar. It's a pain, but it
>Every time I try to copy and paste data into a merged
cell I get error
>messages about the cells not being the same size. Even
if I try to just
>paste values only. Is there any workaround or fix for
See my res...Viewing IMAP messages #2
I connect to a Linux IMAP server remotely for my emails. When I click on an
email in Outlook P once the headers have been updated the system seems to
download the email and the attachement. All I want to do is read the message
before I download the attachment - Is this possible?
Its a bit of a problem if an email has a 3mb attachement and all I want to
do is read the mail content before deciding to download the attachment -
especially a pain if I am CC into some mail.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
I am trying to use Sumproduct with dates that come off an SQL databas
and are in the format of 02/12/2003 15:30.
This is forcing me to use the following formula
where $G3 is 02/12/2003 00:01 and $G2 is 02/12/2003 23:59
Is there any way I can just look at the date only rather than the time
as well, so that anyone can enter a date from, and a date to
~~ Message posted from http://www.ExcelTip.com
~~View and p...Work out overtime hours for individuals #2
I have a question which i am hoping someone will eb able to help me
with, i have a spreadsheet which contains infromation for part time
hours worked during the course of a month for individuals (e.g. below)
Name Start End Hours
Persona 1:30 2:30 1
Persona 3:30 4:30 1
Persona 9:30 11:30
person d etc etc
What i need is a formula that will allo wme to add an extra column
which gives me the total hours person a worked, person be worked and so
on. The original data contains multiple lines (i.e persona could have
10 lines, personb15 lines etc etc), and...Strange error message
I am getting a strange message when I am trying to copy a
graph that I use in a payroll document that we use. It
contains data and a graph for each employee. It worked
just fine for 80% of the document then all of a sudden I
started to get this message: "No more new fonts may be
applied in this workbook" with an OK button. I can hit
the OK button and it will eventually continue on (after
multiple clicks). But each time I copy and paste the
graph, it gives me this message.
I am using Excel 2002 on Win 2000 Pro with all the latest
updates and patches available. T...Excel Formulae #2
I have a spreadsheet with value in one column & a series of dates in 5
other columns.For each row depending on the value
in the first colunm a date may be applicable in one or more of the
other columns.e.g 550 in the first column will mean dates will be
inserted in the next 2 columns similar to authority levels. My qn. is
how can I show what's outstanding if the relevant authority levels have
not signed off-basically this is used as a tracker of invoices & I
would like to show what is outstanding awaiting approval at anytime.
----------------------------------...Authentication Error after restoring SQL databases
Our CRM Development Team messed up our dev server and asked our SQL dba to
restore a two day old SQL backup of the MSCRM and METABASE databases. After
the restore, the CRM app. is unaccessible through the browser (
Authentication Error. Microsoft CRM could not log you on to the system. Make
sure your user record is enabled and that you have been assigned at least one
security role. For more information, contact your system administrator. )
Using the Deployment Manager only the License Manager information are visible
and neither Server Manager nor User Manager. It seems like the applicat...Making cards --2 to a 8 1/2 x 11 page
I want to make cards to send out for memorials, etc. I want 2 cards to a
page, top folded 5 1/2 x 8 1/2. What happened to the old Picture It!
Do you want to make these cards in Publisher?
If you do, look at page setup, folded card, tent card, width 4.25, height 5.5.
Publisher will say it will print two pages per sheet
Mary Sauer MSFT MVP
"A Holt" <A Holt@discussions.microsoft.com> wrote in message
>I want t...Synchronize data across 2 sheets
Excel 2007 Workbook with a sheet called 2010 around 700 rows/records and a
sheet called Previous around 5000 rows records.
Both have 31 columns and identical column headers
On the 2010 sheet there are records that have changed, how do I get the
changed records details onto and overwite the same record on the Previous
Not sure if it would help but each record has a unique reference number.
How do i do this ?
Hope this makes sense
thanks for any help offered
If you know which colums are to be changed I would use vlookup function.
Vlookup(lookup valu...MS Office VBA Automation Specialist #2
is there such a certificate? MS Office VBA Automation Specialist, I tried
googling it on microsoft website and couldn't find any info. I just passed
the excel 2k expert exam and I want to take the excel instructor exam, I
haven't however been an instructor. is it possible to take the exam without
an instructor experience?
last but not least, I am thinking about putting together some excel webcasts
for beginners for free. I have always liked to learn by audio/visual versus
reading so I am thinking about implementing this...
here is the link for the first test webcast ...WIN98 Outlook 2000 Distributed Authentication Error
Using WIN98 2nd Edition and Office2000 Outlook.
Dial-up connects to internet fine and operates fine,
Outlook comes up fine and logs into e-mail server, however
just before e-mail is supposed to start downloading I get
the following: "An error occurred loading the Distributed
Password Authentication Components." After clicking OK,
get message box "Microsoft Server Extensions" and
message "Unable to read configuration information for
Microsoft Personal Web Server error code 1723."
Uninstalled Office2000 and totally reinstalled, only to
get the same exac...Invalid sender domain
Your message did not reach some or all of the intended recipients.
Subject: RE: Boat
Sent: 4/17/2006 11:19 AM
The following recipient(s) could not be reached:
'Fahlahas@Surgv.com' on 4/17/2006 11:19 AM
554 Fahlahas@Surgv.com: Recipient address rejected: invalid sender domain
Dan Klinge <Yomama@kdkdjkfjdekfjdkfj.com> wrote:
> Your message did not reach some or all of the intended recipients.
> Subject: RE: Boat
> Sent: 4/17/2006 11:19 AM
> The following recipient(s) could not be reached:
> 'Fahlahas@Surgv.com' on 4/17/2006 11:19 ...Credit Card Expiration date error
We are getting an error message for credit cards with expiration dates
greater than 2010. Has anyone else seen that? We are currently on RMS 1.2
using PC-Charge. It takes expiration dates through 2009.
There is update for 1.2 to 1.3 and also in 1.3 there are patches available
kindly download from customer sources this will resolve the issue
> We are getting an error message for credit cards with expiration dates
> greater than 2010. Has anyone else seen that? We are currently on RMS 1.2
> using PC-Charge. It takes expiration dates thr...Download email #2
How to download email from Microsoft exchange 2000 to
Outlook Express?? without leave a copy at Exchange server.
Outlook Express cannot download mail from Exchange. Why are you trying to
do so without leaving a copy of the mail on Exchange?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Edi asked:
| How to download email from Microsoft exchange 2000 to
| Outlook E...Error 0x80ccc0f
This is becoming a real PIA! I can be using Outlook for hours or only minutes and get this error. When I shut the program down and re-start it, it again works for hrs or minutes. Nothing I do seems to make a difference one way or another. Anyone have a suggestion?
Outlook 2000 SP-3
Yahoo Mail Plus (default)
OS Name Microsoft Windows 2000 Professional
Version 5.0.2195 Service Pack 4 Build 2195.
Submitted using http://www.outlookforums.com
Are you using a Linksys router?
Linksys routers have a history of problems with ma...Error 0x800CCC13 in Outlook
We have several clients using a variety of Outlook versions (2000/XP/2003).
Our mailserver is Exchange 5.5 running on a NT4.0 server, all availbale
patches applied. All of a sudden clients can't send messages, the get error
I've looked up in TechNet and removed IE and OE completely, rebooted and
reinstalled IE and OE, because of KB312349. Without any improvement. The
problem is gone when removing the MS Exchange Server from the accountlist.
Sending and recieving using POP3/SMTP does work. When the Exchange Server is
selected but the primary storage location is ...Outlook2003 error
I am getting an error message when i try to compus a new
message...''The messaging interface has returned an unknown
OS=W2K with SP4
Please help me
Thx in ADV.
...CRM 4.0 "An error has occurred"
I did an upgrade from CRM 3.0 to CRM 4.0. First I upgrade Sql2000 to Sql2005
SP2 and then upgrade CRM.
I have issue when create new case and tried to assign responsible contact.
The application show “An error has occurred”. This form did have a
customization in java to filter the contacts to show only the contacts for
the account. I removed this customization for the form, but still have the
I look for any Service Pack or Hot Fix but no found any.
Any idea will be appreciated,
Jose Valentin Rodriguez
the problem is that you used a (very...LDAP Error in Outlook 2003
I just upgraded to Office 2003, and now when I go to Outlook to try to send
an email, I get an error that says "Can't contact LDAP server (81)". I can
eventually send the email, but I get that message several times.
FIGHT BACK AGAINST SPAM!
Download Spam Inspector, the Award Winning Anti-Spam Filter
You receive a "Can't contact LDAP Directory server (81)" error message when
you open the Address Book in Outlook:
http://support.microsoft.com/default.as...Printing through MFC
I want to print a html file through MFC application.
How can i do this? I have bypass print dialog window. Thanks for
On 1 May 2007 23:21:28 -0700, Manu <firstname.lastname@example.org> wrote:
> I want to print a html file through MFC application.
>How can i do this? I have bypass print dialog window. Thanks for
you might consider using and embedded webbrowser control in your MFC
You might Google for some code samples, e.g. on CodeProject.
I found the following url:
http://...Field Chooser #2
Guys-is it possible that some of the fields in Outlook
2000 (from Field Chooser) can simply disappear or could
the problem be that somebody else is accessing my mailbox?
It happened to me that the From field and Subject field
have simply disappered twice without my action? Could it
be a bug or something similar?
Is it possible those fields are already in the table view? I've been spooked
by that one before.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstar...Publisher 2003 won't print
I have just taken over writing a newsletter which is 8 pages with LOTS of
photos and graphics. It needs to be converted to a pdf file for publishing
on our web site.
I tried using Publisher 2003 this last month and after many days of putting
the newsletter together and getting it just the way I wanted it, it totally
failed to convert!
It wouldn't print to my HP 6110 All-In-One Printer either!
My computer is a PC with XP and service packs 1, 2 and 3.
I am using Adobe 8.0.1.
What could be wrong?
I was able to copy (with much exasperation) the whole thing on to Word 2003
just to get it ...Error 553....rcpthosts...
I am receiving the following error message:
Your message did not reach some or all of the intended
Subject: After Upgrading to 5.0 Receive Fatal Error
0 Message on Build
Sent: 10/24/2003 10:43 AM
The following recipient(s) could not be reached:
'email@example.com' on 10/24/2003 10:43 AM
553 sorry, that domain isn't in my list of
allowed rcpthosts (#5.7.1)
I have viewed some of the other posts and done what is
recommended, such as authenticate outgoing messages with
my username and password. This does not work. I have 3
di...error (0xc0000135) when clicking in an E-mail
I recveive error (0xc0000135) whenever I click on an object in an E-mail. I
have downloaded various .net files with no improvement.
Bummer. Try reading the link in my signature and post back with accurate
and helpful information.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
ALWAYS post your Outlook version.
How to ask a question: http://support.microsoft.com/KB/555375
After furious head scratching, Joe E Hogel asked:
| I recveive error (0xc0000135) whenever I click on an object in an
| E-mail. I have downloaded various ...how to merge data from multiple columns to one column #2
I have first, middle, and last names in A, B, and C. I want to merge
everything into A. Ho do I do that?
In column D use the formula
=A1&" "&B1&" "&C1
The " " would put in your spaces in between the names.
Then go to column D & do Edit Copy, move to column A & do
Edit Paste. Then you should be able to delete columns B,
C & D.
Hope that helps!
>I have first, middle, and last names in A, B, and C. I
want to merge
>everything into A. Ho do I do that?