NEED HELP, Coding Access to Word Mail Merge :-) 
Author Message
 NEED HELP, Coding Access to Word Mail Merge :-)

I also posted this in Access and regular VB. I hope someone can help me
with this.  :-)

Im fairly new to VB and Access, but I do have other programming
experience. Ive been trying to implement a reporting strategy from Access
to Word using the Word Mail Merge functionality. As a reference, Im using
the article called, Strengthen the Access-Word Connection by Mark
Johnson in the June 1995 edition of the Access/Visual Basic Advisor
magazine. I set up a simple test scenario to make the connections, and
everything seemed to work beautifully. Each record of the query created a
separate Word form letter, just as it was planned. (Hooray!)

But then,........ I tried to use my real world application and Ive run
into a few snags. Im not sure if I need to fix this snag using code, or a
different query, or maybe even setting up the Word template differently.
The situation goes like this:

I have an Order #535 where the Customer places orders for several
different items (the quantity of items will vary from order to order). Id
like to print this order form in Word (because its easier for the user to
make changes to the form). The problem is that my query results in a
multi-record answer where Order #535 is repeated for each detailed item
order. (Ive basically related the items ordered with the Order #535.)

When I mail merge, I get one Order document for each and every item
detail. What Id like to see as a result, is one Order document listing
all item details. Can someone help me with this? Is my query incorrect, do
I need special code, is my Word template set up incorrectly. HELP?!

Thanks in Advance!!!!!!

Deb :-)

Tue, 09 Dec 1997 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. newbie needs code help for word mail merge

2. Word/Access mail merge automation help needed

3. Transfering Text from Access to Word for Mail Merge through Code

4. mail merge coding with MS access in word

5. Transfer Text from Access to Word for Mail Merge by Code

6. Word Mail Merge Err - Word could not merge...

7. (Access/Word Merge) Automating Closing of Main Doc Containing Merge Codes

8. Help with Mail Merge from Access to Word

9. Help needed automating mail merge in access and MSword

10. VB Code for Word Mail Merge Wizerd

11. Getting Error Code:5922 when running word mail merge on Office XP

12. Formatting Merge Fields in Word Mail Merge


Powered by phpBB® Forum Software