Reply
 
Thread Tools Display Modes
  #1   Report Post  
Pat88 Pat88 is offline
Junior Member
 
Posts: 1
Default Mailmerge with IF

I have an excel data sheet and like to use MERGEFIELD and IF to check if a part of the value is in the excel field.

For example i have the field "participants" with the following values:

Thomas;Philip;Patrick

I like to check with the following command if the Name "Patrick" is in this field:

{ IF { MERGEFIELD participants } = "Patrick" "yes" "no" }

Word shows me the result "no". How can I change my command that it doesn't matter if before or after the name any value is? I tried it with * but it doesn't work.

Thanks for your ideas
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mailmerge Sriniwas Mailmerge 2 October 7th 08 11:29 AM
help with mailmerge please steve goodrich Mailmerge 3 March 6th 06 04:32 PM
Mailmerge skibear Mailmerge 1 March 11th 05 08:24 PM
mailmerge Sean Murdoch Mailmerge 1 February 24th 05 06:04 AM
Mailmerge blanco Mailmerge 1 February 14th 05 08:27 PM


All times are GMT +1. The time now is 01:20 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"