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 =...
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,
.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,
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 kaushik,
Please find the below file link
https://www.box.com/s/ea0uxjn2ko6q8xrebjuh
this is sample data
if i select Category A then excel should display 3 option Daily, Weeekly & monthly according to that after selecting one of the option (Daily, Weeekly & monthly) data graphs will be...
I have 15 graphs on Daily, weekly & monthly data for 5 different categories.
pl help how to display the graph categories wise & Daily, weekly & monthly.
Means if i select the category_1 & then choose the daily the sheet display only daily graph
....
Regards,
Supriya
Hello,
Anybody has the template of dashboard which has the graph on particular range (last updated range)
E.g. Graph always show the last fifteen days data.