vba to send email using data in fields

123rickfear

Active Member
Joined
Jun 19, 2015
Messages
446
Hi, to those who use vba regularly, I'm sure this is an easy one.

I have an excel spreadsheet with a number of columns.

I currently paste data into email fields to send.

I currently send 14 emails.

some emails contain more values than others, example below.

First email
To D2
Subject "Test Data"
Body first line K2
Body second line B2
Body third line C2


Second email
To D9
Subject "Test Data"
Body first line K9
Body second line B9
Body third line C9
Then repeat lines down to row 14

The cells don't change every month so no need to make it too clever.

Thanks
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Watch MrExcel Video

Forum statistics

Threads
1,095,685
Messages
5,445,946
Members
405,371
Latest member
Joe Zawadzki

This Week's Hot Topics

Top