Formatting of Mail Merge fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ps - 01 Nov 2004 16:58 GMT

Hi,

I have a requirement to produce a number of labels. The data for the labels
is simple, there are three fields:

Name, Title, Type

For example, a record might be "John Smith, I Did It My Way, VBA Programmer"

The data source for the merge is an Excel spreadsheet.

The format of the label is to be:

John Smith

I Did It My Way
VBA Programmer

The Title and Type fields are to align with the last character of the Name
field. Try as I might I have yet to find a way to accomplish this.

I am using Word XP on Windows Server 2003

Any ideas how to do this would be hugely appreciated.
Thanks in advance.

Reply to this Message

Cindy M -WordMVP- - 01 Nov 2004 20:29 GMT

Hi Ps,

> The format of the label is to be:
>
[quoted text clipped - 6 lines]
> The Title and Type fields are to align with the last character of the Name
> field. Try as I might I have yet to find a way to accomplish this.

I don't think there is any way you can get this to work automatically. The
closest thing that occurs to me is the "Automatically resize to fit content"
capability of tables in Word 2000 and later for table columns. But that
would mean every record would have to be a separate table, and the tables
would have to be set up in newspaper type columns. Tricky, and I'm not sure
it would work. But certainly your only chance.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Reply to this Message

Doug Robbins - 02 Nov 2004 01:05 GMT

You may be able to use an { Advance } field to move the "I Did It My Way"
down, but I can't think of a way to deal with the title line.

Signature

Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

> Hi,
>
[quoted text clipped - 28 lines]
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.779 / Virus Database: 526 - Release Date: 19/10/2004

Reply to this Message