Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-07-2022, 05:56 PM
littlepeaks littlepeaks is offline accessing avery label table in macro Windows 10 accessing avery label table in macro Office 2010 32bit
Novice
accessing avery label table in macro
 
Join Date: Jan 2012
Location: Colorado Springs, CO
Posts: 16
littlepeaks is on a distinguished road
Default

I've used mail marge once or twice -- not sure what the limitations of its capabilities are. More familiar with VBA.
Reply With Quote
  #2  
Old 08-07-2022, 06:23 PM
littlepeaks littlepeaks is offline accessing avery label table in macro Windows 10 accessing avery label table in macro Office 2010 32bit
Novice
accessing avery label table in macro
 
Join Date: Jan 2012
Location: Colorado Springs, CO
Posts: 16
littlepeaks is on a distinguished road
Default

Never mind-- I opened up the VBA editor in Word , and looked up "Tables" in the "Help", "Word Object Model Reference". It told me what I wanted to know.


Basically I can use:


strLabelText = ActiveDocument.Tables(1).Cell(1,1).Range.Text 'Copies the text
ActiveDocument.Tables(1).Cell(2,1).Range.Text= strLabelText 'Pastes the text into the cell below


This requires a lot more coding and cleaning up, but I could not figure out how to access the table. I have something to work with now.


Thanks again.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving Avery Label 8376 fsinclaire Word 1 04-30-2022 09:12 AM
accessing avery label table in macro Accessing the format tab with the macro recorder reneemettrie Word VBA 6 01-10-2020 12:03 PM
accessing avery label table in macro Avery Label Templates, editing rows/spacing rainandwind_95448 Word 2 12-13-2015 08:05 AM
accessing avery label table in macro Avery Label Template for Word 2003? Clueless in Seattle Word 2 03-31-2015 06:15 AM
Having trouble using Avery 4014 label to print multiple pages Dickie Mail Merge 1 09-29-2013 07:28 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:53 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft