Using PowerShell to Send a Mail Template with embedded Pic

Question

Alright so this is tricky, or at least I think it is.

I want to send a list of recipients a welcome aboard email. Right now what I do is manually copy a mail in my Drafts folder in Outlook, appending the recipients and sending. Obviously that doesn't scale.

Sending mail with PowerShell is easy, sending HTML mail is easy; BUT I don't know how to send a mail that is based on this "template" which has two embedded PNGs (logos and such).

I wish I could something like:

$Body=OutLook.msg

Your thoughts?

PS Right now I am experimenting with saving the Outlook message as HTML, this could be entirely the wrong path.

Dmitry Streblechenko · Accepted Answer · 2020-01-11 19:27:17Z

1

Save a template message as an OFT file, then programmatically call Application.CreateItemFromTemplate. Populate the recipients appropriately (MailItem.Recipients.Add), modify the message body if you need to (MailItem.HTMLBody), and send it (MailItem.Send).

edited Jan 11, 2020 at 19:27

answered Jan 24, 2015 at 18:36

Dmitry Streblechenko

67.1k4 gold badges56 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Aaron Wurthmann Over a year ago

I'm reading: msdn.microsoft.com/en-us/magazine/dn189202.aspx and computerperformance.co.uk/powershell/… how and when do I call that namespace? Or are you suggesting that I use VBA? I'd like to automate this as much as possible and keep it out of Outlook altogether if need be.

Dmitry Streblechenko Over a year ago

I am not sure what you mean by "how and when do I call that namespace". Namespace object is returned from Application.GetNamespace("MAPI").

Aaron Wurthmann Over a year ago

> Namespace object is returned from Application.GetNamespace("MAPI") In what language? PowerShell? Is there an assembly I have to load?

Aaron Wurthmann Over a year ago

C:\..\scripts\ps>_ Application.GetNamespace("MAPI") Application.GetNamespace : The term 'Application.GetNamespace' is not recognized as the name of a cmdlet, function, script file, or operable program.

Aaron Wurthmann Over a year ago

Reading blogs.technet.com/b/heyscriptingguy/archive/2009/12/17/… now, hmmm

|

Eric Aya · Accepted Answer · 2018-10-01 12:07:45Z

0

$ol = New-Object -comObject Outlook.Application

$mail = $ol.CreateItem(0)
$mail.Subject = "Top demand apps-SOURCE CLARIFICATION"
$mail.HTMLBody="<html><head></head><body><b>Joseph</b></body></Html>"
$mail.save()

$inspector = $mail.GetInspector
$inspector.Display()

Just replace the html content in the body session, it will open as a draft mail in outlook.

edited Oct 1, 2018 at 12:07

Eric Aya

70.2k36 gold badges190 silver badges266 bronze badges

answered Oct 1, 2018 at 8:59

Joseph M.G.

312 bronze badges

Collectives™ on Stack Overflow

Using PowerShell to Send a Mail Template with embedded Pic

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related