How do I expand the amount of text I can put in a cell?
I am entering text into a cell & can see it in the formula bar up top, but
it's giving me the #### in the cell that states it's too big. How can I get
it to show my text?
Put your cursor between the column you want to expand, and the column to the
right. When you see a four sided arrow, click and drag it to the right. You
may need to also Format, Cell, Alignment and click on Wrap Text.
Hope this helps,
> I am entering text into a cell & can see it in the formula bar up top, but
> it's giving me the #### in the cell...The mail is not automatically sent
We are sending a lot of mails daily from Microsoft CRM. The mails go out to
the customers both manually and also automatically from workflows.
Now I have created a new workflow which contains a mail.
The mail has automatically been sent before but after I added a GUID to a
serviceactivity (a link) in the mail the e-mail only appear as an activity so
I manually have to click "Send" on the mail to make it go to the recipient.
Does anyone have any idea why this happens and how I can solve it!?
Can you provide me with more details? , you have added the Guid to the ema...Outlook and message rules- can't get one to work?
I have set up message rules to divert mail from my inbox to various sub
folders or new folders. I use these:-
Check messages when they arrive\ from people or distribution list \ with
specific words in the senders address \ with specific words in the subject or
Now the problem is that some of the messages are recieved from people in my
address book and when they send a message sometimes their name and address is
in the 'from' and other times it is just their name and so the ones with just
their name do not get moved across to the folder I want. I have added their
name or...Mail format
If I attempt to send HTML mail, recipients outside our
corporation receive the message in rich text format. Other
doesn't have that problem. What settings should I check?
...sending mail to a cc domain...
I am trying to find out why my new exchange server 2003 install will not
allow users to sent to an email address email@example.com. Its like the
exchange server does no about the cc domain.
What NDR are you receiving back? Can you post it.
John Oliver, Jr.
MCSE, MCT, CCNA, Exchange MVP
Microsoft Certified Partner
"tim" <firstname.lastname@example.org> wrote in message
>I am trying to find out why my new exchange server 2003 install will not
> allow users to sent to an email address email@example.com...A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0
I have an application that will happily post 20TPS from 9 different
processes running on three different computers. In the middle of all
this happiness, I'll get about three seconds of:
A transport-level error has occurred when sending the request to the
server. (provider: TCP Provider, error: 0 - An existing connection
was forcibly closed by the remote host.)
and then posting returns to normal. Only one of the nine processes will
be affected. None of the applications are connecting/reconnection.
Each is using a dedicated SQLClient connection to a SQLServer ...Sending daily emails automatically
I am trying to send a daily email message automatically. For example
a safety message that will not change but needs to be sent everyday.
Rather than spend time each day cutting and pasting the message and
sending, can it be set up to send this message automatically? Is this
possible to do?
Take a look at http://www.outlookcode.com/d/forms/skedrpt.htm
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< &g...Can I make my Contacts Folder my Default
Does anyone know if I can make my contact folder the default folder rather
than the Global Address List?
On 3/8/2010 7:36 PM, Wendy wrote:
> Does anyone know if I can make my contact folder the default folder rather
> than the Global Address List?
Ctrl-Shift-B (or just click the Address Book icon)
Tools -> Options
Leonid S. Knyshov
Microsoft Small Business Specialist
Please vote "helpful" if I helped you :)
...Can't repair CRM
When I try to repair CRM on a few laptops, I get the following message:
Setup failed to locate binary file microsoft.crm.metadatahelper.dll verify
that the source folder is configured with Everyone Read Access.
I am trying to do a repair off the original CRM CD.
Any ideas why this is happening?
...How can I print page 2 of each sheet in a workbook?
If I understand your request, the first point to clarify is that "each sheet"
does not have a page 2 - If there are 10 sheets & each one contains 2 pages
of data, each page is still sequentially numbered 1-20.
One option is to select the area to be printed on each sheet and go to
File>Print Area>Set Print Area. Once you do this for each sheet, go to the
Print dialog box and select Entire Workbook.
...Where is Read All Unread Mail ?
Using Outlook 2003, had to re-create my profile due to corruption. And now
I no longer have a Folder title to display ALL UNREAD MAIL. Does this need
to be created somehow, so that it will display all unread mail spread out in
all the folders?
if the folder is not in the search folders, right click on Search Folders
and choose New. Its one of the predefined options.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips by...Week Numbers
If I enter a week number in a cell I want to have a formula that returns
the end date for that date (based on ISO week
This will depend on the Year
More info about week numbers you can find here
Regards Ron de Bruin
"gregork" <firstname.lastname@example.org> wrote in message news:email@example.com...
> If I enter a week number in a cell I want to have a formula that returns
> the end date for that date (based on ISO week
On Sat, 1...Can't find outlook archive.pst
I'm constantly getting "can't find Outlook archive.pst"
error message when I launch Outlook XP. Does anyone know
how to get rid of this error message?
Richard <firstname.lastname@example.org> wrote:
> I'm constantly getting "can't find Outlook archive.pst"
> error message when I launch Outlook XP. Does anyone know
> how to get rid of this error message?
Either create an Archive PST or disable archiving (Tools>Options>Other)
3290 Patterson Ave. SE, MS 1B3
Grand Rapids, MI 49512-1991
...Data Format: how can I re-format
The spreadsheet that was exported for me to use has the information in
It is customer ID name and billing info but it is like a long series of
I want to be able to have them listed under captions like company name,
contact, address, city, etc.. so I can use the data.
There is an empty row between each entry. Each entry is 3 or 4 rows.
There are about 500 records so i dont want to manually set them up.
Try tinkering around with these steps
Assuming your list is in col A,
data in A2 down
(If data starts in A1 down, insert a new row for the co...97: How can I find duplicate entries in a column?
Hello and thanks in advance for any help. This is a very basic question
from an even more basic user. I have a spread sheet with a long list of
ID numbers for skips. Sometimes duplicate numbers arise from paper work
from elsewhere and I get a false total of skips in hand. How can I
organise that column to highlight a duplicate entry please?
Message posted from http://www.ExcelForum.com/
Insert a helper column:
(adjust the range to suit.)
then the formulas that evaluate to more than 1 will be duplicated.
Chip Pearson has some other techniques at:
http://ww...Can a user's Worlplace be defaulted to a standard one
Is it possible to set a standard Workplace that users will see based on
either their role or team?
We have a client who wants to set standard worplaces for respective
Ian Watson had a good method--
"simply click on Workplace bar, then just above click on "personalize
Workplace" then tick on or off what you need"
This could also be done through changing the security role to allow
certain privaleges. You cant change a system security role, you have
to copy it and rename it. Settings | Security Roles | highlight the
role you want to copy | ...whihc microsoft office can i use to determine loan amortization
I am looking for programs wherein I can determine loan amortization
"Justin Reyes" <JustinReyes@discussions.microsoft.com> wrote in message
|I am looking for programs wherein I can determine loan amortization
You need Excel, not Access
remove nothing for valid email address.
...Can I access the previous version of a saved file?
I overwrote an excel file by mistake, using the save as command to an
incorrect file. Is there any way to recover the previous file before I
"saved as" over it?
I'm using Excel 10 (XP)......WinXP.......
If I have an existing file and open it, make some changes, then do a SAVE AS
and give it a different name, the newly "saved as" file is a completely
*NEW* file and the original is still in tact with the previous file name.
Try looking for the previous file name.
"JCC" <JCC@discussions.microsoft.com> wrote in message
news:9CAD1748-1D5C...E-mail not transferred outbox to sent item folder
Often I am experiencing a problem when I send an e-mail
through Microsoft outlook stand alone desktop regardless
with or without an attachment. The sent item does not move
from the outbox folder to the sent item folder, even
though the e-mail has been sent in most cases, I get a
message through the send and receive dialog box
stating "Reported error 0x80040109 unknown error
0x80040109". In some cases mail is sent normally and the
items are transferred to sent item folder and don't get an
error messages but it is more often I get the error
message and the sent item stays...Send page as (the body of the) email..., How?
In IE 6 > open a page *on the web*> File > Send >
Send page as email...> the result is a message with the page as the
But when I open a *local* HTML file, one on this computer, and try to
send as email, the result is a plain text email with the HTML page as an
Why is there a difference? And how do I "Send page as email" with the
page as the body of the message when the page is stored locally?
IE6 and Outlook 2003
* Nehmo Sergheyev *
> In IE 6 > open a page *on the web*> F...Chart turns gray.. can anyone help
Hi, I am working with a large file.. but not as big as
others. This one has a few charts. When I add another
it starts acting weird... turning totally gray unless I
click on it...? its it the fact that its not embedded or
not in front or in back of the worksheet? Thanks for any
helpful ideas on correcting this.
Go to Options on the Tools menu, click on the View tab, and under
Objects, select View All.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Steve Kay wrote:
> Hi, I am working with a large file.. but ...The e-Mail that wouldn't Die
ON Aug 12, 2005 I received an e-mail from a governmental website
notifying me of an event. Each time Outlook 2003 checked my SBC mail
server, it got the message again, and again, and again.
I deleted the messages, and they just keep coming back. I deleted them
all on friday. Today I had 389 of them. All from the same website, all
I figure the website's mailer is looking for some sort of confirmation
of receipt from Outlook and not getting it.
Any ideas on why this is and how to stop it? I've unsubscribed from
the site, by the way...
Do you have any Anti-virus or Fire...Can't link a graphic?
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
Email Client: pop
I've been told on this forums several times that one cannot have a graphic with live link in your email signature. <br>
Still, I've recently received a few email with small buttons that link to facebook and myspace in Entourage. How are these folks achieving this? thanks.
> Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Power
> PC Email Client: pop I've been told on this forums several times that
> one cannot ha...Want to fine tune VLOOKUP formula given last week
The formula shown below was working fine.
But as you can see for example between 0.75 & 0.8125 there are possible
input that will give an error message.
=VLOOKUP(I9, INDIRECT(VLOOKUP(D9, $P$1:$Q$9,2)),2,FALSE)
Current table below:
".500 Dia. Bolt
GRIP INCHES" Length (inches)
Until I tried to modify the table to cover ranges that the first table did
now I get #N/A
New table below:
".500 Dia. Bolt
GR...In POwer POint 2003 can I gradually add text in the same slide?
I want to gradually add text in my presentation within the same slide. For
ex: The beginning of an equation and click the mouse to complete the equation
as I explain it.
Read the instruction here:
Bart: "According to creationism, there were no cavemen."
Homer: "Well good riddance, their drawings sucked and they all looked like
"PP HELP" <PP HELP@discussions.microsoft.com> wrote in message
> I want to gradually add text in ...