#1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
jamiks jamiks is offline
external usenet poster
 
Posts: 1
Default Macro?

We made a mail merge packing slip. We would like the item column to remain
blank if threre is no qty for it in the next column over.

any suggestions?
--
jami
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Macro?

You would use a conditional field. Assuming your field names are called Item
and Quantity then in the Item column enter
{IF {Mergefield Quantity} "" "{IF {Mergefield Quantity} 0 "{Mergefield
Item}"}"} this will only enter the item field if the quantity field has
content greater than 0. All pairs of field brackets are entered with CTRL+F9


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


jamiks wrote:
We made a mail merge packing slip. We would like the item column to
remain blank if threre is no qty for it in the next column over.

any suggestions?



Reply
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
Spell Check a protected Form with a Macro & already have forms picture macro [email protected] Microsoft Word Help 2 October 25th 07 04:11 PM
Macro cannot be found or has been disabled because of Macro settin JD2 Microsoft Word Help 5 March 15th 07 05:00 AM
Pause an executing Word Macro to enter info and then Macro continu strongwell Microsoft Word Help 1 August 11th 06 06:57 PM
macro runs from keyboard, but not from macro button-why? BobW Microsoft Word Help 7 May 10th 06 11:33 PM
2000 to 2002 macro and "Could not open macro storage" Art Farrell Mailmerge 1 December 6th 04 01:40 PM


All times are GMT +1. The time now is 05:38 AM.

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"