Hi all
I don't know VB I'm afraid, and I hope this is not asking too much, but here goes nothing:
I get 100's of records added to my Access db every fortnight, which I sort by location and mail-merge in Word for regular mailshots, but only to some of the records. (IMPORTANT: These are offically registered customers, not junk mail)
The db has two tables -CustomersTBC (To Be Contacted) and CustomersC (Contacted). Each has 34 identical columns.
After a mailshot, I mark the column "DateLetterSent" then I have to manually move records that have been written to from CustomersTBC to CustomersC so that the mail-merge doesn't write to same people again next week.
Is there a VB script that will do this moving for me? Or some other way of getting the mail merge to know who has been written to using the DateLetterSent column?
Here's a scruffy psuedocode (obviously not in VB):
check record1
if column "DateLetterSent" is NOT EMPTY
then
copy record1 append to table CustomersC
delete record1 from table CustomersC
loop to next record
end
Or something like that.
Can anyone help?
I don't know VB I'm afraid, and I hope this is not asking too much, but here goes nothing:
I get 100's of records added to my Access db every fortnight, which I sort by location and mail-merge in Word for regular mailshots, but only to some of the records. (IMPORTANT: These are offically registered customers, not junk mail)
The db has two tables -CustomersTBC (To Be Contacted) and CustomersC (Contacted). Each has 34 identical columns.
After a mailshot, I mark the column "DateLetterSent" then I have to manually move records that have been written to from CustomersTBC to CustomersC so that the mail-merge doesn't write to same people again next week.
Is there a VB script that will do this moving for me? Or some other way of getting the mail merge to know who has been written to using the DateLetterSent column?
Here's a scruffy psuedocode (obviously not in VB):
check record1
if column "DateLetterSent" is NOT EMPTY
then
copy record1 append to table CustomersC
delete record1 from table CustomersC
loop to next record
end
Or something like that.
Can anyone help?