Hello everyone,
I'm new to the forum and thought I would jump right in with a VBA question! I've no VBA coding experience, but I have an issue that can be solved using VBA code.
I have an excel file with multipe rows....
Each row has multiple columns, last column contains an e-mail adress
What I want to achieve is the following:
-> I want a mail to be created with all rows containg data for each mail adress <-
Let us have an example....
We have an xlsx with 100 rows, containing Columns A to F, with column F being the column containing the email adress.
Presuming that mail adress for Row 2 to 10 is similar, then there should be a copy of A2 to E10 into the body of the mail
Following range selection should be until the new mail adress changes ( presuming this would be on row 25, then data range should be A11 to E25)
I searched for some help on the net, and allready found out that
-> 'ActiveSheet.Range("A2:F100").Select' will give me a fixed range, being all my data.
-Mailcan be ent using this :
ActiveWorkbook.EnvelopeVisible = True
With ActiveSheet.MailEnvelope
.Introduction = "Body")
.Item.To = "[email protected]"
.Item.Subject = "Title")
.Item.Send
But that will be the only thing I know.... I have got no clue how to do this.
If anyone could be of any assistance, Any help or hints will be very much appreciated .
Thanks in advance!!
Ruben
Please find an example in attachments :-)
Bookmarks