DATA Step, Macro, Functions and more

FILENAME EMAIL: LotusNotes to Outlook 2010

Reply
Contributor
Posts: 52

FILENAME EMAIL: LotusNotes to Outlook 2010

For years, we have had SAS code that creates many emails using LotusNotes.  We are now transitioning to Outlook 2010.  The example SAS code follows my signature.

My html attachment is no longer rendering as the actual note.  If another attachment exists, then the html file is an additional attachment.  If there is only the html attachment, then it will render as the note.  The beauty of using the html attachment for the note is that the non-SAS user has control of the note.  For the short-term, I will create a PUT statements note.  Double-Yuck!!! 

Have others run into this issue with Outlook 2010?  Aside:  Like others posting to these discussion communities, I haven’t been able to get ODS HTML/HTML3 to create a note.  The note is the HTML code.

TIA,

Kim LeBouton

filename outbox email 'nul';

data _null_;

file outbox

      to=     (

"to_email_group"

               )

      cc=      (

"cc_email_group"

                )

      subject="A Spiffy Report for &Region"

      attach=(

"emailnote.htm"

"theattachedreportsfortheregion.zip"

               );

run;

SAS Employee
Posts: 104

Re: FILENAME EMAIL: LotusNotes to Outlook 2010

You can use ODS to write the body of the email in HTML. If you do, and want the code to render properly in Outlook 2010, you should use the HTML3 ODS destination.  Discussion and sample code are available on the SAS Training Post blog: Jedi SAS Tricks: Email from the Front – Part 2

Regards,

Mark

Contributor
Posts: 52

Re: FILENAME EMAIL: LotusNotes to Outlook 2010

I should have elaborated on my third paragraph above, which is tied to your blog.  I can't get your code to work, but thank you for all of the information and the video.

At this point, I am using SAS 9.3 (TS1M1) without the SMTP host or port specified.  I have yet to find the right person to provide this information.  Although I've tried, I haven't been able to figure out the version of Outlook 2010 that I am using.

Any suggestions?

Kim

Frequent Contributor
Posts: 91

Re: FILENAME EMAIL: LotusNotes to Outlook 2010

I don't know if this will help, but I have an E-mail send that is structured a little bit differently, and includes TYPE='text/html' like example #2 in  http://support.sas.com/resources/papers/proceedings11/300-2011.pdf.  Cynthia says her E-mail is received on Outlook 2010, which is why I have posted this.

-EMAILHOST mail.myplace.com -emailsys smtp is set in our configuration file (proc options at the bottom).

Hope this helps...

WendyT

 

DATA _NULL_ ;

     FILENAME WEEKLYREP EMAIL

       SUBJECT="Weekly report"

       FROM="wendyt@myplace.com"

       TO=("person1@myplace.com" "person2@myplace.com" "person3@myplace.com")

       CC= "wendyt@myplace.com"

       TYPE='text/html'

       ATTACH=("&QA_REPORTS\WEEKLY_REPORT1.HTML" "&QA_REPORTS\WEEKLY_REPORT2.HTML" );

RUN ;

6 proc options GROUP=EMAIL ; run ;

SAS (r) Proprietary Software Release 9.2 TS2M3

EMAILAUTHPROTOCOL=NONE

                                    Identifies the SMTP e-mail authentication protocol

NOEMAILFROM       Do not require FROM= for SMTP email

EMAILHOST=mail.myplace.com

                  SMTP server host for email access method

EMAILID=          From E-mail address, log in id, or profile for use with underlying e-mail system

EMAILPORT=25      Port number for SMTP server for email access method

EMAILPW=xxxxxxxx  Used by the E-mail Access Method and Send menu item to set the email session login password for the underlying e-mail system

EMAILDLG=NATIVE   Used by Send menu item to set the email dialog interface.

EMAILSYS=SMTP     Used by E-mail Access Method and Send menu item to set the interface type with underlying e-mail system.

Trusted Advisor
Posts: 2,113

Re: FILENAME EMAIL: LotusNotes to Outlook 2010

To find out your Outlook 2010 version, go to file --> help

and the version will be displayed in the right panel.  There is also a link for additional version information.

I use SMTP to e-mail and you do need the hostname to make it work.  The IT folk who support the Exchange servers will know the name and necessary connect information for your SMTP host (Exchange also uses it to send e-mail outside of your organization.).  You need to talk to the server support people (Exchange), not the client side support people (Outlook).

Doc Muhlbaier

Duke

Contributor
Posts: 52

Re: FILENAME EMAIL: LotusNotes to Outlook 2010

