How can I get bar codes w/ Excel & mail merge?

S

Scarecrow

I want to send out a bulk mailing with large postcards. I want the addresses
printed on the postcards via mail merge. I am using Excel, but don't see
where or how to add the bar code to the address, which would save me a lot of
money. Can you help?
 
G

Guest

-----Original Message-----
I want to send out a bulk mailing with large postcards. I want the addresses
printed on the postcards via mail merge. I am using Excel, but don't see
where or how to add the bar code to the address, which would save me a lot of
money. Can you help?
.
Click to expand...
 
G

Guest

hi,
I not entirely sure what you are asking but barcodes are
just another font. excel uses font 3 of 9 barcode.
If you can add the address then just add it a second time
useing font 3 of 9 barcode.
 
G

Guest

via Envelopes and labels. On the envelopes
tab>options...there is a block to select bar codes.
 
D

David McRitchie

US zip mail bar coding is builtin to MS Word, I don't really
understand why other bar codes are not builtin. You have
no choice as to the position for some reason they appear
above the address. Anyway it must be legal and accepted by
the US Post Office in that position. See
Mail Merge, Printing Labels using Mail Merge with data from Excel
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
S

Scarecrow

Actually, I just discoverd that while I used MS Word, and assumed that the
tables would be set up in Excel, they in fact, are not. They are in Access!
I am not familiar with this program , but am wondering if the bar codes will
be printed on to my postcards (remember, no labels are being used)....

David McRitchie said:
US zip mail bar coding is builtin to MS Word, I don't really
understand why other bar codes are not builtin. You have
no choice as to the position for some reason they appear
above the address. Anyway it must be legal and accepted by
the US Post Office in that position. See
Mail Merge, Printing Labels using Mail Merge with data from Excel
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Scarecrow said:
I want to send out a bulk mailing with large postcards. I want the addresses
printed on the postcards via mail merge. I am using Excel, but don't see
where or how to add the bar code to the address, which would save me a lot of
money. Can you help?
Click to expand...
Click to expand...
 
Top