Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting Date property in a form field mdavison Microsoft Word Help 13 October 6th 06 02:43 PM
Mailmerge - Firstname truncate to Initial?... Mark Mailmerge 9 September 6th 06 04:03 PM
Cross References nested in if field in mailmerge Dave Shaw Mailmerge 4 August 2nd 06 05:06 PM
MailMerge Through VBA Printing Actual Field Names NOT Field Values AndrewC Mailmerge 1 April 23rd 06 08:07 AM
Bullet point format problem Word Heretic Microsoft Word Help 0 November 24th 04 07:48 AM


All times are GMT +1. The time now is 02:41 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"