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 / February 2004

Tip: Looking for answers? Try searching our database.

if...then comparing field values?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
R - 11 Feb 2004 01:32 GMT
I am trying to make a directory (member business "yellow pages", if you
will) by merging data in an Excel spreadsheet with a template I'm creating
in Word.  I need to create a kind of grouping in my merge document to group
items by service type.  I'll explain what I'm trying to do, and where I'm
stuck.  If there is an easier way around this, I'm interested!

I'm planning the merge document (my directory) to have several listings per
page, and each will consist of an "if...then" statement that asks "If the
groupname is different than the previous groupname, write it, else write the
data for this business" but I'm not sure if I can compare the values of a
field like that.  So it would turn up to look something like this:

GRAPHIC DESIGN

Graphic Design 1
GD1 phone
GD1 email

Graphic Design 2
GD2 phone
GD2 email

HAIR SALONS

Hair Salon 1
HS1 phone
HS1 email

Hair Salon 2
HS2 phone
HS2 email

And the spreadsheet looks like this ("|" represents field breaks or tabs)

businessname | businesstype | phonenumber | email
Graphic Design 1 | GRAPHIC DESIGN | GD1 phone | GD1 email
Graphic Design 2 | GRAPHIC DESIGN | GD2 phone | GD2 email
Hair Salon 1 | HAIR SALON | HS1 phone | HS1 email
Hair Salon 2 | HAIR SALON | HS2 phone | HS2 email

The group type is "businesstype".

Is this a good way to go?  If yes, how to I compare field values in my
if...then in the merge document.  If no, any other suggestions??

Thanks!
Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 11 Feb 2004 03:51 GMT
See the "Multiple items per condition" item under the "Special merges"
section of fellow MVP CIndy Meister's website at
http://homepage.swissonline.ch/cindymeister/MergFram.htm

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested.  Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps

>I am trying to make a directory (member business "yellow pages", if you
> will) by merging data in an Excel spreadsheet with a template I'm creating
[quoted text clipped - 45 lines]
>
> Thanks!
 
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.