Mail Merging

[Jason Trolian]

I export to a .txt file from collection software that I
use. I currently export specific letter information to a
file, add a header row(a,b,c,d,e etc..) and then open the
document associated with the file that I created.

I have the ability to export all letters at one time and
can add a specific identifier to each row of data ("1"
would signify letter 1) Is there a way that I can merge
all that info with out running a specific query in the
mail merge to coinside with the letter requested. For
example:

Data file:
a,b,c,d,e,f,g,h,i,j,k (header row)
1,name,addr1,addr2,city,state,zip
2,name,addr1,addr2,city,state,zip
5,name,addr1,addr2,city,state,zip
6,name,addr1,addr2,city,state,zip

I want to be able to process this file somehow with word,
so as I merge it would know that it should open .doc named
1 and then merge and print that info, then open letter 2,
and then 5, then 6. Is it possible to do this?

Jason

 

[Doug Robbins - Word MVP]

Hi Jason,

It certainly can be done by use of a macro. Not however simply by using
Word's mailmerge facility.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Cindy M -WordMVP-]

Hi Jason,

This could probably be done by using the Field "a" to specify
what file (or bookmarked text) should be imported by an
IncludeText field. Read up on that field in Word's Help to
understand what it's capable of, then come back with any
specific questions.

If you run into problems, please tell us exactly which
version of Word is involved.

I export to a .txt file from collection software that I
use. I currently export specific letter information to a
file, add a header row(a,b,c,d,e etc..) and then open the
document associated with the file that I created.

I have the ability to export all letters at one time and
can add a specific identifier to each row of data ("1"
would signify letter 1) Is there a way that I can merge
all that info with out running a specific query in the
mail merge to coinside with the letter requested. For
example:

Data file:
a,b,c,d,e,f,g,h,i,j,k (header row)
1,name,addr1,addr2,city,state,zip
2,name,addr1,addr2,city,state,zip
5,name,addr1,addr2,city,state,zip
6,name,addr1,addr2,city,state,zip

I want to be able to process this file somehow with word,
so as I merge it would know that it should open .doc named
1 and then merge and print that info, then open letter 2,
and then 5, then 6. Is it possible to do this?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail

 

[Jason Trolian]

That is what that field was intended for, I will read up
and get back to you if I have any furthur questions. Than
k you, Jason