Hi all,
I've wrote a function that allows me to insert a certain range to the body of an email. This email is composed in the code, too.
So far I am able to build the emails body as plain text. Does anybody now how to retain the cell format also (colors, font size, border styles, ...)?
Thank you very much!
Please Login or Register to view this content.
Kind regards,
Lloyd
Lloyd
Wouldn't you need to use a rich text field?
If posting code please use code tags, see here.
Hi Norie,
sorry, I don't understand what you mean.
I now know I need to convert my excel range into HTML format, to represent it the same way like in excel. But I don't know how to do this.
Any ideas?
Lloyd
Try
.htmlbody = strtext & .htmlbody
or RangetoHTML might work
.htmlbody = rangetoHTML(your range)
Last edited by djdjdj; 01-31-2014 at 06:19 AM.
This line throws an error:
Run-time error '438':
Object doesn't support this property or method
What if you add:
Please Login or Register to view this content.
Have a look at Ron de Bruin's web site. He has a function to convert a range to HTML ... well functions to do pretty much anything with email.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Linethrows an error:Please Login or Register to view this content.
Compile error:
Sub Function not defined
Is rangetohtml member of a certain reference?
I think that RangeToHTML is the RdeB routine to which I referred. Go get it ...
@ TMShucks yes it is, I got the code from a colleague, great stuff
@Lloyd, sorry I forgot to give you the function. Here's the link to Ron de Bruin's full code including the range to html function
http://www.rondebruin.nl/win/s1/outlook/bmail2.htm
Hmm,
this code runs through but the emails body is empty.
@TMShucks
What is the .nsf File?Please Login or Register to view this content.
It looks like storing some user specific data, right?
I found several of this files on my machine, but non that points out it contains some user specific data.
Please Login or Register to view this content.No idea. Where did you get that code from? All you need is RdeB's function. See below with some examples.What is the .nsf File?
Please Login or Register to view this content.
Examples:
Please Login or Register to view this content.
Regards, TMS
Nothing doing, the body is always empty. Do I gloss over anything?
Please Login or Register to view this content.
Am I right in thinking that this is Lotus Notes that you're using? I have no knowledge of Notes and I cannot test your code.
But, there are examples on RdeB's site, specifically aimed at Lotus Notes users.
http://www.rondebruin.nl/win/s1/notes/notes6.htm
And Google: ron de bruin lotus notes to get many other examples that might be transferrable into your code.
Sorry.
Regards, TMS
The code in post #1 is for Lotus Notes not Outlook.
Sadly, I just saw "copy range to email body".
I then picked up from post #7 which refers to rangetohtml (I think our posts overlapped) and provided the link.
There are clearly much better examples on RdeB's site specifically for Lotus Notes.
At this point, I will quietly drop out and fade into the background ... where I will watch with interest.
Regards, TMS
TMS
I think that last link you posted might be what the OP is looking for, at first glance it does appear to work by pasting to the body of the email.
I was looking for something like that but forgot Ron DeBruin had pages covering Lotus Notes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks