Copying info from cells and putting them into a letter

  • Thread starter That's Confidential
  • Start date
T

That's Confidential

I have a few columns in various sheets in a document, say columns A, B and
C. The range of the cells within these columns is from 7:31. Now what I
would like is for, in a new sheet, I am going to create a template letter
sheet, "sheet13". Now everytime, I enter information in any of the cells
within the columns, A, B and C, I want the information to be copied over
into my template letter sheet, "sheet13". As the information will remain in
my spreadsheets for a while, I only want the information copied over from
new information which has just been inputted that day. I could maybe create
a cell which has the options yes or no for contacted, and so if the answer
is no in this cell, then a letter will be created using the info in that
cell!

Any suggestions if this makes sense?
 
T

That's Confidential

I have just read over my first message and it was a bit jibberish so here's
what I want. At the end of a row, I will have a box which when clicked on
will run a Macro to create a letter. Now can this letter be created in MS
Word? If not, then I would like a template to be created as an Excel
document. If it is easier to, I can save the letter template, so that when
running the Macro, within the Macro code, somewhere it can be written "open
###### document." Now, in cell A2 of my template document which will be
saved, I want the name written in D3 of the row which the button to run the
macro is on. Then in cell A4, I want the number which is in F3 of the row
which the button to run the macro is on to be copied over. Finally, in A6, I
want the date which is in G3 of the row which the button to run the macro is
on to be copied over into this letter sheet.

Any hints? I know this is long winded but it's hard to explain!
 
D

Dave Peterson

I think I'd use mailmerge inside word.

Some links:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

Then I'd use a helper column and put an X in it. Inside the word, I could
filter on that helper column and only include those rows with an X.

Then after I got everything correct, I'd wipe out those X's in excel.

You could use Data|filter|Autofilter within excel to show just the nonblanks and
get them all at once.
 
Top