Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-05-2019, 11:54 AM
ashelton1 ashelton1 is offline Include a list of hyperlinks from excel in one mail merge document Windows 10 Include a list of hyperlinks from excel in one mail merge document Office 2016
Novice
Include a list of hyperlinks from excel in one mail merge document
 
Join Date: Apr 2019
Posts: 3
ashelton1 is on a distinguished road
Default Include a list of hyperlinks from excel in one mail merge document

I have an excel file. Column A is the name of a report, Column B is the URL of that reoprt, column C is the name of the report owner. Most report owners own multiple reports. I want to send an email to these report owners that says something like: "here is a list of your reports that are scheduled to be deleted". What would follow is a list of reports, each on a different line, each one hyperlinked to the online report.

Report 1


Report 2
Report 3


So, if Bob owns 30 reports I don't want him to get 30 emails. I want him to get one email with 30 links to 30 different reports.

Currently, I am using the template shown in this video and it works perfectly to generate the list. The part I am stuck on is turning that list into hyperlinks.
Reply With Quote
  #2  
Old 04-05-2019, 02:39 PM
macropod's Avatar
macropod macropod is offline Include a list of hyperlinks from excel in one mail merge document Windows 7 64bit Include a list of hyperlinks from excel in one mail merge document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Using a normal email merge, the only way you'll get what you're after is if you have a separate column for each report rather than using a new row for each.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-06-2019, 06:05 AM
ashelton1 ashelton1 is offline Include a list of hyperlinks from excel in one mail merge document Windows 10 Include a list of hyperlinks from excel in one mail merge document Office 2016
Novice
Include a list of hyperlinks from excel in one mail merge document
 
Join Date: Apr 2019
Posts: 3
ashelton1 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Using a normal email merge, the only way you'll get what you're after is if you have a separate column for each report rather than using a new row for each.
I’m not sure what you mean. Can you go into more detail?
Reply With Quote
  #4  
Old 04-06-2019, 02:28 PM
macropod's Avatar
macropod macropod is offline Include a list of hyperlinks from excel in one mail merge document Windows 7 64bit Include a list of hyperlinks from excel in one mail merge document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

I'd have thought the description was self-explanatory. What don't you understand about using columns for each report's data instead of rows? That, after all, is how mailmerges are normally done.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 04-06-2019, 02:30 PM
macropod's Avatar
macropod macropod is offline Include a list of hyperlinks from excel in one mail merge document Windows 7 64bit Include a list of hyperlinks from excel in one mail merge document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Cross-posted at: https://forums.windowssecrets.com/sh...merge-document
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 04-06-2019, 03:05 PM
ashelton1 ashelton1 is offline Include a list of hyperlinks from excel in one mail merge document Windows 10 Include a list of hyperlinks from excel in one mail merge document Office 2016
Novice
Include a list of hyperlinks from excel in one mail merge document
 
Join Date: Apr 2019
Posts: 3
ashelton1 is on a distinguished road
Default

Anyone else want to help me?
Reply With Quote
  #7  
Old 04-06-2019, 03:24 PM
macropod's Avatar
macropod macropod is offline Include a list of hyperlinks from excel in one mail merge document Windows 7 64bit Include a list of hyperlinks from excel in one mail merge document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Since it seems you're wedded to do it the hard way, see Merging by Catalog/Directory to E-Mail in my Microsoft Word Catalogue/Directory Mailmerge Tutorial at the top of this forum: https://www.msofficeforums.com/mail-...-tutorial.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Attempting to mail merge one list into a document containing 3 pages - each page needs the same list LisaRH Mail Merge 3 08-09-2018 03:01 PM
Include a list of hyperlinks from excel in one mail merge document Mail merge - pictures instead of url INCLUDE PICTURE Ulises_hm Mail Merge 2 01-30-2018 04:07 AM
Include a list of hyperlinks from excel in one mail merge document Include Table of Contents by Mail Merge Field vandelayindies Mail Merge 1 01-08-2018 03:06 PM
Include a list of hyperlinks from excel in one mail merge document How do i include embedded images in a mail-merge? Hindmost Mail Merge 14 09-18-2015 02:01 PM
Mail merge from Excel to Word and include hyperlinks chay Mail Merge 5 09-28-2013 01:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:26 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft