Send mail to all in range

Please Login or Register  to view this content.

Take the ' away from .send and put a ' infront of .display if you want the email to be automatic

this code does not check if same person has multiple books but will create a single separate email per line 4 until last email in column C

you should really outline this request this in initial question
the coding will be substantially more complicated as it would require extra logic

let me have a think about it i will reply tomorrow

Cheers
hum

i thought of a quick way to do it so i did it today

the list must be sorted by email prior to running

ie you cant have JOhn, alex than john again
Must be john, john, alex or alex, john, john
otherwise it will create 3 emails instead of 2

yes possible but my HTML skill is very limited

need to then change
.body to .htmlbody
replace all the vbnewline with <BR>

then basically have to write the message in HTML
like shown here
https://computerservices.temple.edu/...ng-tables-html

actually looking at the HTML you will have to rewrite the whole logic on how email is populated

Please Login or Register  to view this content.

doesn't look pretty...but it works for single line...would need to revisit logic to make it work for multiple line

will take some time
i am unfamiliar with HTML as well

Dear,

another question...why evry time after running these macro excel freezes?? == these is now "solved"...i noted that if table with e-mail adresses is more than 20 lines excel freezes, is there any way to solve it?

to make it a little bit easier..it is possible to inclued in body of mail only book no (column A) without Name (column B)?

Please Login or Register  to view this content.

managed to wrangle HTML code with Book and Name already
sorry does not look the best but can be fixed thru HTML formatting
things like font, font size, color etc which is all set via HTML

with freezing
not really why what is happening
its probably just excel running thru your macro which tends to freeze once code becomes long

Please Login or Register  to view this content.

Dearj,

thanks for quick reply but I managed to do it myself :D...

but is still not as they wish ...
the table must look like:

table.JPG

with included name....ok these is already done :D

i have tried a lot of options without positive result ..pls help

Can someone help me also with bellow code:

Please Login or Register  to view this content.

i dont know why between

Worksheets("data").Range("O6").Value & "</p>" & _

and

"<p style='font-family:calibri;font-size:12;color:grey'>" & Worksheets("data").Range("O7").Value & "<br>" & _

it puts a empty line..how to solve it? what am I missing?

Hi, forfiett,

maybe look up what

HTML Code: 

stands for in HTML: adding a paragraph which could be seen as adding an empty line.

Ciao,
Holger

Hi, foorfiett,

I didnīt go through all the codes before so I may miss some important things:

HTML Code: 

Ciao,
Holger

Hi Holger,

still not ok ....have tried 1000 different possibilities without result..
The problem now is that font size is set up to 11, but it is 12 for entire mail...why?????

Hi, forfiett,

have tried 1000 different possibilities without result..

Sorry I canīt see any of these in this thread.

One of the first addresses in www. is the site of Ron de Bruin on which you could find a tool called RangeToHTML. I wonder why your search engine hasnīt delivered one of the top articles.


The original problem was about passing the data for the individual mails - I read itīs solved so you should have that part of the code. The following code is putting the data from the sheet Mail into a mail:

Please Login or Register  to view this content.

Itīs essential to copy the foillowing function into either the very same standard module or any other one in the project:

Please Login or Register  to view this content.

And if you are referring to HTML and size Iīm afraid HTML just has about 7 different sizes.

Ciao,
Holger