Merge Data from Access for Email Merge in Word
Posted on 2008-10-31
I am putting this data out in a report in Access and am using two sub reports on my report because there are many lines of detail for one invoice. I wish to email out a support sheet with this same information to the customers that are internal to our campus.
Is there a way for me to do a merge and get the sub report info into a Word doc/email?
If not is there some way for me to email each report sheet to the correct email address?
I have only figured out how to email the whole batch to one person.
If neither of those are possible, what would be the best way to create a temporary table that has as a flat file the data I need with like 7 different fields for the description of the charge and 7 fields for the corresponding amounts of the charges.
Hope someone can solve this one.