Hi,
I have been able to successfully mail merge text and date fields from Access to a Word document.
However, I have a hyperlink field which does not appear to merge correctly.
In the DB I have edited the hyperlink to have a more convenient name by setting the Text to display option to "Student".
When the hyperlink is merged into the word doc it displays "Student" and the Address in one long string of characters.
Not only does the hyperlink not work but it seems to have added a "#" the start and end of the address.
Any help would be greatly appreciated.
I have been able to successfully mail merge text and date fields from Access to a Word document.
However, I have a hyperlink field which does not appear to merge correctly.
In the DB I have edited the hyperlink to have a more convenient name by setting the Text to display option to "Student".
When the hyperlink is merged into the word doc it displays "Student" and the Address in one long string of characters.
Not only does the hyperlink not work but it seems to have added a "#" the start and end of the address.
Any help would be greatly appreciated.