Form letters to new records only

Hi all - in Northwind after entereing an order, you can print an invoice or
all the days invoices, but invoices for previous orders don't print. I have
similar uses that I'm working around, so I'd like to be able to do it right,
and save a step or 2.

When I enter a new contact, I automatically send them an invitation to join
(INV) letter. (The other use is member renewals & first-time payments -
sending thank you's.) I enter a 'Y' in the "Sendletter" field, then print the
letters (in Word) based on a query looking for 'Y" in the sendletter field.
Once the letters and envelopes print, I delete the Y from the sendletter
field.

What I'd like to do is print letters for all new records, and also, since
it's the end of the year, I'd like to be able to report on how many
invitation to join letters I have sent in the past year. (This can wait until
next year if I start keeping track now.)

To summarize:
First time visitors get INV letter
Return visitors who are not members get INV letter
Members renewing get THX letter
New members paying get NEWTHX letter
All three letters have corresponding envelopes.
All letters and envelopes print from Word, based on queries.

And once in a while I will select a group of contacts and send them a
special letter - sometimes I base this on Y in the SpecialLetter field. Can
probably create a query for this but sometimes it's a matter of looking at a
printout and deciding who to nag.

Thanks in advance - there's always great information here!

hi,
if i understand you correctly, it sounds like you just
need to add a little code to your form. either an
if/then/else clause or a select case.
but since you are a little foggy about you lay out and
code, i can only be vague.
but i have done this. i have a routine the has to print 1
of 4 different reports based on input criteria. it has
been printing for four years now and hasn't printed the
wrong report yet.
Regards
Frank
-----Original Message-----
Hi all - in Northwind after entereing an order, you can
print an invoice or
all the days invoices, but invoices for previous orders
don't print. I have
similar uses that I'm working around, so I'd like to be
able to do it right,
and save a step or 2.

When I enter a new contact, I automatically send them an
invitation to join
(INV) letter. (The other use is member renewals & first-
time payments -
sending thank you's.) I enter a 'Y' in the "Sendletter"
field, then print the
letters (in Word) based on a query looking for 'Y" in
the sendletter field.
Once the letters and envelopes print, I delete the Y
from the sendletter
field.

What I'd like to do is print letters for all new
records, and also, since
it's the end of the year, I'd like to be able to report
on how many
invitation to join letters I have sent in the past year.
(This can wait until
next year if I start keeping track now.)

To summarize:
First time visitors get INV letter
Return visitors who are not members get INV letter
Members renewing get THX letter
New members paying get NEWTHX letter
All three letters have corresponding envelopes.
All letters and envelopes print from Word, based
on queries.

And once in a while I will select a group of contacts
and send them a
special letter - sometimes I base this on Y in the
SpecialLetter field. Can
probably create a query for this but sometimes it's a
matter of looking at a
printout and deciding who to nag.

Thanks in advance - there's always great information
here!
.

Hi Frank - yes, I think an if/then/else would work but I have no clue how to
go about entering it and where. What kind of detail do you need? The 'To
Summarize" section below lists the end results; letters I'm using now are
based on queries & are run from Word. Thanks - Lisa

"Frank Stone" wrote:

hi,
if i understand you correctly, it sounds like you just
need to add a little code to your form. either an
if/then/else clause or a select case.
but since you are a little foggy about you lay out and
code, i can only be vague.
but i have done this. i have a routine the has to print 1
of 4 different reports based on input criteria. it has
been printing for four years now and hasn't printed the
wrong report yet.
Regards
Frank

-----Original Message-----
Hi all - in Northwind after entereing an order, you can
print an invoice or
all the days invoices, but invoices for previous orders
don't print. I have
similar uses that I'm working around, so I'd like to be
able to do it right,
and save a step or 2.

When I enter a new contact, I automatically send them an
invitation to join
(INV) letter. (The other use is member renewals & first-
time payments -
sending thank you's.) I enter a 'Y' in the "Sendletter"
field, then print the
letters (in Word) based on a query looking for 'Y" in
the sendletter field.
Once the letters and envelopes print, I delete the Y
from the sendletter
field.

What I'd like to do is print letters for all new
records, and also, since
it's the end of the year, I'd like to be able to report
on how many
invitation to join letters I have sent in the past year.
(This can wait until
next year if I start keeping track now.)

To summarize:
First time visitors get INV letter
Return visitors who are not members get INV letter
Members renewing get THX letter
New members paying get NEWTHX letter
All three letters have corresponding envelopes.
All letters and envelopes print from Word, based
on queries.

And once in a while I will select a group of contacts
and send them a
special letter - sometimes I base this on Y in the
SpecialLetter field. Can
probably create a query for this but sometimes it's a
matter of looking at a
printout and deciding who to nag.

Thanks in advance - there's always great information
here!
.