Word mergefield wildcard not correctly matching

Posted by aZn137 on Stack Overflow See other posts from Stack Overflow or by aZn137
Published on 2010-05-06T17:04:27Z Indexed on 2010/05/06 17:08 UTC
Read the original article Hit count: 402

Filed under:

mailmerge

|

msword

|

wildcard

Hello,

Below is my mergefield code:

{ IF { MERGEFIELD Subs_State } = "GA" "blah blah" "{ IF { MERGEFIELD CEOrgStates } = "GA" "blah blah" ""} "}

I'm pulling records from a MS Access db. My goal is to check whether a record has Subs_State field matching "GA", or the CEOrgStates has the word "GA" (some records have stuff like "|FL|CA|GA|CT|KY|" (no quotes)).

When I merged the docs, Word doesnt seem to be able to match with the wildcards: If I use and compare "*GA" (fields ending with GA), it works; however, the double wildcards "*GA*" dont seem to work at all.

Here are the things I’ve tried:

Have data in lowercase, then compare with lowercase
Have data in lowercase, convert to and then compare with uppercase
Do the opposite of the above 2 with uppercase data
Use “*GA*” and “*ga*” (no pipe)
Use different delimiters

Nothing seems to work with the double wildcard matching. What am I doing wrong?

Thanks!

© Stack Overflow or respective owner

Word mergefield wildcard not correctly matching

Posted by aZn137 on Super User See other posts from Super User or by aZn137
Published on 2010-05-06T17:06:20Z Indexed on 2010/05/06 17:08 UTC
Read the original article Hit count: 402

Filed under:

microsoft-word-2007

|

mail-merge

|

wildcards

|

microsoft-word

|

code

Hello,

Below is my mergefield code:

{ IF { MERGEFIELD Subs_State } = "GA" "blah blah" "{ IF { MERGEFIELD CEOrgStates } = "GA" "blah blah" ""} "}

I'm pulling records from a MS Access db. My goal is to check whether a record has Subs_State field matching "GA", or the CEOrgStates has the word "GA" (some records have stuff like "|FL|CA|GA|CT|KY|" (no quotes)).

When I merged the docs, Word doesnt seem to be able to match with the wildcards: If I use and compare "*GA" (fields ending with GA), it works; however, the double wildcards "*GA*" dont seem to work at all.

Here are the things I’ve tried:

Have data in lowercase, then compare with lowercase
Have data in lowercase, convert to and then compare with uppercase
Do the opposite of the above 2 with uppercase data
Use “*GA*” and “*ga*” (no pipe)
Use different delimiters

Nothing seems to work with the double wildcard matching. What am I doing wrong?

Thanks!

© Super User or respective owner

Related posts about mailmerge

Switch Text Paragraphs in OpenOfficeOrg Writer mailmerge

as seen on Super User - Search for 'Super User'
I am using mailmerge to write the same letter with minor differenes to many peolpe. I experienced that switching text paragraphs depending on database values was not easy for me. I ended up putting huge text paragraphs into the database becaus switching did not really work for me. Actually I dont'… >>> More
Remove mailmerge data source via OpenXML

as seen on Stack Overflow - Search for 'Stack Overflow'
I have some code that uses OpenXML to open up a docx file, find all mailmerge fields, and replace them with data (ignoring the datasource that may have been provided). I initially tested this against a document created in Office 2007 and it seemed to work great. We then created one in 2003 based… >>> More
Hide the attachment list on the top of the Hotmail mailmerge

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I am just starting to use Microsoft Word or Publisher to sent a Email Newsletter Mailshot to my clients, The attachment list of the photos i have used at the top of the Email does not look good. Is there any way i can use photo's without showing the attachment list on top, or hide the list… >>> More
Referring to mailmerge fields in an if statement

as seen on Super User - Search for 'Super User'
Context: Windows 7 Microsoft Office Word 2007 I have a mailmerge field named "On_FB". Current code: { IF { On_FB } = "Y" "You're on Facebook." "You're not on Facebok."} The moment I get out of code-editing view, the code goes haywire. When I flip back to code-editing view, I see that the code… >>> More
MS Word: Mailmerge hyperlinks with query get url string with a mergefield.

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm trying to send an email merging one document (docx) with a contacts database (via OleDB). Using MSWord2007, it seems easy (it works for easy things: name, address, ...) but I can't find how fill an query-get url string with a merge field inside an hyperlink. An hyperlink like: Click here… >>> More

Related posts about msword

jquery prevent paste to iframe designmode from msword

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi. I've seen some questions on catching paste event. This looks helpful. But I want to prevent paste from happening when the pasted content is not plaintext, but comes from msword or other wysiwyg editor. Anybody got any experience on that? I suppose I should catch the event and look for some specific… >>> More
Trouble accessing MSWord ActiveDocument

as seen on Stack Overflow - Search for 'Stack Overflow'
When I try to programmatically access a word object model, I get an error no document is active. This appears to be because I am loading the document as not visible using Word automation, and I have to keep it invisible. How would I code the open macro so that it does nothing in this case? "If… >>> More
MSWord automation:Get file contents after it was saved

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an application that uses MSWord automation to edit some documents, after they save and close word I need to grab the modified file and put it back on the repository, there is only one scenario where I can't get it to work and that is when the user makes changes to the file, selects to close… >>> More
How to convert Msword file into a text file and storing it in Mysql - php joomla

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey i want to convert MsWord doc file into text file - any code sample. And then i want to store it to in database MySql - any code. And also how to retrieve it in a same format tht was in Msword file using php joomla >>> More
Can I use a MIME type declaration to get an HTML file to open in MS Word?

as seen on Stack Overflow - Search for 'Stack Overflow'
Bill James wrote: I was able to render an HTML page with the MIME type set to "application/msword", which caused the browser to spawn Word which imported the html just fine, allowing edits and saving just as if I'd output a real Word doc. That sounds great to me, but I haven't been able to get… >>> More