recipient list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 11 Oct 2007 12:04 GMT

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 to this Message

Peter Jamieson - 12 Oct 2007 17:29 GMT

Which version of Access/Excel/Word?

How are you actually doing the import when you do it directly into Word?

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

>I am importing a recipient list from access and only about half of the
>people
[quoted text clipped - 5 lines]
>
> Any ideas?

Reply to this Message

Dave - 13 Oct 2007 23:39 GMT

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

> Which version of Access/Excel/Word?
>
[quoted text clipped - 9 lines]
> >
> > Any ideas?

Reply to this Message

Peter Jamieson - 14 Oct 2007 17:04 GMT

> 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.

Signature

Peter Jamieson
http://tips.pjmsn.me.uk

> Office 2007
>
[quoted text clipped - 26 lines]
>> >
>> > Any ideas?

Reply to this Message