使用可变标签数量的Excel / Word Avery标签合并 [英] Excel/Word Avery Label Merge Using Variable Label Quantities
问题描述
我真的不确定如何做到这一点,我对使用Visual Basic(使用微软产品或其他产品)一无所知,但如果有人可以帮助我,我就需要做这件事。
I'm really not sure how to do this and I know nothing about using Visual Basic (with Microsoft products or otherwise) but here is what I need to do if someone can help me.
我正在尝试使用Excel电子表格中字段的Word绘图中的邮件合并功能为图书创建产品价格标签。棘手的部分是我有大约500个不同数量的标题。有些书籍只有大约5份,其他
有200多份。
I'm trying to create product price labels for books using the Mail Merge feature in Word drawing from fields in an Excel spreadsheet. The tricky part is that I have around 500 titles with varying quantities. Some titles only have around 5 copies and other have over 200.
P.S。如果它很重要,我将使用带有MS Office 2011的Mac.Avery Label模板是5498.我从Excel中提取的字段是"标题"。 "零售与QUOT; "价格"和"折扣"。
P.S. If it is important, I'm using a Mac with MS Office 2011. The Avery Label template is 5498. The fields I'm pulling from Excel are "Title" "Retail" "Price" and "Discount".
再次感谢您提供的任何帮助。
Thanks again for any help you can offer.
Jason
推荐答案
查看对话
http://answers.microsoft.com/ en-us / office / forum / office_2007-word / creating-a-label-mail-merge-with-variable / 0fad8de3-8ac9-4725-ac17-2b42fe18fd8e
http://answers.microsoft.com/en-us/office/forum/office_2007-word/creating-a-label-mail-merge-with-variable/0fad8de3-8ac9-4725-ac17-2b42fe18fd8e
(不要忘了回到这里说你是否找到了答案!)
(Don't forget to come back here and say whether you found an answer!)
这篇关于使用可变标签数量的Excel / Word Avery标签合并的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!