Creating a list of mailouts

[Andy]

Hello.

I have two tables called Mailouts and Customers. I have a lookup table
between them containing foreign keys from both tables. What I'd like to do is
do a search for customers by certain criteria, then create a new mailing
where it would create a new Mailout_ID, and then it would create new rows,
each with that Mailout_ID plus all the Customer_IDs that were returned in the
search.

Would this require a macro? I'm not really sure.

Thanks
Andrew