Software

Ask something
Discussion Locked

Excel forms and e-mail

0 helpful
3 replies

by webwench

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a client who uses Excel forms for doing quotes and then e-mails the quotes to clients. The Excel sheets are password protected. They also have protected and unprotected cells so the form is easy for the users to navigate in and fill out. Theforms have the grid lines and row and column headings shut off so the form looks more like a form and less like a spreadsheet. The problem is that in some instances (not all but enough of them) the column widths are not maintained after the quote has been e-mailed to a client. The column with the dollar amounts is coming up ###### even though the version at the office shows the column as being wide enough and the numbers display fine.

What's going on and how do I account for it? I don't have too much more room on the form to widen the column by a bunch and still keep it within the print specs for an 8x11 print.

Thanks,
H. Hamilton

3 replies

by dklippert

The column width can be determined by video drivers/resolution as well as the default font:
Here are a couple of articles. Type one of the following in the address box of I.E.:

MSKB Q73591

MSKB Q214123

Here is some macro information:

MSKB Q149241

MSKB Q213422

One suggestion might be to use a macro to merge the data into a Word document. Word has much better formatting control.
(Yes, I know. I once had a co-worker who did all of his letter writing in Lotus 123)

by webwench

The MS articles were very helpful. Thank you.

H. Hamilton

PS Excel is used because there are calculations based on % discounts by line item etc. (complete with absolute cell references for grand totals).

This discussion is closed to new replies.