NEXTIF

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MilesMonkMingus - 25 Aug 2005 14:05 GMT

Hello all,

I want to create a word document that contains multiple records from my data
source. I believe I need "NextIf." Can anyone lend me a example?

Here's what I want to produce:

Smith & Sons
1234 Main St.
Etc.

Dear Sir / Madam,

Please provide tax forms for the following employees:

John Smith
David Ramon
Caitlin Green
Jessica Jones
.
.
.

Thank-you for your attention to this matter.

Sincerely,

Reply to this Message

Doug Robbins - 25 Aug 2005 18:59 GMT

Word does not really have the ability to perform a "multiple items per
condition (=key field)" mailmerge.

See the "Multiple items per condition" item under the "Special merges"
section of fellow MVP Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/MergFram.htm

Or take a look at the following Knowledge Base Article

How to Work Around Duplicate Names in Mail Merge Data

http://support.microsoft.com/default.aspx?scid=kb;en-us;302665

Signature

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

> Hello all,
>
[quoted text clipped - 22 lines]
>
> Sincerely,

Reply to this Message

MilesMonkMingus - 26 Aug 2005 14:24 GMT

Thanks Doug.

Using the microsoft resource you suggested and
http://support.microsoft.com/?kbid=211303, I'm begining to make some headway
w/ my task.

The one problem I am having is that my original "source code" is
disappearing. How can I retain my original handy work?

> Word does not really have the ability to perform a "multiple items per
> condition (=key field)" mailmerge.
[quoted text clipped - 36 lines]
>>
>> Sincerely,

Reply to this Message

Doug Robbins - 26 Aug 2005 18:33 GMT

Not sure what you mean by "original "source code"" What are you doing when
it disappears?

Signature

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

> Thanks Doug.
>
[quoted text clipped - 45 lines]
>>>
>>> Sincerely,

Reply to this Message

MilesMonkMingus - 26 Aug 2005 19:10 GMT

First, I'm using Word 2002

1) tools; Letters and mailings;Mail Merge wizard, select directory and
"Next: Starting document"

2) Using current document and click on "Next: Select recipients"

3) Via browse, I select an excel spreadsheet and then "Next: Arrange your
directory"

4) using the syntax / source code from
http://support.microsoft.com/default.aspx?scid=kb;en-us;302665, I'm
programming the example provided

5) Click on "Next: Preview your document" and then the finished document
appears. From what I've found, I can't go backwards to make any corrections
/ enhancements

What happened to the coding that specified the {if {mergeseq}= "1" etc?

> Not sure what you mean by "original "source code"" What are you doing
> when it disappears?
[quoted text clipped - 48 lines]
>>>>
>>>> Sincerely,

Reply to this Message

Doug Robbins - 27 Aug 2005 06:31 GMT

Don't fool with the Wizard. From the View menu, select Toolbars and then
check the Mailmerge toolbar item. You can do everything that you need to
with the buttons on the toolbar.

Signature

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

> First, I'm using Word 2002
>
[quoted text clipped - 69 lines]
>>>>>
>>>>> Sincerely,

Reply to this Message