View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
JerD@FSC JerD@FSC is offline
external usenet poster
 
Posts: 1
Default Bullet Point in a Mailmerge field

Hello all,

I am merging from an Excel worksheet into a Word doc. I am using
if...then...else to only give me data that exists. If that data exists, I
would like it to begin with a bullett. If I put the bullet in the word doc,
then the bullet is always there....even if there is no merged data. What I
would like to see is a bullet only if there is merge data but I don't know
how to put that into my merge statement. I'm using:

{ IF {MERGEFIELD Num_Purchased }0 "{MERGEFIELD Num_Purchased}" ""} {IF
{MERGEFIELD Num_Purchased} ="YES" "text about what was purchased" ""}

the reads something like:
5 3800 scanners purchased

I would like it to read:
(BULLET) 5 3800 scanners purchased

Any help would be WONDERFUL!! Thanks so much and I hope everyone had great
holidays!!

-Jer