Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Geoff Geoff is offline
external usenet poster
 
Posts: 35
Default Mail merge using Access

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.
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail merge using Access

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" wrote in message
...
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.



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Geoff Geoff is offline
external usenet poster
 
Posts: 35
Default Mail merge using Access

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" wrote:

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" wrote in message
...
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.




  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail merge using Access

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" wrote in message
news
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" wrote:

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" wrote in message
...
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.






  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Geoff Geoff is offline
external usenet poster
 
Posts: 35
Default Mail merge using Access

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.

"Doug Robbins - Word MVP" wrote:

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" wrote in message
news
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" wrote:

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" wrote in message
...
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.








  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Geoff Geoff is offline
external usenet poster
 
Posts: 35
Default Mail merge using Access

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.

"Doug Robbins - Word MVP" wrote:

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" wrote in message
news
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" wrote:

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" wrote in message
...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Automating Mail merge between Word 2003 and Access 2003 using VB.NET [email protected] Mailmerge 5 October 17th 06 11:25 PM
why does mail merge save as an access file sylmelnik Mailmerge 1 October 10th 06 11:44 AM
Mail Merge Currency from Access Query DiTab1 Mailmerge 1 February 2nd 06 07:16 PM
Cannot edit Access records from Word mail merge toolbar button Snazbaz Mailmerge 2 January 24th 06 08:17 PM
Problem with Word Mail Merge from MS Access Query Deb Mailmerge 2 October 8th 05 05:13 PM


All times are GMT +1. The time now is 03:07 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"