Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Bill Bill is offline
external usenet poster
 
Posts: 2
Default How to generate a sequence file in a mail merge

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"
  #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 How to generate a sequence file in a mail merge

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.

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

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



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
Sequence number in mail merge output Myrna Mailmerge 3 March 30th 06 03:15 PM
Question: Generate label file from a table... William Chan Mailmerge 1 February 25th 06 07:52 PM
my mail merge tool bar is not active in my mail merge file 547512 Microsoft Word Help 1 February 7th 06 06:50 AM
how do I generate a form that clients can fill in by e-mail ccorvette Microsoft Word Help 2 October 18th 05 06:36 PM
Maintain Sequence fields after a mail merge Simon Mailmerge 1 May 10th 05 09:03 AM


All times are GMT +1. The time now is 03:09 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"