A
Amy E. Baggott
When we send out exhibitor mailing lists to our contractors, we want to
include a seed company that has a unique code for each list so we can keep
track of what list went to whom if we get unauthorized mailings. I already
have a set of queries to generate the mailing list and update a table with
the date, the contractor it went to, and the number of records and to put the
list as an excel attachment into an e-mail. How do I add this seed record,
which lives in a different table, to the list at runtime? Adding the
tracking code to the mailing list record table is easy, as is updating the
tracking code in the seed company record. I just need to know what the best
way to add the record to the list is. Is there a method similar to
SendObject that works with recordsets in VBA code. I think I could make this
work easily if there is, but I don't know how to find it.
include a seed company that has a unique code for each list so we can keep
track of what list went to whom if we get unauthorized mailings. I already
have a set of queries to generate the mailing list and update a table with
the date, the contractor it went to, and the number of records and to put the
list as an excel attachment into an e-mail. How do I add this seed record,
which lives in a different table, to the list at runtime? Adding the
tracking code to the mailing list record table is easy, as is updating the
tracking code in the seed company record. I just need to know what the best
way to add the record to the list is. Is there a method similar to
SendObject that works with recordsets in VBA code. I think I could make this
work easily if there is, but I don't know how to find it.