Finally back from vacation.

Thanks for the Outlook 2010 version information.

I will reach out to the exchange folks.

Kim

N/A
Posts: 1

Re: FILENAME EMAIL: LotusNotes to Outlook 2010

Hello,

There are some third party conversion software present in Web, you can try to use any of them for help. I would like to recommend such a software named as Kernel for NSF to PST Converter, this software can be downloaded as a free trial from here www.howconvertnsftopst.convertnsftopst.biz

N/A
Posts: 1

Re: FILENAME EMAIL: LotusNotes to Outlook 2010

Hii,

Choose safe and secure NSF to PST Conversion tool such as Export Notes which migrates all Lotus Notes elements to Outlook with encrypted data. Software converts selected mails, calendar, to do list from NSF to PST with selected date and range and exclude unwanted folders like sent or deleted from migration process.

Get free demo from:http://www.convertnsftopst.net

Valued Guide
Posts: 3,208

Re: FILENAME EMAIL: LotusNotes to Outlook 2010

Kim do not focus on Outlook as it is the client not the mailserver.

When organizing sending mail focus on the mailserver in your case there is a an Exchange server as you mentioned that.

Of course you can use Outlook as local service to send mail. What will happen is that the outlook program will be called and a popup is coming verifying you are a human and no spammer.

Outlook is communicating with a email-server.

The direct approach is connecting to the mail-server. A little painful for SAS is that they are too far behind with all evolvments in the market. When you are required to use a secured way of sending you could end up needing SAS 9.4.

SAS(R) 9.4 Companion for Windows, Third Edition what is new:  encrypt e-mail by using SSL or TLS encryption protocols . 

The SMTP send mail protocol does by design not having any security, the old way is assigning the machine (registered IP address) allowing sending the  mail.

The option "message-send from" is another weakness of smpt as the sender can be faked not being part of the email-server. 

Using the Html-3 version is something that comes in with Microsoft office see: White Paper: Message Formatting. For some reason MS is still using the old Html-version in their office products. This is probably changing.

When you need the html layout set it on the old version, the newer html tags are ignored. With SAS the default html setting is part of the SAS-registry of the running user. If you have many batch processes generating html needed the old version as default than that is a bypass to remember. 

---->-- ja karman --<-----
N/A
Posts: 1

Re: FILENAME EMAIL: LotusNotes to Outlook 2010

Hey Friends are you looking forward to third party tool for the conversion from NSF to PST format then adopt this simple tool enriched with advance features of Filtering and many more. For more information visit:

http://www.lotusnotestooutlook.net

N/A
Posts: 1

Re: FILENAME EMAIL: LotusNotes to Outlook 2010

Use NSF to PST Converter software is an efficient software for converting NSF file to Outlook PST files. Lotus Notes (.NSF) files to importable MS Outlook (.PST) files . This software save converted mails in PST, RTF, PDF & HTML Format also.You can try its demo version and evaluate the software completely. For more info visit: - NSF to PST Converter Tool for Lotus Notes to Outlook Migration

N/A
Posts: 1

Re: FILENAME EMAIL: LotusNotes to Outlook 2010

Have a look here http://www.nsftopstconverter.nsftooutlook.org/

By using this smartly programmed NSF to PST Conversion software, one can easily transfer or move lotus Notes data or NSF files to outlook PST format within seconds.

SAS Employee
Posts: 104

Re: FILENAME EMAIL:  LotusNotes to Outlook 2010

If you are trying to create outgoing email with the body of the email in HTML format, take a look at my blog post on this topic "Jedi SAS Tricks: Email from the Front – Part 2"

May the SAS be with you!
Mark

New User
Posts: 1

Re: FILENAME EMAIL: LotusNotes to Outlook 2010

You can get of Quality app that is used by most migration consultants to convert data of Lotus Notes to Outlook PST file format but this software is highly advanced and no other app matches with its conversion speed. Entirely converts all emails, contacts, tasks, journals etc to MS Outlook PST file format.

So Visit:- http://www.mannatsoftware.com/kernel-lotus-notes-to-outlook.html

New User
Posts: 1

Re: FILENAME EMAIL: LotusNotes to Outlook 2010

The best way to convert NSF to PST is Lotus Notes to Outlook Migration Tool. This tool is one stop solution for Lotus Notes file conversion. It converts in seven file formats. Refer for more info: - http://www.mailproplus.com/email-migration/lotus-notes/outlook.html

Ask a Question
Discussion stats
  • 16 replies
  • 1637 views
  • 1 like
  • 14 in conversation