Open saved Outlook mail and reuse it as a mould

[Mollethewizard]

The code for recipients and attachments is finished but how to open a previously saved mail I can’t figure out. I’ve looked around and have not found anything useful.

Thanks beforehand

Christer

 

[Mollethewizard]

If I save a mail as a draft how can I reuse it thats what I ment.

 

[JustinEzequiel]

I only have Outlook 2003 here but...
Why not save as "Outlook Template (*.oft)"
Then
File->New->Choose Form...
Look In: User Templates in File System
then pick the template you saved previously

 

[JustinEzequiel]

quicker yet, if you save your "Outlook Template"
in an accessible location e.g., your Desktop,
then you can right click on the icon and choose New

 

[Mollethewizard]

Thanks for the advise - but I'am trying to figure out how to solve it using some VBA-code to open a previosly saved draft and then hang on code for recipient etc and send it. The code is in a Word-document.

Christer

 

[JustinEzequiel]

what do you have so far?
where are you stuck?

Dim oa As Object
Dim mi As Object

Set oa = GetObject(, "Outlook.Application")
Set mi = oa.CreateItemFromTemplate("C:\Users\justin\Desktop\foobar.oft")
mi.To = "somebody@somewhere.com"
mi.Subject = Now() & " - " & mi.Subject
mi.Send