Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
![]()
The list in access is created by a birthdate range or selecting a
tick box So the list is the result of an Access query? Or something else? At the moment it's not at all obvious to me what the problem might be (and I don't have Access 2007 here so cannot check that version specifically), but... a. are you seeing the partial list in the Mail Merge Recipients dialog? If so, what you may have done is create a MailMerge main document that has a { NEXT } field (Next record field in it that should not be there. A merge would skip every other record. However, the fact that only "ticked records" are being selected suggests that probably isn't what's happening here. b. if you change the connection method to DDE, do you still see the same results - to do that, check Office button-Word options-Advanced-General-Confirm file format conversion on open, go through the connection process again, and select the DDE method in the additional dialog box that pops up. If you just see "OLE DB databases", check the box in that new dialog box and DDE should be listed. -- Peter Jamieson http://tips.pjmsn.me.uk "Dave" wrote in message ... Office 2007 I am importing by mail merge selecting the list that I require from access (or excel). The list in access is created by a birthdate range or selecting a tick box - only the tick box once are being imported but it does not appear that there are any filters that have been put on to alter the list in word. Thanks Dave "Peter Jamieson" wrote: Which version of Access/Excel/Word? How are you actually doing the import when you do it directly into Word? -- Peter Jamieson http://tips.pjmsn.me.uk "Dave" wrote in message ... I am importing a recipient list from access and only about half of the people in the access list appear in the recipient list when imported into word. If I copy the access list into excel and then import it into word from excel I get the full list appearing but I can not get them all direct from access. Any ideas? |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Edit Recipient List | Mailmerge | |||
How do I print a recipient list from a mail merge list in Word? | Mailmerge | |||
Remove recipient list | Microsoft Word Help | |||
Edit recipient list | Mailmerge | |||
Recipient List | Mailmerge |