Emailing form in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

My users need to input the details of a quotation into a table in my
database, i have designed a form for them to do this. They then need to email
the details out in Excel. However i want it to look identical to the form i
created.

I know i have a couple of options, design an identical report and put this
into excel and then email it, problem here is, it doesn't look the same when
i put it into Excel, all the columns are the wrong size, the formating
disappears, my form/report has new lines in cells too which seem to upset
excel.

I thought maybe, i could make a template or something but i don't want each
one to be saved with a different name because we are trying to get away from
having the users save multiple copies of virtually identical things because
then they use the wrong one. I also thought maybe i could use the template
just as a template but then could my users all use it at the same time, i'm
not sure but i think not.

I can't use snapshot format either as our end users may not have snapshot
and can't get it.

Can anyone help or make a good suggestion.

Also as an extra which would be fantastic, is there anyway i can
automatically read-only password protect the finalised excel spreadsheet
before it gets attached to the email.

Thank you very much for any help you can give......
Emma
 
If your users have no plan to make changes to the information on the report,
they can email it as a rtf (rich text format) file, which will open it in
Word. And it will have the way you have on your report.

The other option is if you have Microsoft Office Document Imaging, you can
send the report as a tif file.
 
My end users may ned to make changes which is why i need Excel, additionally
the format doesn't come out right in rtf either.

We don't have Microsoft Office Document Imaging unfortunately.

Does anyone have any other suggestions?
 
Back
Top