Thread: Page numbering from Access
View Single Post
 
Old 10-16-2020, 05:06 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,989
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
I can't see how you are using the access data to populate the Word docs from this code so it might be worth suggesting an alternative approach? Why not have multiple word doc templates already created and use your If section to determine which of the Word docs to open. Eg

MergeDoc = "S:\K Jones Only\WordMBR Control.docx"
vs
MergeDoc = "S:\K Jones Only\WordMBR Out of Control.docx"
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote