View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Hardgreaves Rob Hardgreaves is offline
external usenet poster
 
Posts: 1
Default excel / word problem

Hi This is half excel related as I am using code to transfer rows of
info to a word doc from excel in a mail merge fashion.

I cant use object lib references so i have to have the bookmarks in word
pre written.

I have a word document and I need to create a number of bookmarks in a
pattern throughout the workbook.

There are 5 bookmarks in the same position on each page and I need to
duplicate this throughout the document. Same page layout, same bookmark
placement but bookmark name incremented by one each time.

I can obviously manage a copy and paste to get the desired amount of
pages but I dont know how to add the bookmarks.

I have posted an attachment with the word doc template in a zip. This
has 3 records / pages within at the moment and the bookmarks are named
in page 1 like this -

AIName1
AIRef1
Operator1
Manager1
Address1
MeterNo1

so the rest of the bookmarks ideally would be the same but with the page
number instead of the 1.

I hope i have posted it clear enough. I know in the past I find it
difficult to explain myself.

Rob



*** Sent via Developersdex http://www.developersdex.com ***