VBA: Send Email

February 8th, 2005 | Categories: VBA | Tags: , ,

maillinksA couple links for sending email via VBA:

Different Ways to Take Advantage of the E-mail Features of Excel – Knowledge Base Article

DataPig Video Tutorial – Just a few lines of code.

Andrew on Excel and Email – Code to Email the Active Sheet and Active Book


  1. Mauro
    March 15th, 2005 at 08:38
    Reply | Quote | #1

    Fu

  2. Abhishek
    May 4th, 2010 at 10:38
    Reply | Quote | #2

    Dear Team,

    I need to send the statements as emails prepared from a PIVOT table by doing some formatting on it. How can i automate it with the help of MACRO.

    I can create Macro for formatting purpose but i can not do the same for sending these statement, as i does not belongs to IT background.

    Please help…