Hi, @lady3jane. If you upload your macro, I can help you out later today.
Thanks to some JXA code that I have borrowed from @ComplexPoint, I have a few macros that populate the clipboard with links. When the links are pasted into a text editor, they take the form of markdown, i.e., [title](url), whereas when pasted into an rich text editor (e.g., TextEdit, Word, Mail), the links are pasted as hyperlinks.
This reference material might also help: