A department at work sends out email newsletters containing news from various regions (Africa, Asia, Europe, etc.) and classified, hyperlinked news headlines from each on a regular basis. They organize it in Word and then send it out via Outlook with hyperlinked headlines. Every time, they have to do this manually, and I get the impression they despise it. Perhaps there is a better approach than mine, but my first thought was to create an email template that could automatically update the template with data from an excel sheet. Most themes on the Internet (MailChimp, etc.) are fancy marketing-types that we don't needs. We desperately need a better approach to display a large number of distinct bits of data. What are your thoughts on this? I'm not sure if it's doable, but could we automate this process so that we can simply drop a URL into a spreadsheet and it grabs the headline and hyperlinks it for us? Thank you in advance for your assistance! Our computers run Windows 10 Server, but we also have Macs.
Best answer by Dov
View original