If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Merging Query results into Word document
I have Word forms to send tailor for each client I mail to. The forms are
requesting specific information regarding employees. To that end, I am providing employee specific information (i.e., name, SSN, earnings info, etc.). I have that information built into an Access table and can successfully develop the query but have not been able to figure out how to merge queried employee-specific information into the correct client form. The provided information is scattered throughout the Word document so it does not lend itself to inserting a table result. I've tried inserting the specific field into the Word document but all I get as results is a table replacing all other data on the page. I was certain that I used to do this type of thing at a different job but that was long ago and I'm totally lost after days of trying. |
#2
|
|||
|
|||
Merging Query results into Word document
Used to Know Access wrote:
I have Word forms to send tailor for each client I mail to. The forms are requesting specific information regarding employees. To that end, I am providing employee specific information (i.e., name, SSN, earnings info, etc.). I have that information built into an Access table and can successfully develop the query but have not been able to figure out how to merge queried employee-specific information into the correct client form. The provided information is scattered throughout the Word document so it does not lend itself to inserting a table result. I've tried inserting the specific field into the Word document but all I get as results is a table replacing all other data on the page. I was certain that I used to do this type of thing at a different job but that was long ago and I'm totally lost after days of trying. Didn't you already ask this question? You have two options: 1. Mail Merge 2. using Bookmarks and inserting data into them. Mail Merge is easier, but Bookmarks allow you more control. Try Albert's Super Easy Word Merge http://www.members.shaw.ca/AlbertKal.../msaccess.html -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201005/1 |
Thread Tools | |
Display Modes | |
|
|