[Bruce]

Hi,

I am performing a mailmerge from within the Pegasus Opera II System. This
calls on Word for the mailmerge and you finish it off in there. In the
Pegasus software you set up custome fields. These are then available to
select when you set up the mail merge field. I have a field called Cat. It
could have4 predefined catalogues depending on selection.
In the merge document I used the if statement to say that if the field = a
specific name, then make a X in the box. I have 4 of these on the document
each for a different caqtalogue.
When I run the merge, it pops up an error message Invalid Merge Field: This
merge field is used in the main document, but it does not exist in the
datasourse. I have options to remove the field, or replace with a field from
a drop down which only give AutoMergeFields and then OK or cancel.
If I click on the cancel continuously, the merge comes up and the if
statement did what it was suppose to do.
Problem is if I have a 100 documents to send, I have to click 12 times per
document, equating to a 1200 click. Time consuming.
Any ideas please

Regards,

Bruce Kidd

[Peter Jamieson]

Which version of Word is this? And do you know exactly what data source
the Word document is connecting to? (It sounds as if Pegasus may be
generating something then connecting the word document to it).

I am surprised that you are only seeing AutoMergeField names listed but
the merge still functions correctly with other field names.


Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

Bruce wrote:
Hi,

I am performing a mailmerge from within the Pegasus Opera II System. This
calls on Word for the mailmerge and you finish it off in there. In the
Pegasus software you set up custome fields. These are then available to
select when you set up the mail merge field. I have a field called Cat. It
could have4 predefined catalogues depending on selection.
In the merge document I used the if statement to say that if the field = a
specific name, then make a X in the box. I have 4 of these on the document
each for a different caqtalogue.
When I run the merge, it pops up an error message Invalid Merge Field: This
merge field is used in the main document, but it does not exist in the
datasourse. I have options to remove the field, or replace with a field from
a drop down which only give AutoMergeFields and then OK or cancel.
If I click on the cancel continuously, the merge comes up and the if
statement did what it was suppose to do.
Problem is if I have a 100 documents to send, I have to click 12 times per
document, equating to a 1200 click. Time consuming.
Any ideas please

Regards,

Bruce Kidd

[Bruce]

This happens on my system in Word 2007 and at my customer in Word 2003. Not
sure what the data source is?? Pegasus OII is written in Visual Foxpro 9 if
that is what you are looking for.
It should not work, but once I clicked on the cancel button - 3x for each
merge field in the if statements - it is correct. As soon as I take the If
statement out, the document has no problem.

Thanks for responding, I have been struggeling with this for weeks.


Bruce Kidd



"Peter Jamieson" wrote:

Which version of Word is this? And do you know exactly what data source
the Word document is connecting to? (It sounds as if Pegasus may be
generating something then connecting the word document to it).

I am surprised that you are only seeing AutoMergeField names listed but
the merge still functions correctly with other field names.


Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

Bruce wrote:
Hi,

I am performing a mailmerge from within the Pegasus Opera II System. This
calls on Word for the mailmerge and you finish it off in there. In the
Pegasus software you set up custome fields. These are then available to
select when you set up the mail merge field. I have a field called Cat. It
could have4 predefined catalogues depending on selection.
In the merge document I used the if statement to say that if the field = a
specific name, then make a X in the box. I have 4 of these on the document
each for a different caqtalogue.
When I run the merge, it pops up an error message Invalid Merge Field: This
merge field is used in the main document, but it does not exist in the
datasourse. I have options to remove the field, or replace with a field from
a drop down which only give AutoMergeFields and then OK or cancel.
If I click on the cancel continuously, the merge comes up and the if
statement did what it was suppose to do.
Problem is if I have a 100 documents to send, I have to click 12 times per
document, equating to a 1200 click. Time consuming.
Any ideas please

Regards,

Bruce Kidd

[Peter Jamieson]

1. if you can go into Edit Recipient List on the Mailings tab and
a. see what filename is in the Data Source box at the bottom left
b. see what column names are at the top of the list.

