rangetohtml

Hi guys, I am trying to use Range to HTML function but i want the email to be sent from another account I have on my server. however, Whenever I run it, it sends from my main account. anyway around this? thanks On Error Resume Next With OutMail .From = "contact@coachnil.com"...

This is my first post so please bear with me. I've recently started using VBA mostly by searching for what I need and copying code that fits. I have a sheet that is fillable and uses checkboxes to select certain data. I have a macro that takes the range of data and creates the email with a...

Hi Team, I am stuck in one scenario where I want to left align the table in Mail. I did this kind of automation in past and this align perefectly but don’t know what I am doing wrong on below code or can anyone have any other solution. Function RangetoHTML(rng As Range) ' By Ron de Bruin...

I'm trying to delete a text between two text lines in a variable "RangeToHtml". I want to delete everything between <![if supportMisalignedColumns]> and <![endif]>, which present only once in the whole code. <![if supportMisalignedColumns]> <tr height=0 style='display:none'> <td width=76...

Hi everyone, I have been using rangeToHtml recently to automate sending out emails, and I am in love with it. i am still trying to learn some things and was wondering if there is a way for me to paste a dynamic range instead of a static range. for example, every month, I send out emails to...

Hi everyone, I have this program which automatically sends out an email to people who match a criteria in my spradsheet. the email includes a message and their corresponding row. is there a way for me to also include the table header as well? this is what I have: With OutMail .To =...

Hi all, I currently use Ron de Bruin's RangetoHTML(rng) code to send information via email. It has worked perfectly well for a long time and has just stopped working. The range will open as a new sheet and not publish this to the email body. Could this be a problem with using Outlook 16 on a...

Hello Internet, Hoping to get some help with this. I've created a daily sales recap report for my company that e-mails automatically every morning. This is done with VBA, and I use RangetoHTML to get the tables into the e-mail. This works great when viewed on a desktop via Outlook or webmail...

Hi, I have a sheet with a table. The cells of the table has a formula to create hyperlink for them. this formula operates on the content from another 2 sheets. I am copying the resultant table and trying to retain the hyperlink, but as i found out the RangetoHTML function does not retain...

Hi All, I am in desperate need of assistance. I have a macro that sends out ~200 reports on a daily basis, but it runs very slow because it calculates every time it hits the .Publish (True) line in Ron de Bruin's RangetoHTML function. Is there something I can add so that it will only...