Mail merge using Access

[Geoff]

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.

 

[Doug Robbins - Word MVP]

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

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

 

[Geoff]

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"

 

[Doug Robbins - Word MVP]

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.

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

 

[Geoff]

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.

 

[Geoff]

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.