2. Can you show us exactly what you are putting in your IF field? (Also,
are all the field brace pairs the sort you enter using ctrl-F9, not the
ones you can type on the keyboard.)

3. Can you verify that these fields appear to work without problems if
you put them directly inside your document rather than nested inside an IF ?

Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

Bruce wrote:
This happens on my system in Word 2007 and at my customer in Word 2003. Not
sure what the data source is?? Pegasus OII is written in Visual Foxpro 9 if
that is what you are looking for.
It should not work, but once I clicked on the cancel button - 3x for each
merge field in the if statements - it is correct. As soon as I take the If
statement out, the document has no problem.

Thanks for responding, I have been struggeling with this for weeks.


Bruce Kidd



"Peter Jamieson" wrote:

Which version of Word is this? And do you know exactly what data source
the Word document is connecting to? (It sounds as if Pegasus may be
generating something then connecting the word document to it).

I am surprised that you are only seeing AutoMergeField names listed but
the merge still functions correctly with other field names.


Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

Bruce wrote:
Hi,

I am performing a mailmerge from within the Pegasus Opera II System. This
calls on Word for the mailmerge and you finish it off in there. In the
Pegasus software you set up custome fields. These are then available to
select when you set up the mail merge field. I have a field called Cat. It
could have4 predefined catalogues depending on selection.
In the merge document I used the if statement to say that if the field = a
specific name, then make a X in the box. I have 4 of these on the document
each for a different caqtalogue.
When I run the merge, it pops up an error message Invalid Merge Field: This
merge field is used in the main document, but it does not exist in the
datasourse. I have options to remove the field, or replace with a field from
a drop down which only give AutoMergeFields and then OK or cancel.
If I click on the cancel continuously, the merge comes up and the if
statement did what it was suppose to do.
Problem is if I have a 100 documents to send, I have to click 12 times per
document, equating to a 1200 click. Time consuming.
Any ideas please

Regards,

Bruce Kidd

[Bruce]

1. a. The file name here is C:\WINDOWS\TEMP\_2QZ0L1D44.DOC
b. The 4 merge fields that I am looking for each has a column in here.

2. This is the if statement. I am using the CTL F9 for the brackets -
{IF{MERGEFIELD Cat1}="Motion Comps Handbook" "X" ""}.

3. The field in the merge Cat1 is the one I am having trouble with. If I
just use this field in the merge and not have it in an if statement it works
fine.

Where you look at the column heading there is no information or lines in,
just the headings.

Thanx










v

"Peter Jamieson" wrote:

1. if you can go into Edit Recipient List on the Mailings tab and
a. see what filename is in the Data Source box at the bottom left
b. see what column names are at the top of the list.

2. Can you show us exactly what you are putting in your IF field? (Also,
are all the field brace pairs the sort you enter using ctrl-F9, not the
ones you can type on the keyboard.)

3. Can you verify that these fields appear to work without problems if
you put them directly inside your document rather than nested inside an IF ?

Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

Bruce wrote:
This happens on my system in Word 2007 and at my customer in Word 2003. Not
sure what the data source is?? Pegasus OII is written in Visual Foxpro 9 if
that is what you are looking for.
It should not work, but once I clicked on the cancel button - 3x for each
merge field in the if statements - it is correct. As soon as I take the If
statement out, the document has no problem.

Thanks for responding, I have been struggeling with this for weeks.


Bruce Kidd



"Peter Jamieson" wrote:

Which version of Word is this? And do you know exactly what data source
the Word document is connecting to? (It sounds as if Pegasus may be
generating something then connecting the word document to it).

I am surprised that you are only seeing AutoMergeField names listed but
the merge still functions correctly with other field names.


Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

Bruce wrote:
Hi,

