Recent content by Supriya

Hi SirJB7, I Already tried that code but not getting how to execute that code coz in that coding they are using powerpoint application. can u pl help to understand the below code from provided link Sub copyRangeAsBitmapToClipboard() Dim appPPT As Object Set appPPT =...

Hi all, Pl guide for VBA code pasting the selected excel range in outlook body as bitmap image. Regards, Supriya

See the attached file with macro code

thank for reply. but problem still not resolved. after pasting the cell range in outlook the table's auto row height & coulumn width is not possible to set through code pl assist. Regards, Supriya.

Deal all, I have one excel file with different division. i just want to paste the data in outlook division wise. kindly suggest for passing only visible cell range to 'rngtohtml' function which is used for coping data from excel to outlook. Regards, Supriya.

Hi Luke, Yes problem has been resolved. I have one more question... i want to change font name & size in mail Actually my mail's contents are in Calibri font of size 10. but for below .HTMLBody = "Dear Team," & vbCrLf & vbCrLf _ & "Kindly find the update on MTD & YTD Unit Wise...

" "

Hi , Thanks to all who help me. thank you so much i was tried & is working now my macro. Regards, supriya

It displays Dear Team, Kindly find the update on MTD & YTD Unit Wise Performance as on 21/08/2013

Hi, .HTMLBody = "Dear Team," & vbCrLf & vbCrLf _ & "Kindly find the update on MTD & YTD Unit Wise Performance as on " & DT & " " & vbCrLf _ & RangetoHTML(rng) & vbCrLf _ Here is my code format supriya.

Hi bobhc, Thank you very much supriya.

Hello, I was using vbCrLf function in macro but the code was not executed for this function. The text is not moving on next line. pl help. Supriya.

Hi ThrottleWorks, Thanks for the help. I already have that link but it does not help to solve my problem. Regards, Supriya.

Hi, I have data of 10 cities with respective managers. I just want to send the emails to them with the excel dashboard & fixed body messages in mail body copy. Their are two excel dashboard on different sheets. While sending mail just forwarding both dathboard citywise to respective manager...

Hi Sreekhosh, sorry for late reply. Thanx a ton. this looks very nice. Regards, Supriya A.