Mail merge using Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Geoff - 01 Nov 2006 18:46 GMT

When using the Access database for recipients the initial columns are OK but
in other columns information jumps from a following column. This is random
and does not apply to every record.

Reply to this Message

Doug Robbins - Word MVP - 01 Nov 2006 19:25 GMT

You better explain in detail what you have done, because if you do it
correctly, it doesn't happen that way.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> When using the Access database for recipients the initial columns are OK
> but
> in other columns information jumps from a following column. This is random
> and does not apply to every record.

Reply to this Message

Geoff - 01 Nov 2006 20:35 GMT

In 2 adjacent columns the headings are Country and Sector and the entries are
OK in the Access database. However, when mail merge some of the entries for
Sector appear in the Country column when in step 3 of 6 "Select recipients"

> You better explain in detail what you have done, because if you do it
> correctly, it doesn't happen that way.
[quoted text clipped - 3 lines]
> > in other columns information jumps from a following column. This is random
> > and does not apply to every record.

Reply to this Message

Doug Robbins - Word MVP - 02 Nov 2006 05:43 GMT

What happens when you execute the merge?

I would be looking for some problem with the data in the data source rather
than with the mail merge.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> In 2 adjacent columns the headings are Country and Sector and the entries
> are
[quoted text clipped - 12 lines]
>> > random
>> > and does not apply to every record.

Reply to this Message

Geoff - 02 Nov 2006 09:08 GMT

I have got some entries which are for example ,23, Maybe these are the
problem. The information in the Access Database is also uplifted to a website
hence the unusual entries.

> What happens when you execute the merge?
>
[quoted text clipped - 17 lines]
> >> > random
> >> > and does not apply to every record.

Reply to this Message

Geoff - 06 Nov 2006 14:19 GMT

I think I've identified the problem. When the column entry in the database is
a hyperlink and that cell is blank it causes other columns to shift.

> What happens when you execute the merge?
>
[quoted text clipped - 17 lines]
> >> > random
> >> > and does not apply to every record.

Reply to this Message