sending email from excell

[kenpachi]

Hi everybody

Here's my problem if somebody can help me:

Each month I must send a bills to the customers on a list in an excel sheet.

I've got the:
-email address Cell(A1).value
-email subject (Bill for the month of "selectedmonth") Cell(B1).value
-email text to display (Here is your bill for the last month") Cell(C1).value
-url of the "monthlybill.xls" (converted to .mht) Cell(d1).value

Each of the cells will vary according to the row of the selected customer.

My problem is about the function follow hyperlinks, I can't seem to make the values "texttodisplay" and "attachement" to work.

Can someone help me

Thanks in advance.

 

[RuralGuy]

Maybe something in this link will help.

 

[HaHoBe]

Hi, kenpachi,

if VBA is okay: Example Code for sending mail from Excel.

Ciao,
Holger