Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / November 2004

Tip: Looking for answers? Try searching our database.

how do I use if statements with mail merge from excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Happiestjulia - 18 Nov 2004 16:02 GMT
I have an excel spreadsheet that lists sessions attended by indivuals.  The
column headers give the session name, a 1 indicates they attended and a 0 if
they didn't.

I need to merge this information into a certificate.

At the moment I have:
IF «session_3» == 1 v x

where v is actially a windings tick and x is a windings cross

It doesn't work.  It returns the same whatever «session_3» is

I've also tried
IF «session_3» = 1 v x

This seems like it should be really simple - where am I going wrong?

Julia
Greg - 18 Nov 2004 17:35 GMT
Your field should look something like this"

{IF {Mergerfield Session-3 } = "1""v""x"}

> I have an excel spreadsheet that lists sessions attended by indivuals.  The
> column headers give the session name, a 1 indicates they attended and a 0 if
[quoted text clipped - 15 lines]
>
> Julia
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.