One query is the info source for a report. Each record is unique (fields in the report change per person).
a possible of 4 fields for each record contain stored e-mail addresses.
I need a macro that sends the unique report to those 4 people in the fields and skips over the fields that are left blank. This must happen for each record in the query.
I can e-mail you the demo database if it helps. Please make it simple to understand. Thank you.
a possible of 4 fields for each record contain stored e-mail addresses.
I need a macro that sends the unique report to those 4 people in the fields and skips over the fields that are left blank. This must happen for each record in the query.
I can e-mail you the demo database if it helps. Please make it simple to understand. Thank you.