Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / February 2008

Tip: Looking for answers? Try searching our database.

How to generate a sequence file in a mail merge

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bill - 14 Feb 2008 18:49 GMT
I want to create a separate sequence file with the sequence number
and other information (name, ssn, etc) that will match the mailmerge
output.  For instance I want to mail merge a letter, some will have
inserts and some wont.  I want to use the sequence number in a mail
merge, have it written to a txt file with sequence number|name|ssn|
insert Yor N
Any suggestions"
Doug Robbins - Word MVP - 14 Feb 2008 19:41 GMT
It sounds like a Catalog (or in Word XP and later, it is called Directory)
type mail merge will accomplish what you are after.

In the main document insert a one row table, into the cells of which you
insert each of the required merge fields, plus the Word Record Number field
and have one extra cell into which you can enter the Y or N (unless that is
already in a field in the data source, in which case insert that merge field
in the cell).  Then, when you execute that merge to a new document, that
document will contain a table with a row of data for each record in the data
source.

There must be nothing else in the mail merge main document for this to work.
Otherwise, that other content will be repeated for each record in the data
source.

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

>I want to create a separate sequence file with the sequence number
> and other information (name, ssn, etc) that will match the mailmerge
[quoted text clipped - 3 lines]
> insert Yor N
> Any suggestions"
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.