Autofit Row Height #3
I have a column on sheet 1 that is set to wrap text so that the row height
increases and decreases as more text is entered into the cell. This works
Users enter a number on sheet two where there is a lookup function that
returns the appropriate text from sheet 1. The problem is that when the text
is returned by the function, the row height does not adjust to fully display
all of the text in the cell. Is there a way of automating this?
Any help would be appreciated.
...RMS Troubleshooting and Basic Set up v4/3/2005
I have decided to post the information on the net because ms newsgroup does
not have a long message retention.
Hi all just wondering why a user using outlook...send an email, then 8 mins
later the recipient gets the same email again>??
Very likely some intermediate SMTP server or Cisco firewall causing duplicates.
Compare Internet headers (time in Received: ) of two successive duplicates. The
first Received: with different times will preceed server, that is causing the
> Hi all just wondering why a user using outlook...send an email, then 8 mins
> later the recipient gets the same email again>??
> Any ideas....
Y...Deleting Non-Duplicate Rows
Have done tihs is the past, but can't remember how:
Have a sheet with 9500+ rows. Column C contains a storage bin number.
Want to delete all rows that DO NOT have a duplicate (trying to resolve
items that have a duplicate bin number.) Have sorted the sheet on
Column C. THX. . .
BillW's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27516
View this thread: http://www.excelforum.com/showthread.php?threadid=470299
You could use a helper column of formulas:
=countif(c:c,c1)...Converting Crystal report from MSCRM 1.2
I have a client who has upgraded to V3.0 for CRM. They want to continue
using Crystal for their reporting engine because they have 40 custom reports.
Does anyone know how to easily accomplish this? I have created a new
connection to the new CRM Views in SQL, but I can't seem to figure out how to
easily replace all the fields that are currently in the report using the SSO
connection to my new connection.
Any help would be greatly appreciated.
many of the services such as rpttosql.com say they will only convert so
far. some even say they will only get the general lay...Message Limits
Is there a limit to how many messages Outlook XP can import? If so, is
there a way to turn off the limit? Would I be able to import half the
messages then import the other half (thus avoiding the message limit)? Is
it just an import limit or does Outlook have a general limit on messages it
"Relax, its only ONES and ZEROS !"
What are you trying to import from and what kind of numbers are we talking
about here? :-) It might be easier to answer your questions (and give you
more precise answers) if there were more specifics to go on.
Jocelyn Fi...Disable recall message on the server
Is there a way to disable or turn off message recall on the server side? I
do not care if it still shows up on the users outlook client, but management
would like to make it so it never works on our server. We are using Exch
Debra <Debra@discussions.microsoft.com> typed:
> Is there a way to disable or turn off message recall on the server
> side? I do not care if it still shows up on the users outlook
> client, but management would like to make it so it never works on...Outlook 97 'hangs' at "deliver messages"
Outlook 97 hangs with deliver messages window open. No
mail is exchanged. Problem persists after deleting
profile and creating new one.
...Find feature does not work with HTML messages (Content-type: text/html)
I have Outlook 2000 SP-3 running under Windows ME. When using the Find
feature to locate all e-mails with a given word in the message, no items are
found if the e-mails are of "text/html" content-type. The Find feature
appears to work for any messages that have URLs embedded and are
"multipart/alternative" or "text/plain" content-type.
I noticed a similar post several months ago (see
Is there a work-around for this problem, or should this be reported t...Protection Problem #3
I have a 3 sheet excel file with protection on all 3 sheets (let's call
them A, B and C). These 3 pages have formulas that link to each other.
Sheet A has a few checkboxes that link to sheet C. The problem is that
when I try to check any of the check boxes on sheet A an error box pops
up that says "The cell or chart you are trying to change is protected
and therefore read only". Is there a way to protect a sheet while being
able to check a box off that is linked to another sheet? What protection
options would allow me to do this?
Thanks in advance.
----------...Wild curser #3
> Your scroll lock isn't on ... is it?
No, it isn't- thanks! I've tried putting it on and off a few times
just to double check.
...Outlook sending unknown hidden messages
My Outlook is sending hidden messages (as indicated by the status bar) when I don't have any, or sometimes one message, in my Outbox. They shouldn't be read receipts from legitimate Email, because I usually haven't opened any mail that contains receipt requests (I get VERY little mail from unknown sources, so I would know). I first noticed this when sending one piece of mail, and the status bar said sending 1 of 2 messages. Sometimes when I send one message it will start with "Sending message 2 of 3," then go to 3 of 3, and only then do the one message I ...Outlook not removing deleted messages from server
I have a gmail account and Outlook 2007 is configured to leave the messages
on the POP3 server, but to remove the messages from the server when deleted
from the "deleted items" folder.
So, I downloaded all of my email (approx 17,000 messages), deleted some
messages I don't want any more and emptied the "deleted items" folder, but
the messages are not removed from the server. I've tried it several times in
several different ways, always with the same result. I can delete the local
copy on my PC, but the server copy is never removed.
"sparx&qu...sending attachments #3
I downloaded all the security updates for Outlook 2000.
Now Outlook can't send attachments. The attachments
appear in the "send" directory, but the receiver of the
email gets no attachments.
The Outlook security feature blocks attachments that are potentially unsafe. This security feature provides an additional level of protection against
malicious messages. Although Outlook 2000 SR-1 or Outlook 2000 SR-1a blocks access to the attachment, the attachment still exists in the message.
For more information on resolving this issue, please refer to Knowledge Base art...Synchonization with SFO 3.0 performance
I would like to know if the syncronization of the Sales for Outlook has
better performance in release 3.0 ??
Is there a place i can find information on the way the new SFO is working ?
I was meaning 'Is there a place i can find information on the way the new
SFO is built' . Does it still use Cassini ?
> Hello everyone,
> I would like to know if the syncronization of the Sales for Outlook has
> better performance in release 3.0 ??
> Is there a place i can find in...MAPI Failure message using 2007 word
JOHN HASKINS I keep getting this error message when I try to send a
document from Word 2007 to my Outlook Email Client, which is my default email
setup. I followed the recommended steps that help feature suggested, but that
did not work by saving the document then closing and also closing Outlook,
which was when word would restart it would start a new MAPI Session. No Go!
What much I do. All other applications and software allow me to send to my
email client except Office.
...Excel 2003 fuzzy search for duplicate.
does anyone know of an application or vb code that can be
used to search in two worksheets (like VLOOKUP) on
similar matches using fuzzy logic? For example, if on
one sheet I have I.B.M and the other IBM or James Smith
on one and Jim Smith on the other, is there anyway of
giving confidence codes to the match?
Thanks very much for your help,
Look at soundex codes as explained by John Walkenbach
You can use the SOUNDEX function as a worksheet formula, and then use
VLOOKUP on that.
In your example, both James Smith and ...Publisher help #3
I created a website and i am able to upload it and view it in firefox but not
in any version of IE. Not exactly what i did wrong. But any help would be
Repost this question in microsoft.public.publisher.webdesign newsgroup and
add the URL to your problem website.
Microsoft MVP Expression
"Astroda" <Astroda@discussions.microsoft.com> wrote in message
> I created a website and i am able to upload it and view it in firefox but
> in a...Delivery Status Notification (Delay) #3
I have been receiveing several message stateing thet my message has been
delayed. Why is this happening and is there a way to configure this so that
the message does not become delayed?
below is a copy of the message that i receive;
This is an automatically generated Delivery Status Notification.
THIS IS A WARNING MESSAGE ONLY.
YOU DO NOT NEED TO RESEND YOUR MESSAGE.
Delivery to the following recipients has been delayed.
...Code to send SMS text message?
I would like to send an SMS text message to a cel phone via code within
Has anyone done this? What code / services / products do I need to
accomplish this? Does anyone have an example?
Thanks in advance.
What gateway are you using? What you would need to do is to snd a
internet message to a gateway provider which would then send the messae
out on the wireless land.
Most likely you are using a webpage interface from your PC to interface
with the gateway. So opening up an internet explorer and goiong to an
URL is probably the method to use.
...Recovering a message
I am fairly new to exhchange in general and am now migrating from 5.5 to 2003. I have turned on message tracking in 2003 but I don't see where we could actually recover the message itself. How do I keep copies of messages in an admin folder and then recover them when we need them. Lets assume that disk space is not a 'major' issue.
Message tracking isn't what you want, then - you want journaling (a copy of
all inbound/outbound mail for a particular store is directed to a mailbox).
What is it you're trying to do? This is going to make your backups a lot
more complicate...rule to move messages from senders who are on a personal dist list
I'd like to create a rule that will move messages that I receive from
senders who are on one of my personal address book distribution lists. I
would like to move the messages to a folder. However, when I try to create a
rule I get this message:
'Cleanup Address List' is a personal distribution list that may not be used
with this feature. Would you like to use the individual members of 'Cleanup
Address List' instead?
I am choosing "New Rule" then "Move messages from someone to a folder." Is
there some other way to accomplish this ...Integration GP 8.0 with CRM 3.0
Hi. i'm newbie in GP but i have been know CRM 3.0, i want to do integration
between GP and CRM using Microsoft Dynamics CRM Connector for Microsoft
Dynamics GP. After all installation and configuration, the integration was
work. I add an account in CRM then the account which i was added is display
in GP (as customer). But why the order between GP and CRM can't integrate? I
was follow the instruction in the integration guide. The guide book says that
the tax details, tax schedules, shipping methods, payment terms, unit of
measure, unit of measure schedules, price groups, price le...Multiple e-mail addresses #3
When a Contact has multiple e-mail addresses, how do I set
one of them as a default? Now, emails are going to ALL of
their addresses. Thanks-Rose
Is it possible to change the message class of a message via inbox rule so
that it could change from something (such as "Report.IPM.Note.DR") to just
I am trying to use inbox rules to move. redirect or forward these "delivery
receipts" and nothing seems to work while unattended (not logged into
mailbox). So I'd like to somehow change the message class then send it.