Re: Novice needs help with cosolidating in mailmerge document

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks for your response. I keyed in your example, but unfortunately I
still can't get it to consolidate the employee/sales information onto one
letter. What do you think I could be wrong? I'm using Word 2003, creating a
mail merge directory.

Thanks again.

Jae


"macropod" wrote:

Hi Jae,

See: http://support.microsoft.com/?kbid=211303 for the principles.

However, if your data source is an Excel file, I'd suggest basing your code on the following (which will work the same with other
data sources too) for the second example:

{QUOTE{IF{MERGESEQ}= 1 {SET Place ""}}"{IF{MERGEFIELD City}<> {Place} "{IF{MERGESEQ}= 1 "" {QUOTE 12}}{MERGEFIELD City}{SET Place
{MERGEFIELD City}}<ENTER>
<ENTER>
"}{MERGEFIELD Employee}<TAB>{MERGEFIELD Sales}<ENTER>
"}
<ENTER>
or
{QUOTE{IF{MERGESEQ}= 1 {SET Place ""}}"{IF{MERGEFIELD City}<> {Place} "{IF{MERGESEQ}= 1 "" "
----------------------------Page Break--------------------------------
"}{MERGEFIELD City}{SET Place {MERGEFIELD City}}<ENTER>
<ENTER>
"}{MERGEFIELD Employee}<TAB>{MERGEFIELD Sales}<ENTER>
"}<ENTER>

With the field coded provided in all the examples in the KB article, an extra line is inserted between records for the same location
when using an Excel workbook as the data source.

--
Cheers
macropod
[MVP - Microsoft Word]


"Jae" <Jae@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:D844DC1C-64CF-48F7-ABBE-AF039ACBB241@xxxxxxxxxxxxxxxx
I have a data table which contains multiple records for the same individual.
Is it possible in the mail merge process to send the one individual one
letter containing different types of information? For instance, I'd like to
send a mail merge letter to Mr. X containing purchase information he has made
throughout the year. How do I go about making sure Word does not create
multiple merged letters for Mr. X?

Confusing? Hopefully not.

Thanks in advance for any assistance you may be able to provide.



.

Relevant Pages

  • Re: Novice needs help with cosolidating in mailmerge document
    ... "macropod" wrote: ... However, if your data source is an Excel file, I'd suggest basing your ... "}{MERGEFIELD City}} ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Novice needs help with cosolidating in mailmerge document
    ... However, if your data source is an Excel file, I'd suggest basing your code on the following for the second example: ... "}{MERGEFIELD City}} ... With the field coded provided in all the examples in the KB article, an extra line is inserted between records for the same location when using an Excel workbook as the data source. ... send a mail merge letter to Mr. X containing purchase information he has made ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Rounding using Numeric Switch
    ... "macropod" wrote: ... '00' as the last two digits of your string also supports this conclusion. ... If that works, but you still have problems after changing FILLIN back to MERGEFIELD, what do you get if you just use {MERGEFIELD ... You can get around this, as explained below, but it's probably better to modify your data source so that it can output a field ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Mergefield Two Dates One Field
    ... So, basically, your Excel file is using two different formats. ... > My Excel data source has dates entered in for example 9/15/05 format. ... > My Word main document has a mergefield for the date with a switch to ... I'm using an ODBC connection to the data source. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: adding an attachment
    ... >>> understanding where or how to create the table with the email address ... >> Set the data source to be something which contains one record for each ... >> In the first cell, insert the MERGEFIELD field for the e-mail address. ... >> ctrl-F9 to insert the special field code braces, then type MERGEFIELD ...
    (microsoft.public.word.mailmerge.fields)