F
Frank
We are trying to place an intelligent mail barcode in mailmerge using word
2007. Is there someone that can help us with this problem.
2007. Is there someone that can help us with this problem.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
macropod
Hi Frank,
Intelligent mail barcode for what country? Do you have the intelligent mail barcode font, plus a field containing the verified
barcode character sequence in your data source?
Intelligent mail barcode for what country? Do you have the intelligent mail barcode font, plus a field containing the verified
barcode character sequence in your data source?
C
captquazar
Hi I have the same question with additional info. I my case, barcodes are
created for us by a mail house for use in the USA. USA mail intelligent
barcodes. A test file was sent to us in excel. US postal IB "fonts" have
been installed in our XP workstations. We are used to useing MS mailmerge;
resulting file is a word doc formated for #10 envelopes. (Office 2003) How
do I convert the excel file to a ready to print word doc? Can this even be
done in office 2003? If not what is the exact procedure for office 2007?
How does the printer know a specific string is the bar code sequence?
created for us by a mail house for use in the USA. USA mail intelligent
barcodes. A test file was sent to us in excel. US postal IB "fonts" have
been installed in our XP workstations. We are used to useing MS mailmerge;
resulting file is a word doc formated for #10 envelopes. (Office 2003) How
do I convert the excel file to a ready to print word doc? Can this even be
done in office 2003? If not what is the exact procedure for office 2007?
How does the printer know a specific string is the bar code sequence?
macropod said:Hi Frank,
Intelligent mail barcode for what country? Do you have the intelligent mail barcode font, plus a field containing the verified
barcode character sequence in your data source?
--
Cheers
macropod
[MVP - Microsoft Word]
Frank said:We are trying to place an intelligent mail barcode in mailmerge using word
2007. Is there someone that can help us with this problem.
M
macropod
Hi captquazar,
If your mailmerge data source has the correct barcode data (ie the string representing the barcode characters, not simply the raw
data that gets turned into that string), it shouldme no more difficult than adding the relevant mergefield to the Word document and
formatting it to use the postal barcode font. To do the latter after inserting the mergefield into the Word document:
1. Select the mergefield and press Shift-F9. You should see something like {MERGEFIELD BarCode} or {MERGEFIELD BarCode \*
Mergeformat}
2. Change the text in the mergefield to {MERGEFIELD BarCode \* Charformat} and format the 'M' in 'MERGEFIELD' with the postal
barcode font at the required point size.
3. Position the cursor anywhere in the mergefield and press F9 to update it
4. Run your mailmerge.
--
Cheers
macropod
[Microsoft MVP - Word]
If your mailmerge data source has the correct barcode data (ie the string representing the barcode characters, not simply the raw
data that gets turned into that string), it shouldme no more difficult than adding the relevant mergefield to the Word document and
formatting it to use the postal barcode font. To do the latter after inserting the mergefield into the Word document:
1. Select the mergefield and press Shift-F9. You should see something like {MERGEFIELD BarCode} or {MERGEFIELD BarCode \*
Mergeformat}
2. Change the text in the mergefield to {MERGEFIELD BarCode \* Charformat} and format the 'M' in 'MERGEFIELD' with the postal
barcode font at the required point size.
3. Position the cursor anywhere in the mergefield and press F9 to update it
4. Run your mailmerge.
--
Cheers
macropod
[Microsoft MVP - Word]
captquazar said:Hi I have the same question with additional info. I my case, barcodes are
created for us by a mail house for use in the USA. USA mail intelligent
barcodes. A test file was sent to us in excel. US postal IB "fonts" have
been installed in our XP workstations. We are used to useing MS mailmerge;
resulting file is a word doc formated for #10 envelopes. (Office 2003) How
do I convert the excel file to a ready to print word doc? Can this even be
done in office 2003? If not what is the exact procedure for office 2007?
How does the printer know a specific string is the bar code sequence?
macropod said:Hi Frank,
Intelligent mail barcode for what country? Do you have the intelligent mail barcode font, plus a field containing the verified
barcode character sequence in your data source?
--
Cheers
macropod
[MVP - Microsoft Word]
Frank said:We are trying to place an intelligent mail barcode in mailmerge using word
2007. Is there someone that can help us with this problem.
C
captquazar
Thank you Macro, Yes the string is the ready to use barcode sequence, not
raw data. The mailhouse has 'calculated' it for us. I am afraid I must
reveal my greenhorn status. I have not worked with templates or word
formating controls. e.g. How do you select the mergefield? We have not
previously used barcodes, so I assume I must create the field from scratch.
I do not understand step 2. (no fault of yours) How do I change 'M' in
mergefield to the barcode font and set the point size??
raw data. The mailhouse has 'calculated' it for us. I am afraid I must
reveal my greenhorn status. I have not worked with templates or word
formating controls. e.g. How do you select the mergefield? We have not
previously used barcodes, so I assume I must create the field from scratch.
I do not understand step 2. (no fault of yours) How do I change 'M' in
mergefield to the barcode font and set the point size??
macropod said:Hi captquazar,
If your mailmerge data source has the correct barcode data (ie the string representing the barcode characters, not simply the raw
data that gets turned into that string), it shouldme no more difficult than adding the relevant mergefield to the Word document and
formatting it to use the postal barcode font. To do the latter after inserting the mergefield into the Word document:
1. Select the mergefield and press Shift-F9. You should see something like {MERGEFIELD BarCode} or {MERGEFIELD BarCode \*
Mergeformat}
2. Change the text in the mergefield to {MERGEFIELD BarCode \* Charformat} and format the 'M' in 'MERGEFIELD' with the postal
barcode font at the required point size.
3. Position the cursor anywhere in the mergefield and press F9 to update it
4. Run your mailmerge.
--
Cheers
macropod
[Microsoft MVP - Word]
captquazar said:Hi I have the same question with additional info. I my case, barcodes are
created for us by a mail house for use in the USA. USA mail intelligent
barcodes. A test file was sent to us in excel. US postal IB "fonts" have
been installed in our XP workstations. We are used to useing MS mailmerge;
resulting file is a word doc formated for #10 envelopes. (Office 2003) How
do I convert the excel file to a ready to print word doc? Can this even be
done in office 2003? If not what is the exact procedure for office 2007?
How does the printer know a specific string is the bar code sequence?
macropod said:Hi Frank,
Intelligent mail barcode for what country? Do you have the intelligent mail barcode font, plus a field containing the verified
barcode character sequence in your data source?
--
Cheers
macropod
[MVP - Microsoft Word]
We are trying to place an intelligent mail barcode in mailmerge using word
2007. Is there someone that can help us with this problem.
M
macropod
Hi captquazar,
Since you're dealing with a mailmerge, the barcode data must be included in the mailmerge source file - from your previous post I
assume it's an Excel file. If the barcode data is not in the mailmerge source file, you'll need to add the correct barcode string to
each record in that file. You should ensure the column holding the barcode strings has a header row naming the data (eg BarCode),
like the other columns have. If you then open the Word mailmerge main document, you'll be able to select and add the 'BarCode'
mergefield to the document.
As for step 2, try Format|Font.
--
Cheers
macropod
[Microsoft MVP - Word]
Since you're dealing with a mailmerge, the barcode data must be included in the mailmerge source file - from your previous post I
assume it's an Excel file. If the barcode data is not in the mailmerge source file, you'll need to add the correct barcode string to
each record in that file. You should ensure the column holding the barcode strings has a header row naming the data (eg BarCode),
like the other columns have. If you then open the Word mailmerge main document, you'll be able to select and add the 'BarCode'
mergefield to the document.
As for step 2, try Format|Font.
--
Cheers
macropod
[Microsoft MVP - Word]
captquazar said:Thank you Macro, Yes the string is the ready to use barcode sequence, not
raw data. The mailhouse has 'calculated' it for us. I am afraid I must
reveal my greenhorn status. I have not worked with templates or word
formating controls. e.g. How do you select the mergefield? We have not
previously used barcodes, so I assume I must create the field from scratch.
I do not understand step 2. (no fault of yours) How do I change 'M' in
mergefield to the barcode font and set the point size??
macropod said:Hi captquazar,
If your mailmerge data source has the correct barcode data (ie the string representing the barcode characters, not simply the raw
data that gets turned into that string), it shouldme no more difficult than adding the relevant mergefield to the Word document
and
formatting it to use the postal barcode font. To do the latter after inserting the mergefield into the Word document:
1. Select the mergefield and press Shift-F9. You should see something like {MERGEFIELD BarCode} or {MERGEFIELD BarCode \*
Mergeformat}
2. Change the text in the mergefield to {MERGEFIELD BarCode \* Charformat} and format the 'M' in 'MERGEFIELD' with the postal
barcode font at the required point size.
3. Position the cursor anywhere in the mergefield and press F9 to update it
4. Run your mailmerge.
--
Cheers
macropod
[Microsoft MVP - Word]
captquazar said:Hi I have the same question with additional info. I my case, barcodes are
created for us by a mail house for use in the USA. USA mail intelligent
barcodes. A test file was sent to us in excel. US postal IB "fonts" have
been installed in our XP workstations. We are used to useing MS mailmerge;
resulting file is a word doc formated for #10 envelopes. (Office 2003) How
do I convert the excel file to a ready to print word doc? Can this even be
done in office 2003? If not what is the exact procedure for office 2007?
How does the printer know a specific string is the bar code sequence?
:
Hi Frank,
Intelligent mail barcode for what country? Do you have the intelligent mail barcode font, plus a field containing the verified
barcode character sequence in your data source?
--
Cheers
macropod
[MVP - Microsoft Word]
We are trying to place an intelligent mail barcode in mailmerge using word
2007. Is there someone that can help us with this problem.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.