01-26-2018 05:28 AM
I have created automatic daily email alerts that come into my outlook email inbox. The alerts contain daily news article links that state the date and headline. Please see below an example;
This is your e-mail from mergermarket generated by your alert: European M&A alert
Is there away to link SAS to Microsoft Outlook 2010 to pull in emails from a subfolder in an inbox and specify the data contained in the body of the email? Ideally I would have the following columns per news link; Date, News_Headline, Practice Group and Sector. Any help on this would be greatly appreciated.
01-26-2018 06:47 AM
Simplest way I can think of is to write a small VBA macro which triggers when mail received to that folder, which takes the body of the text and appends it to a CSV file in a given location, your SAS program would just need to read the CSV.
Am afraid this: "Is there away to link SAS to Microsoft Outlook 2010 to pull in emails from a subfolder in an inbox and specify the data contained in the body of the email? " - doesn't really make any sense to me, do you want the data as a dataset, or an output, or a notification? What SAS are you using?
Also, I would check with your IT, they may already have something in place (most have ticketing systems which use emails, so may be able to pull that data directly into a DB and you extract from there).
01-29-2018 05:33 AM
I would be wanting the data to create a dataset and build up the history of all news alerts that come through. I will then use another internal dataset I have to merge together the data. I'm using SAS 9.4.