| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging a Groupby Access Query for emailing
Hello:
It's possible Word is not the best application for this. I have a groupby Access query that lists employee names (once per report) then lists all vacations reported. (Each vacation is recorded as a seperate record.) Data Sample: First Name Type of Leave Date Katie Vacation 13-Aug-07 Katie Vacation 14-Aug-07 Katie Vacation 15-Aug-07 Katie Vacation 16-Aug-07 Report Sample Katie Vacation 8/13/2007 8/14/2007 8/15/2007 8/16/2007 I'd like to be able to email each person their personal report. However, I'm not sure how to perform this. The Access report is seperated so that each person has their own page. But if I try and merge the data, each record creates a single page. Any assistance would be appreciated. Access version: Access 2003 Word version: Word 2003 |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Access query merging into Word doesn't work | Mailmerge | |||
| Merging data from Access Query | Mailmerge | |||
| Merging Access query into Word and Yes/No results come out T/F | Microsoft Word Help | |||
| Merging an access record or query to a word doc | Mailmerge | |||
| Merging from Access Query with one to many rocords | Microsoft Word Help | |||
Threaded Mode