R
Ray S.
I'm trying to merge data from an Access query. The problem I have is that my
query has to display by grouping. I have a table query that shows over 200
company assigned cell phones where an employee is shown to have more than
one. My query groups the information in a report that shows the employees
FirstName, LastName, and the numbers each has under PhoneNum. I can trim
their first names and middle initials and concatenate with the @company.com
domain for their email addresses. I want to send out an individualized email
to each asking them to confirm service: Dear <<FirstName>>,
You have the following phone numbers assigned to you:
<<PhoneNum>> this is where they are grouped from two to seven per employee
then I want to have each sent to their individual email address.
The mail merge wizard doesn't allow for grouping as an option, so it would
only give me one line per record, duplicating each name with each phone
assigned as a separate record.
I'm looking to see if there's a way to control this programmatically.
Can anyone help me?
query has to display by grouping. I have a table query that shows over 200
company assigned cell phones where an employee is shown to have more than
one. My query groups the information in a report that shows the employees
FirstName, LastName, and the numbers each has under PhoneNum. I can trim
their first names and middle initials and concatenate with the @company.com
domain for their email addresses. I want to send out an individualized email
to each asking them to confirm service: Dear <<FirstName>>,
You have the following phone numbers assigned to you:
<<PhoneNum>> this is where they are grouped from two to seven per employee
then I want to have each sent to their individual email address.
The mail merge wizard doesn't allow for grouping as an option, so it would
only give me one line per record, duplicating each name with each phone
assigned as a separate record.
I'm looking to see if there's a way to control this programmatically.
Can anyone help me?