Thread: [Solved] Deleting link using macro
View Single Post
 
Old 09-15-2018, 02:30 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The workbook, sparse as it is, isn't laid out in a way that would be useful for a mailmerge of any kind; the data presently in the workbook would need to be transposed. The letter also refers to a list, but there's no provision for that in the workbook. In any event, you don't need a macro to break any links; Ctrl-A (to select the entire document) or just selecting the affected range, followed by Ctrl-Shift-F9 will do so.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote