Date from Excel into Outlook

[Syed Iqbal]

Hi, I am new here.
I have a incoming time sheet in Excel with data of each month in rows.
I have created a macro which can send emails to all the intended users.
The problem is that I am not managing to copy the selected row (text) as a body text of outlook message.
Any suggestion are welcomed.

 

[Syed Iqbal]

On 2002-09-16 05:33, dk wrote:
Hi,

Look at the link that XL-Denis posted. It shows you how to send an email through Outlook with the body of the message being a specified range.

If you have any problems adapting the code then post back and either me or someone else should be able to help.

Hi Dan , Thanks a lot
I tried the range example and at line :
ActiveWorkbook.PublishObjects.Add(xlSourceRange, "C:\report.htm", rngeSend.Parent.Name, rngeSend.Address, xlHtmlStatic).Publish True

I am getting an error message which says:-
Run time error '1004': Application defined or object defined error

I have tried to see the specific help about this error without luck or you can say not finding the solution.

 

[dk]

Hello,

First of all, there should only be one back slash character (this board doubles up back slashes). However, the code should still work. Secondly, which version of Excel are you using? This code works in Excel 2000 but I haven't tested it in Excel 97.

Thirdly, post your code as it is so someone else can try it.