macro to email a list of transaction in form of statement Closed

Question

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

ac3mark · Answer

Good Morning,

I have recently worked on this problem:
https://ccm.net/forum/affich-717183-code-for-the-below-scenario-excel-vba

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!

Macro to email a list of transaction in form of statement

1 response

Similar discussions

Subscribe To Our Newsletter!