PDA

View Full Version : Mail merge and bookmark



riduwanz
02-26-2005, 01:10 AM
Hello All,

I generate pages using mailmerge (data source is Excel sheet). Is there a way to create bookmark in the generated pages automatically using the data in the Excel sheet column as bookmark name?

Thank you in advance for your help. :bow:

Regards
Rid

Anne Troy
02-26-2005, 01:39 AM
Hi, Rid.

What's the bookmark for? Can you tell us your desired end result?

riduwanz
02-26-2005, 01:53 AM
Thanks Dreamboat,

Each page generated has a chart; and each chart is stored in an Excel file (filename is based on the title of the page generated). What I have done is a manual work: generate the page, open the chart spreadsheet one by one, Copy Picture the chart, and paste into individual Word document page. Such process has turned tedious particularly when there are 1000 records.

Ideally, what I hope to achieve is to generate the pages using mailmerge, run a macro in Word to open individual Excel Chart file, Copy Picture the chart, close the Excel file, paste the Picture into the Word document page based on the bookmark position.

Or is there a better way of doing it? :dunno

Regards
Rid