R
Ray S.
I've got a database table that contains names and emails of company cellphones.
On a query I see that almost 200 employees have more than one cellphone. I
can do a report and group it on each employee so it shows me what numbers are
assigned to each. Some have two and up to six. I want to email each employee
his relevant portion of the query, showing just his name and the phone
numbers my records show he has. The database contains the employee's email
address. I would like to have Outlook send each his information (of course,
each is contained in more than one record). In the Access report I can show
each employee's information on one page. I tried publishing it with MS Word
on Office Links, then using the Mail Merge under Tools. It doesn't work
because I can't figure out how to have the data from the separate records
grouped. I was hoping I could figure out a macro or some way to then do a
mass mailing of the documents. I could call the over 200 employees, but I'm
trying to figure out a procedure whereby anyone could easily do this again
when they have to.
I need some help.
On a query I see that almost 200 employees have more than one cellphone. I
can do a report and group it on each employee so it shows me what numbers are
assigned to each. Some have two and up to six. I want to email each employee
his relevant portion of the query, showing just his name and the phone
numbers my records show he has. The database contains the employee's email
address. I would like to have Outlook send each his information (of course,
each is contained in more than one record). In the Access report I can show
each employee's information on one page. I tried publishing it with MS Word
on Office Links, then using the Mail Merge under Tools. It doesn't work
because I can't figure out how to have the data from the separate records
grouped. I was hoping I could figure out a macro or some way to then do a
mass mailing of the documents. I could call the over 200 employees, but I'm
trying to figure out a procedure whereby anyone could easily do this again
when they have to.
I need some help.