Date from Excel into Outlook

Syed Iqbal

New Member
Joined
Sep 15, 2002
Messages
5
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

New Member
Joined
Sep 15, 2002
Messages
5
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.
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

dk

MrExcel MVP
Joined
Feb 15, 2002
Messages
2,942
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,832
Messages
5,598,360
Members
414,233
Latest member
WolverineNurse

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top