Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Grady_In_Houston Grady_In_Houston is offline
external usenet poster
 
Posts: 1
Default Dropping The Suffix Field in a Merge

I have a simple 100 line address database in Excel 2007 and want to merge
labels in Word 2007.

Problem #1: The fields are mapped and show in the preview mode. But if
there is no data in the first name field, the suffix field doesn't merge. So
a record with: The (prefix) Jones (last name) Family (suffix) results in "The
Jones". Suffix works if there is a first name: Mr. (prefix) Bob (first name)
Jones (last name) & Family (suffix) results in "Mr. Bob Jones & Family".

Problem #2: By default Word 2007 adds extra space between lines on the
label which can crowd a 4 line overseas address off the the label. Where do
I set the "paragraph" spacing for a sheet of labels.
 
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
suffix in merge documents kathygirl8 Microsoft Word Help 1 December 1st 07 05:59 AM
Zero dropping from zip codes in word mail merge Mary jane Mailmerge 7 April 26th 06 05:59 AM
Merge to Print is dropping characters DOCUBANK Mailmerge 3 June 28th 05 07:07 PM
Mail Merge Dropping leading zeros richard via OfficeKB.com Mailmerge 1 February 4th 05 10:58 PM
Using Suffix field from Outlook 2003 TedW Mailmerge 5 December 6th 04 04:43 PM


All times are GMT +1. The time now is 12:20 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"