Macro to email a list of transaction in form of statement

jav_me Posts 1 Registration date Wednesday September 4, 2013 Status Member Last seen September 4, 2013 - Sep 4, 2013 at 07:56 PM
 Blocked Profile - Sep 5, 2013 at 08:35 AM
Hi Excel Pros,

I'm only a rookie when it comes to VBA excel - I have been pulling customer data via an sql link into a spreadsheet - the data for one customer can be up to 25 rows - within that data also includes a column with email addresses.

I would like to write a macro a macro that would allow me to email the data in a tabular format with the headers as per the first row by reference to the email address - when the email address changes it generates a new email.

my rough guess would be to call outlook as application and a loop on the email - but as I pointed out not a wiz in VBA...

Can anyone help - I can send a sample if required

many thanks

1 response

Blocked Profile
Sep 5, 2013 at 08:35 AM
Good Morning,

I have recently worked on this problem:

It has the code for making a mail object within Excel, see if it helps your application.

All of that you ask, has been asnwered here, just not in one post. Take a little from here, a little from there, and now you are a script kiddie too! :)

Have Fun!