Access to Word, Creating a list from multiple records

macropod · #4 03-02-2012, 06:38 PM

Hi daymaker,

I take it you're using the tutorials 'Using an Extra Field to Generate the Trailing Text Per Group' example as the basis for your mailmerge. If you select that example's field code and press Shift-F9, or if you just press Alt-F9 to expose all of the document's field coding, you should see:

Code:

{QUOTE{IF{MERGESEQ}= 1 {SET Key ""}}"{IF{MERGEFIELD State}<> {Key} "{IF{MERGESEQ}> 1 "{QUOTE 12}"}Director,
Retail Sales { MERGEFIELD State}
These are the sales figure for {MERGEFIELD State \* Charformat}{SET Key {MERGEFIELD State}}
City Representative Sales
"}{MERGEFIELD City} {MERGEFIELD Representative} {MERGEFIELD Sales}
{IF{MERGEFIELD State_Total}<> "" "
 The {MERGEFIELD State} total is: {MERGEFIELD State_Total}.
If you require more details about the above sales figures, please contact the {MERGEFIELD State} Sales Manager.
 
Sincerely,
 
Customer Service Manager (National)
{DATE \@ "dddd, d MMMM yyyy"}
"}"}

This is rather more extensive that what you appear to be using. The 'State' mergefield is the example's 'key' field. For your purposes, use the 'Customer' field. Similarly, where the tutorial uses 'State_Total', you'd use 'Total_Sales'. I'm sure you can figure the rest out.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating a consecutive list of dates in a MS word document whenever it is accessed	CrabApple	Word	11	05-17-2012 03:21 PM
How can I retreive multiple records using a lookup?	jrpey	Excel	3	11-14-2011 02:10 PM
Combine Records when Mail Merge from Access	Tom Pickles	Misc	2	08-24-2010 06:00 PM
Help with consolidating multiple records into one	wbiggs2	Excel	0	11-30-2006 01:02 PM
Creating a Map From a List of Addresses	aleccamp	Excel	0	11-19-2005 03:04 PM