Hey Guys,
Just wanting to know how to email some data in a spreadsheet in a table in the body of a CDO email.
Ive got the cdo script etc just duno how to get a table in the body like in this for outlook: https://groups.google.com/forum/#!to...os/JiI2CNDfTUg
Any help would be great!
Hi, 13lack13lade,
maybe have a look at Sending mail from Excel with CDO. You can download a sample workbook with the codes from there. If you want to copy the code to another project please make sure you copy Function RangetoHTML(rng As Range) as well.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
hey HaHoBe,
Thanks for that, ive got it working however it just sends as though it was in a table and doesnt look the best, is there a way to actually send it in a table? or is that not possible.
Hi, 13lack13lade,
why not consider to send an attachment with that particular part as a workbook? That would certainly meet your request. Using CDO I doubt any result you want to be possible (might be proven wrong though).
Ciao,
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks