+ Reply to Thread
Results 1 to 4 of 4

Template & Attachment - Send with Excel Macro

  1. #1
    Registered User
    Join Date
    04-23-2015
    Location
    Ahmedabad
    MS-Off Ver
    2013
    Posts
    2

    Question Template & Attachment - Send with Excel Macro

    hello All,

    below is my excel data and i want to send email to use this information can help me to create macro for this.. ..

    let me know if you need more information on the same. Sample image also attached.




    -----------------------------------------------------------------
    |To |CC |Template Location |Attachment
    -----------------------------------------------------------------
    |abc@abc.com |xyz@xyz.com |C:/1.oft |C:/1.xls
    -----------------------------------------------------------------
    |test@test.com |help@help.com |C:/2.oft |C:/2.xls
    -----------------------------------------------------------------


    thanks in advance.

    amit bhatt
    Attached Images Attached Images
    Last edited by amitbhatt; 05-05-2015 at 05:25 PM. Reason: forget to attach image

  2. #2
    Forum Contributor
    Join Date
    09-26-2014
    Location
    Moscow, Russia
    MS-Off Ver
    MSE 10, MSE 13
    Posts
    179

    Re: Template & Attachment - Send with Excel Macro

    Good time of day, amitbhatt!

    I've solved very similar task on Russian forum. In the attachment you will find macro which allow you to form email via Excel with pictures and attachments. Code is nicely commented, so it is almost easy to modify for your needs.

    Hope this sample will help. Please ask if you have additional questions.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Best wishes and have a nice day!

  3. #3
    Registered User
    Join Date
    04-23-2015
    Location
    Ahmedabad
    MS-Off Ver
    2013
    Posts
    2

    Re: Template & Attachment - Send with Excel Macro

    Quote Originally Posted by Rioran View Post
    Good time of day, amitbhatt!

    I've solved very similar task on Russian forum. In the attachment you will find macro which allow you to form email via Excel with pictures and attachments. Code is nicely commented, so it is almost easy to modify for your needs.

    Hope this sample will help. Please ask if you have additional questions.

    Please Login or Register  to view this content.
    so difficult for me to edit this kind of macro. can you help me to get perfect result as per my data ..

  4. #4
    Forum Contributor
    Join Date
    09-26-2014
    Location
    Moscow, Russia
    MS-Off Ver
    MSE 10, MSE 13
    Posts
    179

    Re: Template & Attachment - Send with Excel Macro

    Not sure if I have enough time to rebuild it completely. I will try but no promise may be made. Anyway I'm open for specified technical questions.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Send excel file as attachment using gmail in macro?
    By fourmurphys in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-20-2019, 09:21 PM
  2. Macro to send an attachment via Outlook from excel
    By dobracik in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2014, 04:32 AM
  3. [SOLVED] Macro to send a pdf attachment via outlook from excel
    By Josiah in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-26-2013, 02:17 PM
  4. VBA Code: MACRO to send lotus notes email with excel attachment
    By FLani in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2013, 10:23 AM
  5. Excel Template using "send to" as attachment
    By Dreammy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-28-2007, 05:50 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1