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 / General MS Word Questions / January 2004

Tip: Looking for answers? Try searching our database.

New User - Simple mail merge question?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
KevinM - 08 Jan 2004 09:44 GMT
I have been successfully using mail merge in a basic way for some time,
however I thought I would try and be a bit smarter and now I am stuck!

I am merging salary letters, however certain benefits to not apply to
all employees. Eg Car Allowance. So in Excel I have a spreadheet
showing
Salary Car Allowance
B Smith 10,000 3,000
S Jones 15,000 0

In Word I have a letter with the following merge fields eg

I am pleased to confirm your salary as <<salary>>
and your car allowance will remain as <<car allowance>>

What I would like to do is only add the second line relating to car
allowance if the allowance shown in Excel is greater than zero.

Can anyone help - I have tried the help pages and looked at the FAQs
but I cannot seem to find a simple answer - Thanks?

------------------------------------------------
Cindy M  -WordMVP- - 10 Jan 2004 19:21 GMT
Replies to the same question in the mailmerge.fields
newsgroup have already been posted.

   Cindy Meister
 
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.