Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Office System User Office System User is offline
external usenet poster
 
Posts: 1
Default can multiple letter texts be used in mail merge

I am familiar with mail merges utilizing only 1 letter text. however I need
to learn how to code my data to select and print 1 of multiple (8) texts. I
have been told this can be done in Word 2003, however I have been unable to
find any instruction. Can anyone direct me?
  #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 can multiple letter texts be used in mail merge

Can you explain in more detail what you mean by "1 of multiple (8) texts."

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

"Office System User" Office System wrote in
message ...
I am familiar with mail merges utilizing only 1 letter text. however I
need
to learn how to code my data to select and print 1 of multiple (8) texts.
I
have been told this can be done in Word 2003, however I have been unable
to
find any instruction. Can anyone direct me?



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Office System User[_2_] Office System User[_2_] is offline
external usenet poster
 
Posts: 3
Default can multiple letter texts be used in mail merge

I have 8 data files totalling approximately 3,000 records. Each data file
has its own letter text. Because some of these files are smaller than what
we are allowed to mail standard class (third class - requires 200 pieces), I
would like to set up the 8 letter texts (providing a code or indicator),
combine (and code) data files and set up a mail merge of one stream that
would assign the proper letter text to each record and print it accordingly.
The data would be sorted according to postal regulations and I would
therefore end up with a mail stream of 3,000 letters that was comprised of 8
texts in no particular text order (except as dictated by the sorted data
records).

In order to obtain the best postal rates for my clients I would have to
process the mail merge in this fashion. I cannot just print each of the 8
texts separately and try to combine them.

I have been told this is possible, but have not been able to find any
information regarding how to proceed.

Hope this is clearer. I appreciate your interest.

"Doug Robbins - Word MVP" wrote:

Can you explain in more detail what you mean by "1 of multiple (8) texts."

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

"Office System User" Office System wrote in
message ...
I am familiar with mail merges utilizing only 1 letter text. however I
need
to learn how to code my data to select and print 1 of multiple (8) texts.
I
have been told this can be done in Word 2003, however I have been unable
to
find any instruction. Can anyone direct me?




  #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 can multiple letter texts be used in mail merge

If your data sources contained an identifier for the text to be used for
each record, you could make use of an INCLUDETEXT field to compose each
letter with the appropriate text for each record.

The process is similar to that used with an INCLUDEPICTURE field.

See the Mail Merge Graphics item on fellow MVP Graham Mayor's website at:

http://www.gmayor.com/mail_merge_graphics.htm

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

"Office System User" wrote in
message ...
I have 8 data files totalling approximately 3,000 records. Each data file
has its own letter text. Because some of these files are smaller than
what
we are allowed to mail standard class (third class - requires 200 pieces),
I
would like to set up the 8 letter texts (providing a code or indicator),
combine (and code) data files and set up a mail merge of one stream that
would assign the proper letter text to each record and print it
accordingly.
The data would be sorted according to postal regulations and I would
therefore end up with a mail stream of 3,000 letters that was comprised of
8
texts in no particular text order (except as dictated by the sorted data
records).

In order to obtain the best postal rates for my clients I would have to
process the mail merge in this fashion. I cannot just print each of the 8
texts separately and try to combine them.

I have been told this is possible, but have not been able to find any
information regarding how to proceed.

Hope this is clearer. I appreciate your interest.

"Doug Robbins - Word MVP" wrote:

Can you explain in more detail what you mean by "1 of multiple (8)
texts."

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

"Office System User" Office System wrote
in
message ...
I am familiar with mail merges utilizing only 1 letter text. however I
need
to learn how to code my data to select and print 1 of multiple (8)
texts.
I
have been told this can be done in Word 2003, however I have been
unable
to
find any instruction. Can anyone direct me?






  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Office System User[_2_] Office System User[_2_] is offline
external usenet poster
 
Posts: 3
Default can multiple letter texts be used in mail merge

Thank you so much - I just needed a "jumping off" point. I appreciate your
response.

"Doug Robbins - Word MVP" wrote:

If your data sources contained an identifier for the text to be used for
each record, you could make use of an INCLUDETEXT field to compose each
letter with the appropriate text for each record.

The process is similar to that used with an INCLUDEPICTURE field.

See the Mail Merge Graphics item on fellow MVP Graham Mayor's website at:

http://www.gmayor.com/mail_merge_graphics.htm

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

"Office System User" wrote in
message ...
I have 8 data files totalling approximately 3,000 records. Each data file
has its own letter text. Because some of these files are smaller than
what
we are allowed to mail standard class (third class - requires 200 pieces),
I
would like to set up the 8 letter texts (providing a code or indicator),
combine (and code) data files and set up a mail merge of one stream that
would assign the proper letter text to each record and print it
accordingly.
The data would be sorted according to postal regulations and I would
therefore end up with a mail stream of 3,000 letters that was comprised of
8
texts in no particular text order (except as dictated by the sorted data
records).

In order to obtain the best postal rates for my clients I would have to
process the mail merge in this fashion. I cannot just print each of the 8
texts separately and try to combine them.

I have been told this is possible, but have not been able to find any
information regarding how to proceed.

Hope this is clearer. I appreciate your interest.

"Doug Robbins - Word MVP" wrote:

Can you explain in more detail what you mean by "1 of multiple (8)
texts."

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

"Office System User" Office System wrote
in
message ...
I am familiar with mail merges utilizing only 1 letter text. however I
need
to learn how to code my data to select and print 1 of multiple (8)
texts.
I
have been told this can be done in Word 2003, however I have been
unable
to
find any instruction. Can anyone direct me?






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
Create mail merge using multiple contacts in a single letter emcooks Mailmerge 1 May 1st 08 08:00 PM
Multiple excel lines on one letter on mail merge. [email protected] Mailmerge 2 October 4th 07 09:23 AM
Insert source texts into multiple files and update automatically robfer Microsoft Word Help 9 September 12th 07 10:10 PM
Mail Merge multiple records on One Contract/Letter HurlyGurly Mailmerge 1 June 8th 05 01:23 PM
Mail merge option with multiple data source records in one letter. E Weij Mailmerge 1 April 18th 05 02:24 PM


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