Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Referencing a User Form using an If statement field code
Word 2007
I am using a vba user form to fill in vendor and purchaser names. There could be one vendor or two vendors. All through the template there are spots where you have to refer to either Vendor or Vendors. Rather than using vba coding and bookmarks, I'd like to use something like the following in the template but it is not working. Is there a way to reference a user form field? My example: Vendor{if PrecForm1.Vendor2.text "" "s" ""} So what I'm trying to say is if the vendor2 field is filled in on the form, then use Vendors instead of Vendor. Brenda |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Referencing a User Form using an If statement field code
The way I would do this would be to have the term Vendor or Vendors appear
as a result of the value assigned to a document variable and use a { DOCVARIABLE } in the document where ever the term is to appear. -- 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, originally posted via msnews.microsoft.com "Brenda A. Reid" wrote in message ... Word 2007 I am using a vba user form to fill in vendor and purchaser names. There could be one vendor or two vendors. All through the template there are spots where you have to refer to either Vendor or Vendors. Rather than using vba coding and bookmarks, I'd like to use something like the following in the template but it is not working. Is there a way to reference a user form field? My example: Vendor{if PrecForm1.Vendor2.text "" "s" ""} So what I'm trying to say is if the vendor2 field is filled in on the form, then use Vendors instead of Vendor. Brenda |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Referencing a User Form using an If statement field code
Please do not post the same question separately to multiple newsgroups.
-- 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, originally posted via msnews.microsoft.com "Brenda A. Reid" wrote in message ... Word 2007 I am using a vba user form to fill in vendor and purchaser names. There could be one vendor or two vendors. All through the template there are spots where you have to refer to either Vendor or Vendors. Rather than using vba coding and bookmarks, I'd like to use something like the following in the template but it is not working. Is there a way to reference a user form field? My example: Vendor{if PrecForm1.Vendor2.text "" "s" ""} So what I'm trying to say is if the vendor2 field is filled in on the form, then use Vendors instead of Vendor. Brenda |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table field code referencing table cell with text | Tables | |||
How do you add an IF statement to a user form field? | Microsoft Word Help | |||
Form field in conditional statement | Microsoft Word Help | |||
Field Code: User entered data updates in header/footer | Microsoft Word Help | |||
User-defined table format using Database field code | Mailmerge |