Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge
I have a mail merge document in word 2003 the data sorce is in Access 2003 -
when I merge the data it is placeing the data in the wrong merged fields.. I have 13 fields that represent fees. There is not always a fee for every field - so when the data merges it just puts the fees in the first available field. If there is no amt for a field it doesn't skip the fireld... so I should have amts in fiels 1, 5, 7, 11 & 12 but instead it puts the fees in the first 5 fields.... Help |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge
My guess is that you have each number on its own on a separate line in your
mail merge main document. When one of the numbers is not present in Access, Word will suppress the line containing the blank field. if so, what you can do is: a. open Tools|Customize|Commands and select Category "All Commands" b. find MailMergeHelper in the list of commands on the right and drag it to a toolbar c. close the Tools|Customize dialog box d. Click the MailMergeHelper icon you just created e. Click the Merge... button in section 3 of the dialog f. Select "Print blank lines when data fields are empty, then Close, Close See if blank lines appear where your missing values are. Peter Jamieson "cewert" u22084@uwe wrote in message news:6097cf82f8c15@uwe... I have a mail merge document in word 2003 the data sorce is in Access 2003 - when I merge the data it is placeing the data in the wrong merged fields.. I have 13 fields that represent fees. There is not always a fee for every field - so when the data merges it just puts the fees in the first available field. If there is no amt for a field it doesn't skip the fireld... so I should have amts in fiels 1, 5, 7, 11 & 12 but instead it puts the fees in the first 5 fields.... Help |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge
Thank you.... that fixed my problem.!!!!!!!!!!!!!!
Peter Jamieson wrote: My guess is that you have each number on its own on a separate line in your mail merge main document. When one of the numbers is not present in Access, Word will suppress the line containing the blank field. if so, what you can do is: a. open Tools|Customize|Commands and select Category "All Commands" b. find MailMergeHelper in the list of commands on the right and drag it to a toolbar c. close the Tools|Customize dialog box d. Click the MailMergeHelper icon you just created e. Click the Merge... button in section 3 of the dialog f. Select "Print blank lines when data fields are empty, then Close, Close See if blank lines appear where your missing values are. Peter Jamieson I have a mail merge document in word 2003 the data sorce is in Access 2003 - [quoted text clipped - 6 lines] should have amts in fiels 1, 5, 7, 11 & 12 but instead it puts the fees in the first 5 fields.... Help -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...merge/200605/1 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NO CODE - mail merge to Outlook with attachment with CC | Mailmerge | |||
My Email Mail Merge Does Not Work | Mailmerge | |||
Mail Merge Losing Data | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge |