By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,346 Members | 2,331 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,346 IT Pros & Developers. It's quick & easy.

Mail Merge from Access to Word

P: 6
I have an access database which takes information from a user and then uses the mail merge functionality to merge the data into a word document. I have a lot of subforms in the access database which allows the user to keep entering data if they need to. By this I mean each subform is like a dynamic table (continous form view) and the user can keep entering data if needed. For example, one of the subforms asks the user to enter the names of people involved on a project and the user can enter as many names as they need to in the subform, each on a new row of the table but all are bound to one field. All data entered in all subforms is linked by an id number. I want to merge all the data from the access subforms associated with a specific id number. The problem is when I am trying to merge the data from any of the subforms and the users has entered more than one item in the subform (for example, mulitple names) word only takes the first name and prints it in the word document. It does not show all the records from the subform associated with the specific id number. I need to find a way around this so all the data on the subform associated with a specific id number is merged. For example, if 5 names are entered in the access subform as part of the same id number I want all five to merge into word and not just the first one. I cannot use the insert database function in word because I need to keep a certain format for the word document which cannot be changed. Is there anyway this can be done? thanks.
Jul 25 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
I have an access database which takes information from a user and then uses the mail merge functionality to merge the data into a word document. I have a lot of subforms in the access database which allows the user to keep entering data if they need to. By this I mean each subform is like a dynamic table (continous form view) and the user can keep entering data if needed. For example, one of the subforms asks the user to enter the names of people involved on a project and the user can enter as many names as they need to in the subform, each on a new row of the table but all are bound to one field. All data entered in all subforms is linked by an id number. I want to merge all the data from the access subforms associated with a specific id number. The problem is when I am trying to merge the data from any of the subforms and the users has entered more than one item in the subform (for example, mulitple names) word only takes the first name and prints it in the word document. It does not show all the records from the subform associated with the specific id number. I need to find a way around this so all the data on the subform associated with a specific id number is merged. For example, if 5 names are entered in the access subform as part of the same id number I want all five to merge into word and not just the first one. I cannot use the insert database function in word because I need to keep a certain format for the word document which cannot be changed. Is there anyway this can be done? thanks.
Maybe you create your document in Word based arround your ID and not the information on the subforms...

But in this case will not have the same vision in Word such as in Access!


There is a way: and it's to show all the informations on one line, because each line in word is one document...

So If you enumerate with virgulas the values of your subforms, tey becom a field in a record....


Have a nice day!

:)
Sep 9 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.