Create a worksheet with 3 or 4 fields and populate those fields with 3 or 4 records. The best way for you to understand what I'm talking about is to test it out yourself. However, when I run the macro I get an error as shown in my previous post. I saw that the macro that I recorded was there in my office computer when I opened the word file. Make sure that the path is correct in the other computer. Before I saved the 2 word files that accompany the mailing labels, I copied the macro from the Normal.dot to another file and then just sent the 2 files with the Excel file to my computer at work. The key strokes were then translated into VBA by the macro recorder. All I did was I used the macro recorder to record a macro in MS word to create mailing labels. Has anyone out there tried to automate mailing lables in MS Word? :="ToolsCreateLabels1", LaserTray:=wdPrinterManualFeed WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _įormat:=wdOpenFormatAuto, Connection:="", SQLStatement:="", SQLStatement1 _Ī = FalseĪ Name:="", Address:="", AutoText _ , ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _ĪddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _ "C:\Documents and Settings\Pinciveroma\PO RECEIPTS.xls" _ ![]() For your information I have attached the recorded macro in MS WordĪ = wdMailingLabelsĪ Name:= _ I changed the path of the file in the macro in my office computer. From there I copied the macro from the Normal.dot to another file and then just sent the files to my computer at work. From there I clicked on the "Organizer" button and then selected the "Macros" tab. I Accessed "Tools">"Templates and Add-ins" from the menu bar. Note: I did not save the macro within my normal.dot. I then e-mailed the 2 MS Word files and the Excel file to my office. I then saved the mailing labels and the other MS Word that comes with mailing labels. ![]() I used a short cut key Ctrl+E to run the macro. I then opened up MS Word and recorded a macro to create Mailing Labels. I have created a spread sheet with a few fields and records in Excel. I'm OK at writing macros in Excel but not in MS Word.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |