ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Packaging Word & Excel files for emailling to preserve links (https://www.excelbanter.com/excel-discussion-misc-queries/117718-packaging-word-excel-files-emailling-preserve-links.html)

BOBODD

Packaging Word & Excel files for emailling to preserve links
 
Is there anyway way to package an Excel 2003 workbook & and a Word 2003
document so that they can be emailled without all the links between the files
being broken?

I have tried embedding one file in the other (both ways - Word doc in
excell, which loses headers & formatting, & Excel in Word, which breaks all
the links when the file is closed) but this is not satisfactory.

I'm using a worksheet with a series of dropdown boxes to generate a quote &
output the quote as a text string to a single cell. The cell is then linked
to the word document which is our quotation form.

Carole O

Packaging Word & Excel files for emailling to preserve links
 
Suggest you think about changing your quote form to Excel. Excel does a far
better job and offers more options in form design than Word.

Carole O

"BOBODD" wrote:

Is there anyway way to package an Excel 2003 workbook & and a Word 2003
document so that they can be emailled without all the links between the files
being broken?

I have tried embedding one file in the other (both ways - Word doc in
excell, which loses headers & formatting, & Excel in Word, which breaks all
the links when the file is closed) but this is not satisfactory.

I'm using a worksheet with a series of dropdown boxes to generate a quote &
output the quote as a text string to a single cell. The cell is then linked
to the word document which is our quotation form.



All times are GMT +1. The time now is 05:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com