Hi there,

Disclaimer: I know almost nothing about technical computer things or coding! I have been charged with updating a bunch of things to make some of our work processes more efficient. Hopefully i can give the information you need.

Our process:
We produce media reports in MS Word, using templates, and inserting content from XLSX files through a macro. Each set of data (news story) has two different URLs after it(one to a PDF link, one to a text link). Clients don't want 'ugly' URLS - they want to have 'Print Item' or 'Text Link' displayed.

Problem:
It takes a damn long time to do that manually, so I am sure there is a way to automate it.

The templates and macros look pretty complex to my uneducated eyes. This is what we have:

EXTRACT
Selection.Style = ActiveDocument.Styles("DB_Content")
ActiveDocument.MailMerge.Fields.Add Range:=Selection.Range, Name:="Summary"
Selection.TypeParagraph

' URL
Selection.Style = ActiveDocument.Styles("DB_Content")
Selection.TypeText Text:="Press Clip: "
ActiveDocument.MailMerge.Fields.Add Range:=Selection.Range, Name:="Website_URL"
Selection.TypeParagraph

' TEXT LINK URL
Selection.Style = ActiveDocument.Styles("DB_Content")
Selection.TypeText Text:="Text Link: "
ActiveDocument.MailMerge.Fields.Add Range:=Selection.Range, Name:="Text_Link"
Selection.TypeParagraph


Is someone able to help? Sorry for the really vague information...this is my first attempt at this kind of thing.