View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Bullet Point in a Mailmerge field

Instead of using a bullet (as in numbering and bullets) use the symbol from
the InsertSymbol dialog

{ IF {MERGEFIELD Num_Purchased }0 "[Symbol here][tab]{MERGEFIELD
Num_Purchased}" ""}

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"JerD@FSC" wrote in message
...
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