Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Hi Mary,
It will be easier for us to help you if you copy and paste the code of the macro that you have developed into a message that you post back here. -- Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Mary" wrote in message ... -----Original Message----- Hi Mary, I'm creating a form that our clients can fill out in Microsoft Word. I've been asked that our clients be able to print labels from this form as well, grabbing information from a particular field on the form. The field's name is "FieldNo." The label "FieldNo" is not in the first row of the form, it's half-way down the page. I don't want the clients to go through a mailmerge process, I'd like them to be able to choose a button that says "Print Labels", and the labels will print. We're going to use Avery 8160 for the labels. The client will enter 1 or more field nos. in the field no. column. I'm guessing I'll need to create a macro to do this, but I'm a macro rookie. A couple of questions 1. Version of Word? 2. Is this a form created using the Forms toolbar, or something else? 3. If you're in a regular document (not protected as a form), does the Tools/Envelopes and Labels/Labels command do basically what you need? Note: the correct place to get help on macros if you've no experience is the word.vba.beginners newsgroup. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e- :-) . Hi again Cindy, I just wanted to tell you I've made some progress since the last post. I have my datasource opening from a macro in my form, and I have the values of the bookmarks "Text1"-"Text5" in the form being sent as the values of "label1"-label5" on the datasource. The data comes across into the datasource document as "FORMTEXT" followed by the value, so I'll have to find a way to strip "FORMTEXT", then actually merge my datasource into labels, but at least I'm getting somewhere. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to update ToC in a form - I'm stuck! | Microsoft Word Help | |||
Adding Autotext in a Macro User Form field | Microsoft Word Help | |||
Macro upon opening in a form | Microsoft Word Help | |||
Add a new page in a form by using a macro??? | Microsoft Word Help | |||
macro for unprotecting form, update TOC, then reprotect form?? | Microsoft Word Help |