RGreen wrote:
HI Don,

Unfortunately, I can't modify the original sheet: It will throw off the
formating which are setup for other columns and rows. Ron's scripts copies
what I have in my sheet to a temp sheet and from what I understand, it copies
that into outlook. I need to have that temp sheet to be setup with Autofit.

"Don Guillett" wrote:

column(bx).autofit

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RGreen" wrote in message
...
I am running into a slight problem. Using Ron's email script
(http://www.rondebruin.nl/mail/folder3/mail4.htm -- ex 1)

The cell width (Column BX) in my org spreadsheet is set to 7 wide, the
contents of that cell flows into the next several cells.

When I run the script it only shows the content of whatever is showing in
column BX -- trucating the over flow.

How do I resolve this: I hope its a simple fix, I am still trying to
understand how this script works.

Thanks,
Rick

I was about to suggest widening column BX or inserting a wide blank
column after BX, but I suspect that will upset your formatting too.
Sounds like the originator of this sheet didn't plan ahead very well.

Bill