topic Import Data from Outlook folder in Microsoft Integration with SAS

Import Data from Outlook folder

cmoore — Fri, 26 Jan 2018 10:28:37 GMT

Hi,

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

Computer services

25/01/2018 Econocom wants to make more acquisitions (translated)

Bolt on/Opportunistic

Consumer: Other

25/01/2018 Novartis could pay up to USD 10bn for individual acquisitions; no deadline for US generics unit decision (translated)

Bolt on/Opportunistic, Cross Border, Takeover situations, Other, Other

24/01/2018 Companies to follow in Italy: new investments, growth plans, potential for M&A
Proprietary Intelligence

Companies for sale

Consumer: Retail

25/01/2018 Emté owner Sligro expects to sell supermarket chain this year (translated)

Auction/Privatization

24/01/2018 Pets at Home shareholder KKR placing 12.3% stake via AAB

Companies for sale, Private equity related

24/01/2018 Yonghui Superstores wants no controlling stake in Carrefour China; company to resume stock trading on 25 January

Cross Border, Takeover situations

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.

Thanks

Chris

Re: Import Data from Outlook folder

RW9 — Fri, 26 Jan 2018 11:47:19 GMT

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).

Re: Import Data from Outlook folder

cmoore — Mon, 29 Jan 2018 10:33:39 GMT

Hi,

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.

Thanks

Chris