Added (jobs): Automating Emails from Excel

[Len Piwowar]

Correction:
Move ThisWorkbookfolder Declarations, Dim statements
Dim CustomerAddress As String
Dim CustomerMessage As String

To Module1 - General - Declarations (Top of Module)
and change statement to public
Public CustomerAddress As String
Public CustomerMessage As String

Dale,
You should also be able to within reason name the headers any name you choose. In the proceedure you'll Find Sort Method with Header:=xlGuess which means:

Header Optional Variant. Specifies whether the first row contains headers. Can be one of the following XlYesNoGuess constants: xlYes, xlNo, or xlGuess. Use xlYes if the first row contains headers (it shouldn't be sorted). Use xlNo if there are no headers (the entire range should be sorted). Use xlGuess to let Microsoft Excel determine whether there's a header, and to determine where it is, if there is one. The default value is xlNo.

Row 1 contains Headers
column A = E-mail Addresses
Column B = Name Info

After you open the csv file in excel you could insert two new columns at A and B and setup formulas and data as shown in attachment then after you move the Dimension statements as described in this post try the macro.


Hope this helps
Len