software

We have an Excel spreadsheet for all 1200 of our employees with name,
department name, SSN and birthdate. I have added another field to sort by
birthmonth only. I can easily sort by the birthmonth, but I need to produce
separate letters to each of the relevant department heads IF they have an
employee due a test each month, listing the employees only for that
department. I would like to automate this procedure with linked files or a
query or some other way rather than do cut amp; paste, if possible, but I am at
a loss how. Can anyone help me out?

Thanks,
Richard
--
Richard

quot;Richard Rquot; gt; wrote...
gt;We have an Excel spreadsheet for all 1200 of our employees with name,
gt;department name, SSN and birthdate. I have added another field to sort by
gt;birthmonth only. I can easily sort by the birthmonth, but I need to produce
gt;separate letters to each of the relevant department heads IF they have an
gt;employee due a test each month, listing the employees only for that
gt;department. I would like to automate this procedure with linked files or a
gt;query or some other way rather than do cut amp; paste, if possible, but I am
gt;at
gt;a loss how. Can anyone help me out?

If you could provide each department with a printout, all you'd need to do
is select all your records and use Data gt; Filter gt; AutoFilter. Then select
department and birthmonth from the dropdown lists for each field, and print
that department's monthly listing.
Maybe you could use MSWord's mail merge (and keep the data in excel).

Here are a couple of links:
www.mvps.org/dmcritchie/excel/mailmerg.htm
www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.
Richard R wrote:
gt;
gt; We have an Excel spreadsheet for all 1200 of our employees with name,
gt; department name, SSN and birthdate. I have added another field to sort by
gt; birthmonth only. I can easily sort by the birthmonth, but I need to produce
gt; separate letters to each of the relevant department heads IF they have an
gt; employee due a test each month, listing the employees only for that
gt; department. I would like to automate this procedure with linked files or a
gt; query or some other way rather than do cut amp; paste, if possible, but I am at
gt; a loss how. Can anyone help me out?
gt;
gt; Thanks,
gt; Richard
gt; --
gt; Richard

--

Dave Peterson

Ignore this.

I misread the question. But if you ever wanted to create separate letters for
each person, it might prove useful.

Dave Peterson wrote:
gt;
gt; Maybe you could use MSWord's mail merge (and keep the data in excel).
gt;
gt; Here are a couple of links:
gt; www.mvps.org/dmcritchie/excel/mailmerg.htm
gt; www.mvps.org/word/FAQs/MailMerge
gt;
gt; The first is from David McRitchie and the second is by Beth Melton and Dave
gt; Rado.
gt;
gt; Richard R wrote:
gt; gt;
gt; gt; We have an Excel spreadsheet for all 1200 of our employees with name,
gt; gt; department name, SSN and birthdate. I have added another field to sort by
gt; gt; birthmonth only. I can easily sort by the birthmonth, but I need to produce
gt; gt; separate letters to each of the relevant department heads IF they have an
gt; gt; employee due a test each month, listing the employees only for that
gt; gt; department. I would like to automate this procedure with linked files or a
gt; gt; query or some other way rather than do cut amp; paste, if possible, but I am at
gt; gt; a loss how. Can anyone help me out?
gt; gt;
gt; gt; Thanks,
gt; gt; Richard
gt; gt; --
gt; gt; Richard
gt;
gt; --
gt;
gt; Dave Peterson

--

Dave Peterson