Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
benrkay benrkay is offline
external usenet poster
 
Posts: 1
Default add a random paragraph of text to each of my letters

Hi, im looking to add a random paragraph of text to each of my letters
in a mail merge. i.e. the first paragraph is one of about 15 different
sets of text that Is chosen at random. Is this possible. thanx
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default add a random paragraph of text to each of my letters

It would be at best pseudo-random, but roughly speaking
a. let's suppose you had a document c:\mydoc.doc that contained 14
paragraphs, bookmarked "b0", "b2", "b3",..,"b14"
b. you use something like

{ IF TRUE "{ INCLUDETEXT "c:\\mydoc.doc" "b{ =mod(x, 15) })" }

to include one of those 15 paragraphs (where each pair of {} is a pair
of the special field code braces that ou can isert using ctrl-F9)

Then it's a question of what you can use to (pseudo-)randomise "x". I
suppose I would look for some combination of something in your data
(e.g. a record ID or some other arbitrary datum that you could convert
into a number, either in your data source or using field codes) and
something like a time field such as { TIME \@"ss" } to provide something
that would vary from run to run. Up to you.

With some types of data source, you might be able to return a random
number or pseudo-random number as a field in a query or view, and use
that to make a selection along the general lines I have suggested.

Peter Jamieson

http://tips.pjmsn.me.uk

On 22/03/2010 16:30, benrkay wrote:
Hi, im looking to add a random paragraph of text to each of my letters
in a mail merge. i.e. the first paragraph is one of about 15 different
sets of text that Is chosen at random. Is this possible. thanx

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Dan Dan is offline
external usenet poster
 
Posts: 135
Default add a random paragraph of text to each of my letters

Are you using Excel for the source list? If so, it is a simple matter to
create a table, where the first column is 1..15, and the second column the
paragraphs of text. Then, in the list, use the
=VLOOKUP(INT(RAND()*15)+1,ListName,2) formula to pull the paragraph into the
list. Mail Merge as usual.

"benrkay" wrote:

Hi, im looking to add a random paragraph of text to each of my letters
in a mail merge. i.e. the first paragraph is one of about 15 different
sets of text that Is chosen at random. Is this possible. thanx
.

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
a paragraph symbol shows up in typing letters? I need it off how . LLFord Microsoft Word Help 5 June 18th 09 04:41 AM
In WORD the water mark prints random letters on each page Robert Winder Microsoft Word Help 1 July 31st 07 02:23 PM
how do i set capital letters when typing numbered paragraph? vicki1978 Microsoft Word Help 3 May 16th 06 04:51 PM
Text watermark for random sections AA Microsoft Word Help 1 March 24th 05 07:47 PM
Random Filler Text Filler Text? Microsoft Word Help 3 February 24th 05 11:55 AM


All times are GMT +1. The time now is 12:55 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"