View Single Post
  #10   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 Directory mail merge

Hi Paul,

Yes, the field coding works as is, BUT, it does not include information
AFTER the list of properties (for example in your case in the "Landlord
General Information" section of the letter, where that information would be
provided by a merge field such as, in your example, { MERGEFIELD Desc }.

If you insert such a merge field in that location in the mail merge main
document, it will return information from the next record (the next
landlord) in the data source.

I do not know of any way in which this requirement can be met by the use of
such a construction.

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

"macropod" wrote in message
...
Hi Doug,

I don't understand why the merge type changed but, nothwithstanding that,
the field coding worked in my testing and met the needs of the wopr
poster.

--
Cheers
macropod
[MVP - Microsoft Word]


"Doug Robbins - Word MVP" wrote in message
...
Hi Paul,

For some reason, the Landlord letter.doc opens up as a Letters type mail
merge main document and has to be changed to a Directory type document to
get it to work.

The problem remains however that if you insert a merge field somewhere in
the

Landlord General Information

Each time a tenant contacts the District to close their account, the
account will automatically revert back to the landlord.

Please notify the PUD if the tenant has vacated the addresses and has not
notified the PUD to close account.



that comes after the list of properties, that mergefield will display the
data from the next (landlord) record in the datasource, not data from the
landlord whose list of properties is included in that letter.


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

"macropod" wrote in message
...
Hi Kimberly,

For a working solution that you might be able to modify to suit your
needs, see:
http://www.wopr.com/cgi-bin/w3t/show...?Number=723456
The example there is based on an Excel data source and requires you to
insert a dummy 'last' data record into the data source.

--
Cheers
macropod
[MVP - Microsoft Word]


"Kimberly" wrote in message
...
I read the article from Cornell and the MS article 294686 and understand
them and have been successful implementing them. However, I'm wondering
how to add other merge field(s) at the bottom of the page or after the
multiple records only once (as if they were in the header), but before
the page break. For example an invoice: has header info at the top of
the page, the middle is multiple records (item, qty, price) and at the
bottom a total for the entire invoice. I can get this total field from
the data source there is no need to sum). I can't figure out how to get
the total field at the bottom without it showing multiple times. Any
advise would be greatly appreciated. "Doug Robbins - Word MVP" wrote:

Take a look at http://cornell.veplan.net/article.aspx?&a=3815

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

"Simon J" wrote in message
...
Hi,

I'm trying to prepare a mailmerge that is a letter with part of the
letter listing several rows of data to the recipient. The recipient
information is in the data file 5 times as there are then 5 pieces
of
data that need listing in part of the letter before the letter is
then
finished. There is some other information in the data file that
needs
to go in the letter but that is supplied 5 times and is identical.

Hope that made sense? Can anyone help as i'm getting 5 letters out
each with one piece of the unique data as aposed to a list.

Many thanks
Simon