Merging Excel cells that contain numbers using Free 3 of 9 Barcode

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mreinders - 13 Dec 2005 18:19 GMT

I have an excel spreadsheet that is the data source for a mail merge letter.
One column contains *XXXXX-XXXX-X* (X being numbers) they are formated with
Free 3 0f 9 Barcode Font. If I print them from Excel, I can scan and read the
numbers with a hand held barcode reader. If I merge them to a word document,
they pic up an additional character that prevents them from being read. The
Word document is formatted in a table format that has a hidden character in
it (a circle with four tabs at an X pattern around the edge. Any help would
be greatly appreciated

Reply to this Message

Doug Robbins - Word MVP - 13 Dec 2005 18:44 GMT

The character that you describe is the end of cell marker. You can prevent
it being displayed by clicking on the ¶ button on the toolbar. It does not
however print so I am not sure how it would be affecting the barcode
reading.

Signature

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

>I have an excel spreadsheet that is the data source for a mail merge
>letter.
[quoted text clipped - 11 lines]
> would
> be greatly appreciated

Reply to this Message

mreinders - 13 Dec 2005 19:19 GMT

If It turn off the Paragraph markings the end of cell marker goes away, but I
still have the original problem... Stumped!

> The character that you describe is the end of cell marker. You can prevent
> it being displayed by clicking on the ¶ button on the toolbar. It does not
[quoted text clipped - 16 lines]
> > would
> > be greatly appreciated

Reply to this Message

Doug Robbins - Word MVP - 14 Dec 2005 05:21 GMT

What then is the additional character?

Signature

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

> If It turn off the Paragraph markings the end of cell marker goes away,
> but I
[quoted text clipped - 24 lines]
>> > would
>> > be greatly appreciated

Reply to this Message

macropod - 22 Dec 2005 11:51 GMT

Hi mreinders,

Try formatting just the mergefield, not the whole cell.

Cheers

> If It turn off the Paragraph markings the end of cell marker goes away, but I
> still have the original problem... Stumped!
[quoted text clipped - 19 lines]
> > > would
> > > be greatly appreciated

Reply to this Message