I am performing a mailmerge from within the Pegasus Opera II System. This
calls on Word for the mailmerge and you finish it off in there. In the
Pegasus software you set up custome fields. These are then available to
select when you set up the mail merge field. I have a field called Cat. It
could have4 predefined catalogues depending on selection.
In the merge document I used the if statement to say that if the field = a
specific name, then make a X in the box. I have 4 of these on the document
each for a different caqtalogue.
When I run the merge, it pops up an error message Invalid Merge Field: This
merge field is used in the main document, but it does not exist in the
datasourse. I have options to remove the field, or replace with a field from
a drop down which only give AutoMergeFields and then OK or cancel.
If I click on the cancel continuously, the merge comes up and the if
statement did what it was suppose to do.
Problem is if I have a 100 documents to send, I have to click 12 times per
document, equating to a 1200 click. Time consuming.
Any ideas please

Regards,

Bruce Kidd

[macropod[_2_]]

Hi Bruce,

At the very least, you need a space after the '='. Other than that, the field code looks OK.

In your first post, you said "If I click on the cancel continuously, the merge comes up and the if statement did what it was suppose
to do". As posted, though, the IF test couldn't work correctly. The only reason I can see that you would get an 'Invalid Merge
Field' message is that the mergefield was mis-named (eg Cat1 instead of Cat_1).

--
Cheers
macropod
[Microsoft MVP - Word]


"Bruce" wrote in message ...
1. a. The file name here is C:\WINDOWS\TEMP\_2QZ0L1D44.DOC
b. The 4 merge fields that I am looking for each has a column in here.

2. This is the if statement. I am using the CTL F9 for the brackets -
{IF{MERGEFIELD Cat1}="Motion Comps Handbook" "X" ""}.

3. The field in the merge Cat1 is the one I am having trouble with. If I
just use this field in the merge and not have it in an if statement it works
fine.

Where you look at the column heading there is no information or lines in,
just the headings.

Thanx










v

"Peter Jamieson" wrote:

1. if you can go into Edit Recipient List on the Mailings tab and
a. see what filename is in the Data Source box at the bottom left
b. see what column names are at the top of the list.

2. Can you show us exactly what you are putting in your IF field? (Also,
are all the field brace pairs the sort you enter using ctrl-F9, not the
ones you can type on the keyboard.)

3. Can you verify that these fields appear to work without problems if
you put them directly inside your document rather than nested inside an IF ?

Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

Bruce wrote:
This happens on my system in Word 2007 and at my customer in Word 2003. Not
sure what the data source is?? Pegasus OII is written in Visual Foxpro 9 if
that is what you are looking for.
It should not work, but once I clicked on the cancel button - 3x for each
merge field in the if statements - it is correct. As soon as I take the If
statement out, the document has no problem.

Thanks for responding, I have been struggeling with this for weeks.


Bruce Kidd



"Peter Jamieson" wrote:

Which version of Word is this? And do you know exactly what data source
the Word document is connecting to? (It sounds as if Pegasus may be
generating something then connecting the word document to it).

I am surprised that you are only seeing AutoMergeField names listed but
the merge still functions correctly with other field names.


Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

Bruce wrote:
Hi,

I am performing a mailmerge from within the Pegasus Opera II System. This
calls on Word for the mailmerge and you finish it off in there. In the
Pegasus software you set up custome fields. These are then available to
select when you set up the mail merge field. I have a field called Cat. It
could have4 predefined catalogues depending on selection.
In the merge document I used the if statement to say that if the field = a
specific name, then make a X in the box. I have 4 of these on the document
each for a different caqtalogue.
When I run the merge, it pops up an error message Invalid Merge Field: This
merge field is used in the main document, but it does not exist in the
datasourse. I have options to remove the field, or replace with a field from
a drop down which only give AutoMergeFields and then OK or cancel.
If I click on the cancel continuously, the merge comes up and the if
statement did what it was suppose to do.
Problem is if I have a 100 documents to send, I have to click 12 times per
document, equating to a 1200 click. Time consuming.
Any ideas please

Regards,

Bruce Kidd