Send mails attaching files with HTML body range of content

Hi All,

I am looking for help to send mails attaching files from folder with the body of outlook message in HTML format similar to what is attached in the word document.

Attached excel filr Maisl a different file(s) to each person in a range

The Macro will loop through each row in the sheet and if there is a E-mail address in B
and filenames that exist in the row it will create a mail with this information and send it.

This TRY ME macro will attach the file to each person email in range column B. It is creating mail with the information.

But I am looking for a macro or method how to have the contents from the attached word document to apprear in the body of the outlook email. Please try to run the above TRY ME macro. When it opens the outlook mail message I want the contents of the
word documents in the body of the outlook message. Please help

See attached macro excel file and the word document contents.

Hi Vijay
I can't tell from your code what you're trying to accomplish. It must be in the early stages of development. Is the Word Document an ACTUAL DOCUMENT or is it just an example of what you're looking for to insert into the body of the email?

Hi Vijay

While it's still not clear to me what you're after, the attached incorporates into the email body the contents of what was included in your Word document.

Hi Vijay

In the sub Send_Files, change the line of code that says .Display to .Send as follows:

Please Login or Register  to view this content.

Jaslake,

I don't think that will solve the problem. Outlook is going to intercept every one of the email SEND commands, built-in security. The end result will be the same, except now the macro is stalled until you press OK in Outlook...

@JBeaucaire

I think you may be correct...I see the OP is using Excel 2003 so I'd presume Outlook 2003. I'd forgotten about that security issue with 2003.

I've tested only with Outlook 2007 as that's what I have. Outlook 2007 doesn't present the same issue.

@vijanand1279...Sorry Vijay...I don't have a workaround.

Excel 2007 doesn't have this security feature? You can send emails from Excel into Outlook with no problem? Hmm....

@JBeaucaire

That's correct. Outlook 2007 does not have this issue when sending emails from Excel 2007 or Excel 2000. Outlook 2007 will send immediately without a security message.

Heh, that alone may be reason enough for me to finally upgrade. I just HATE the 2007+ interface.

@JB
Took me a while to get accustomed to it...now I have a bit of a problem navigating back to Excel 2000

Researching another issue I found this link which addresses the Security issue http://msdn.microsoft.com/en-us/libr...ffice.12).aspx