Reply
 
Thread Tools Display Modes
  #1   Report Post  
Mohammad Saeb
 
Posts: n/a
Default Merging from Access Query with one to many rocords

Dear All
I have a situation: I need to create a word documentwith access query as
record source. The query contains one to many records (suppliers and product
for example). How can I create such merged document in such a way , each
document contains ONE supplier and its corresponding MANY product.
Any ideas ...thanks
--
Mohammad Saeb
MSCE 2000/2003
Oracle OCP Soon
  #2   Report Post  
Jezebel
 
Posts: n/a
Default

That's what mailmerge is all about. Well covered in Help.




"Mohammad Saeb" wrote in message
...
Dear All
I have a situation: I need to create a word documentwith access query as
record source. The query contains one to many records (suppliers and

product
for example). How can I create such merged document in such a way , each
document contains ONE supplier and its corresponding MANY product.
Any ideas ...thanks
--
Mohammad Saeb
MSCE 2000/2003
Oracle OCP Soon



  #3   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi ?B?TW9oYW1tYWQgU2FlYg==?=,

How can I create such merged document in such a way , each
document contains ONE supplier and its corresponding MANY product.

Word's mail merge doesn't really support this, but there are ways you
can get around it. Take a look at the short discussion in the mail
merge FAQ on my website. You'll find links to sample documents.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Equation Editor & Access Privileges following upgrade to Office 20 Graham Harrison Microsoft Word Help 2 January 14th 05 11:05 AM
Opening Access from Word Slow Learner Microsoft Word Help 10 January 10th 05 11:18 AM
How do I access a created template from letter wizard trying to streamline Microsoft Word Help 6 January 5th 05 02:52 AM
exporting accress reports into word marc Microsoft Word Help 8 December 29th 04 04:40 PM
Word 2003 and Access 2003 Mail Merge question HD87glide Microsoft Word Help 2 December 15th 04 02:29 PM


All times are GMT +1. The time now is 09:19 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"