 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / July 2005Creating A Macro To Create Address Labels
Bear with me as I'm new to this. I thought I would create a macro to produce the necessary address labels to save me and my people having to type in the whole process each time. I selected Avery A4 and A5 sizes - L7159 but this info wasn't included in the created macro. When I run the macro it only placed four addresses on a page. When I'm stepping through the process to create the macro there are 24 address labels per page, as expected. Any ideas? Thanks, Jerry Slocombe Still Learning Why don't you just use mail merge? http://www.officearticles.com/word/mail_merge_labels_in_microsoft_word.htm You can save the mail merge document before you merge the labels. Change the data source any time you like, run the merge again. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com > Bear with me as I'm new to this. > I thought I would create a macro to produce the necessary address labels to [quoted text clipped - 9 lines] > Jerry Slocombe > Still Learning Hi Anne, Does your reply only apply to Word 2003? I'm using Word 2000 and have different options to those advised in http://www.officearticles.com/word/mail_merge_labels_in_microsoft_word.htm  SignatureJerry Slocombe Still Learning > Why don't you just use mail merge? > http://www.officearticles.com/word/mail_merge_labels_in_microsoft_word.htm [quoted text clipped - 22 lines] > > Jerry Slocombe > > Still Learning Anne, Are you saying that I can set up the correct 'template' for the labels and then only have to change the data source? If so, which file do I need to save - Labels1 or Document1? I assume that I can then open that file and just change the data source? Apologies for being slow but how do I do that? SignatureJerry Slocombe Still Learning > Hi Anne, > [quoted text clipped - 28 lines] > > > Jerry Slocombe > > > Still Learning No problem, Jerry. Save Document1. Labels1 is the labels already created, right? Here's Mail Merge for 2000: http://www.theofficeexperts.com/word.htm#MailMerge ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com > Anne, > [quoted text clipped - 8 lines] > > Does your reply only apply to Word 2003? > > I'm using Word 2000 and have different options to those advised in http://www.officearticles.com/word/mail_merge_labels_in_microsoft_word.htm > > > Why don't you just use mail merge? http://www.officearticles.com/word/mail_merge_labels_in_microsoft_word.htm > > > You can save the mail merge document before you merge the labels. Change the > > > data source any time you like, run the merge again. [quoted text clipped - 19 lines] > > > > Jerry Slocombe > > > > Still Learning Hi Anne, Thanks for your help. I can now open the 'template' (Document1) before hitting Mail Merge to select the data source before merging and printing. The next challenge for me is to create a macro that:- 1. Opens the template - done that 2. GetFileName for data source - not sure about that. Assume I add a command button but don't know the code 3. Merge the data - I can plagiarise that from previous macro 4. Print labels - ditto, as above I used to be a programmer some 15 years ago but I'm a little rusty, as if you hadn't guessed, and I've never used VB! SignatureJerry Slocombe Still Learning > No problem, Jerry. > Save Document1. Labels1 is the labels already created, right? Here's Mail [quoted text clipped - 56 lines] > > > > > Jerry Slocombe > > > > > Still Learning 2. There's a button on the mail merge toolbar to "open data source". And, I THINK You might be able to record these macros, Jerry. :) http://www.officearticles.com/word/record_a_macro_in_microsoft_word.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com > Hi Anne, > [quoted text clipped - 32 lines] > > > > Does your reply only apply to Word 2003? > > > > I'm using Word 2000 and have different options to those advised in http://www.officearticles.com/word/mail_merge_labels_in_microsoft_word.htm > > > > > Why don't you just use mail merge? http://www.officearticles.com/word/mail_merge_labels_in_microsoft_word.htm > > > > > You can save the mail merge document before you merge the labels. > > Change the [quoted text clipped - 26 lines] > > > > > > Jerry Slocombe > > > > > > Still Learning Nice try Anne.... ... but there's no Mail Merge toolbar in Word 2000. Don't suppose you happen to know the VB code to browse for a filename so I could use it for "ActiveDocument.MailMerge.OpenDataSource Name:=" in the macro. SignatureJerry > 2. There's a button on the mail merge toolbar to "open data source". > [quoted text clipped - 90 lines] > > > > > > > Jerry Slocombe > > > > > > > Still Learning No mail merge toolbar? Sure there is. Go to Tools-->Mail merge. There's the mail merge toolbar. Jerry... may I make a suggestion? Go to www.vbaexpress.com and join. You'll be MUCH happier there... very good, very nice Word coders. You can even paste your code all pretty, and upload your file. :) I am no coder. I'm a glorified macro recorder. But I created that site 'cause I don't want to learn code. :) I also know you'll find lots of interesting codebits here: http://www.vbaexpress.com/kb/kblist.php If you're a member, you can search it. Membership is free and they won't even spam you. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com > Nice try Anne.... > [quoted text clipped - 57 lines] > > > > > > Does your reply only apply to Word 2003? > > > > > > I'm using Word 2000 and have different options to those advised in http://www.officearticles.com/word/mail_merge_labels_in_microsoft_word.htm > > > > > > > Why don't you just use mail merge? http://www.officearticles.com/word/mail_merge_labels_in_microsoft_word.htm > > > > > > > You can save the mail merge document before you merge the labels. > > > > Change the [quoted text clipped - 29 lines] > > > > > > > > Jerry Slocombe > > > > > > > > Still Learning Cheers Anne, I'll let you go now! Thanks for your patience. BTW there's no 'Mail Merge' tool bar with Word 2000 only a 'Mail Merge Helper' I will act on your suggestions. Take care. SignatureJerry > No mail merge toolbar? Sure there is. Go to Tools-->Mail merge. There's the > mail merge toolbar. [quoted text clipped - 134 lines] > > > > > > > > > Jerry Slocombe > > > > > > > > > Still Learning |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.