Select data from Excel to carry to a Word document

[ng4330]

First off, first post here...I have just enough knowledge of Excel to come up with ideas but not enough to actually execute them and I have no programming knowledge. I'm a police officer and am trying to make an excel sheet to track info on households with alarms in our jurisdiction. Basic idea at this point for the sheet: Columns of Names, Addresses, Date/Times of alarms we receive. After 3 false alarms at a residence, that household gets a warning letter from the Dept. This warning letter is a Word doc which I print out and has the resident's name, address and the dates/times of the false alarms. To save time, I'd like to select a row in Excel for the household being warned and have the info from the Name and Address columns transferred to the head of the letter and the info from the Dates/Times columns transferred to the body of the letter. Can anyone help me with this, point me in the right direction? I've searched various places over the past few days but I'm not sure how to word my search to bring up what I want and have not been able to find any info on exactly how to accomplish this...or even confirm that it is possible. I'm using Word 2007 and Excel 2007. Appreciate your time.

[Tracyann]

This website might be of help http://www.lockergnome.com/it/2005/1...ata-into-word/

[pmalen]

Why use Word at all? I have attached a file with a simple database and a pre-written form letter. Just change the record # on the letter tab to change the person's name and address. Play around with it. Kept it simple. Let me know if it works.

Paul

[ng4330]

pmalen- Thanks for the idea...I like that concept. Appreciate the sample you made up with directions...very very helpful! The issue I'm having is formatting the letter part in Excel. Not really lending itself to word processing compared to Word. I'm going to keep screwing around with it to see if I can get it to look decent though.

[pmalen]

You could try inserting a text box and put standard boilerplate language in the text box, then have a section that references the info from the database.