Re: Easiest/best way to create an email using local MS Outlook with file attachments?

Author: Alan Bourke

Posted: 2019-08-21 at 03:17:04

If you want to use Outlook:

loOutlook=CreateObject("Outlook.Application")

loMsg = loOutlook.CreateItem(0)

loMsg.BodyFormat= 2 && olFormatHTML

loMsg.HtmlBody="<p>HTML body text</p>"

loMsg.Body = "Plain body text for clients without HTML mail support."

loMsg.Subject="Subject"

loMsg.Recipients.Add("someguy@somewhere.com")

loMsg.Recipients.Add("somegal@anotherplace.com")

loMsg.Attachments.Add("attach1.txt", 1)

loMsg.Attachments.Add("attach2.txt", 1)

loMsg.Attachments.Add("attach3.txt", 1)

Try

llSent = loMsg.Send()

Catch to loException

&& handle it

Finally

release loMsg

release loOutlook

Endtry

HOWEVER

There are some drawbacks to this.

- Despite it sending via Outlook, you will find that any Outlook signatures or stationery that would normally apply won't get used on the programmatically created message.

- You may find that the dread Outlook security message ('A program is trying to send mail on your behalf...') will crop up, depending on Outlook and Exchange Server version.

--

Alan Bourke

alanpbourke (at) fastmail (dot) fm

On Wed, 21 Aug 2019, at 5:22 AM, MB Software Solutions, LLC wrote:

> VFP9SP2 app

>

> Customer uses Outlook and wants the app to generate an email to a given

> email address from the app AND attach certain documents to it.  Customer

> will preview it and then manually hit "Send" on their own.

>

> What's the BEST (and hopefully easiest) way to implement this? Invoke

> Outlook via CREATEOBJECT and set properties and attachments

> accordingly?  Typically in the past I've used MAILTO and ShellExec but

> this time the extra requirement is to have files attached from the

> application too, which makes MAILTO not an option, if I understand

> correctly.

>

> tia,

> --Mike

>

>

>

> ---

> This email has been checked for viruses by Avast antivirus software.

> https://www.avast.com/antivirus

>

>

[excessive quoting removed by server]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: https://leafe.com/archives

This message: https://leafe.com/archives/byMID/b041d48b-be2d-452f-94e7-595cf45419df@www.fastmail.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2019 Alan Bourke