Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-01-2020, 12:42 PM
Arkla Arkla is offline Adding LOTS of bookmarks to document Windows 10 Adding LOTS of bookmarks to document Office 2016
Novice
Adding LOTS of bookmarks to document
 
Join Date: Jul 2019
Posts: 3
Arkla is on a distinguished road
Question Adding LOTS of bookmarks to document

I have a large document with lots of repetitive data that could be created from an Access database with bookmarks.



The problem is, I have hundreds of data items that could be included.

I already have suitable names in an access database, can I insert these into a Word document in a bulk fashion?

The main goal is to be able to add several hundred bookmarks without having to do it one at a time in the Word dialog box.
Reply With Quote
  #2  
Old 12-01-2020, 12:53 PM
Arkla Arkla is offline Adding LOTS of bookmarks to document Windows 10 Adding LOTS of bookmarks to document Office 2016
Novice
Adding LOTS of bookmarks to document
 
Join Date: Jul 2019
Posts: 3
Arkla is on a distinguished road
Default

I found this:

How can I quickly add a lot of bookmarks? - Microsoft Community

Not exactly what I am looking for, but may work.
Reply With Quote
  #3  
Old 12-01-2020, 01:54 PM
Charles Kenyon Charles Kenyon is offline Adding LOTS of bookmarks to document Windows 10 Adding LOTS of bookmarks to document Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

What is your end-game? What is the purpose of the bookmarks?

Some other technique may have more benefit to you. I am contemplating mapped content controls. Are you creating a new document using code? Working with an existing template to create a new document? Using an existing document?
Reply With Quote
  #4  
Old 12-01-2020, 04:51 PM
Guessed's Avatar
Guessed Guessed is offline Adding LOTS of bookmarks to document Windows 10 Adding LOTS of bookmarks to document Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Yes you can insert bookmarks in bulk from an external source like Access. There isn't an existing process though and VBA code will have to be developed to deal with your unique inputs.

The key command requires a valid bookmark name and a 'range' in the document where the bookmark needs to be inserted.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #5  
Old 12-01-2020, 05:49 PM
macropod's Avatar
macropod macropod is offline Adding LOTS of bookmarks to document Windows 10 Adding LOTS of bookmarks to document Office 2010
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

I suspect what the OP is after requires a mailmerge... No bookmarks required.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 12-01-2020, 08:02 PM
Arkla Arkla is offline Adding LOTS of bookmarks to document Windows 10 Adding LOTS of bookmarks to document Office 2016
Novice
Adding LOTS of bookmarks to document
 
Join Date: Jul 2019
Posts: 3
Arkla is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
I suspect what the OP is after requires a mailmerge... No bookmarks required.
A mail merge would be great, but I thought the limit was 256 merge fields.
Reply With Quote
  #7  
Old 12-03-2020, 04:20 PM
macropod's Avatar
macropod macropod is offline Adding LOTS of bookmarks to document Windows 10 Adding LOTS of bookmarks to document Office 2010
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

No, but the real question is whether each record requires more than 256 fields. In a mailmerge, you create a document with all that is needed to process a single name/address, with mergefields pointing to the relevant data fields. Completing the merge will output a document containing replicas of that letter personalised for each name/address. See: Use mail merge to send Access data to Word - Access
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding LOTS of bookmarks to document split word document based on bookmarks with each new document title of the bookmark megatronixs Word VBA 9 09-05-2020 02:29 PM
Adding LOTS of bookmarks to document Loop thru document and create bookmarks jeffreybrown Word VBA 3 09-22-2018 06:04 AM
Automation of a tecnical document with bookmarks Renatoravalli Word 2 06-21-2017 04:47 AM
Adding LOTS of bookmarks to document Update bookmarks and variables in document webharvest Word VBA 5 06-21-2011 03:22 PM
Using bookmarks in a protected document Bill Stemp Word 0 10-16-2010 06:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:33 AM.


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