Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging Excel cells that contain numbers using Free 3 of 9 Barcode
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging Excel cells that contain numbers using Free 3 of 9 Barcode
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. -- 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 "mreinders" wrote in message ... 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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging Excel cells that contain numbers using Free 3 of 9 Bar
If It turn off the Paragraph markings the end of cell marker goes away, but I
still have the original problem... Stumped! "Doug Robbins - Word MVP" wrote: 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. -- 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 "mreinders" wrote in message ... 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 |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging Excel cells that contain numbers using Free 3 of 9 Bar
What then is the additional character?
-- 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 "mreinders" wrote in message ... If It turn off the Paragraph markings the end of cell marker goes away, but I still have the original problem... Stumped! "Doug Robbins - Word MVP" wrote: 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. -- 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 "mreinders" wrote in message ... 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 |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging Excel cells that contain numbers using Free 3 of 9 Bar
Hi mreinders,
Try formatting just the mergefield, not the whole cell. Cheers "mreinders" wrote in message ... If It turn off the Paragraph markings the end of cell marker goes away, but I still have the original problem... Stumped! "Doug Robbins - Word MVP" wrote: 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. -- 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 "mreinders" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Excel cells to a Word document | Mailmerge | |||
Why isn't all my Excel data merging into my Word labels document? | Mailmerge | |||
ADDRESS NUMBERS SHOW AS 0 WHEN MAIL MERGING FROM EXCEL | Mailmerge | |||
Format Excel data for merging in Word | Mailmerge | |||
Excel worksheet in Word linked text boxes | Page Layout |