Attachment to Cell

[Worzel Gummidge]

I am creating a spreadsheet that will monitor correspondance with people.

What I am hoping for is for, within a cell, I would like to insert a little
symbol (MS Word symbol). When this document is opened, I would like for a
standard premade letter template to be opened. Within this letter,
information will be completed automatically (this information will be taken
from the details within the row - name, address, reference etc....)

Any ideas if / how this can be done?

Thanks

 

[Don Guillett]

Why not just use Excel for all of it. Create your form letter in excel with
formulas to the data sheet

="Dear " & data!a1 & ","

="Now is the time " & data!a4

 

[Worzel Gummidge]

Ideally, I'd prefer to use MS Word. The reason being that the spreadsheet
will be used by multiple users and a lot of them are not used to using MS
Excel. Subsequently, I'd prefer for the letter to be created in Word as most
users will be more proficient in Word

 

[Don Guillett]

What's to get used to. Put in the data and print the letter....