Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Task Database Nightmare Task Database Nightmare is offline
external usenet poster
 
Posts: 2
Default Merging in Word from Excel

I have 1600 lines of data but each line is not unique to itself - it is a
list of agents with policy numbers. There are several hundred agents - but
not 1600 as many of the agents have multiple policy numbers assigned to them.
I am trying to create a letter addressed to the agent that list their
specific policy numbers. How do I do this without having the agent name
repeat itself for each policy number?
  #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 Merging in Word from Excel

See fellow MVP Macropod's "Word 97-2007 Catalogue/Directory Mailmerge
Tutorial" at:
http://www.wopr.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included
with it as you must get the mail merge main document set up exactly as
required.


--
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, originally posted via msnews.microsoft.com
"Task Database Nightmare"
wrote in message ...
I have 1600 lines of data but each line is not unique to itself - it is a
list of agents with policy numbers. There are several hundred agents -
but
not 1600 as many of the agents have multiple policy numbers assigned to
them.
I am trying to create a letter addressed to the agent that list their
specific policy numbers. How do I do this without having the agent name
repeat itself for each policy number?


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Task Database Nightmare Task Database Nightmare is offline
external usenet poster
 
Posts: 2
Default Merging in Word from Excel

Any chance of getting the tutorial in another format - maybe via email? I
can't open the attachement due to restrictions set-up by our IS department.

"Doug Robbins - Word MVP" wrote:

See fellow MVP Macropod's "Word 97-2007 Catalogue/Directory Mailmerge
Tutorial" at:
http://www.wopr.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included
with it as you must get the mail merge main document set up exactly as
required.


--
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, originally posted via msnews.microsoft.com
"Task Database Nightmare"
wrote in message ...
I have 1600 lines of data but each line is not unique to itself - it is a
list of agents with policy numbers. There are several hundred agents -
but
not 1600 as many of the agents have multiple policy numbers assigned to
them.
I am trying to create a letter addressed to the agent that list their
specific policy numbers. How do I do this without having the agent name
repeat itself for each policy number?



  #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 Merging in Word from Excel

Send your email address to me and I will send it to you. You will need to
remove the uppercase letters from the posting address that I use.

--
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, originally posted via msnews.microsoft.com
"Task Database Nightmare"
wrote in message ...
Any chance of getting the tutorial in another format - maybe via email? I
can't open the attachement due to restrictions set-up by our IS
department.

"Doug Robbins - Word MVP" wrote:

See fellow MVP Macropod's "Word 97-2007 Catalogue/Directory Mailmerge
Tutorial" at:
http://www.wopr.com/index.php?showtopic=731107
or
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included
with it as you must get the mail merge main document set up exactly as
required.


--
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, originally posted via msnews.microsoft.com
"Task Database Nightmare"

wrote in message
...
I have 1600 lines of data but each line is not unique to itself - it is
a
list of agents with policy numbers. There are several hundred agents -
but
not 1600 as many of the agents have multiple policy numbers assigned to
them.
I am trying to create a letter addressed to the agent that list their
specific policy numbers. How do I do this without having the agent name
repeat itself for each policy number?




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
Merging from Excel to Word Katie H. - Ultimate Health Mailmerge 1 January 12th 08 09:15 AM
Merging Excel to Word Geri Mailmerge 4 October 25th 07 10:58 PM
Merging from Excel to Word. Tree Branch[_2_] Microsoft Word Help 2 May 22nd 07 05:32 AM
Merging Excel to Word Ness Mailmerge 1 April 27th 07 07:30 AM
Merging from Excel into word Wim Willemse Mailmerge 3 March 31st 05 12:17 PM


All times are GMT +1. The time now is 07:08 PM.

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"