+ Reply to Thread
Results 1 to 10 of 10

Macro to send mail via outlook

  1. 06-19-2013, 12:16 AM #1
    dhammdip17a
    dhammdip17a is offline
    Registered User
    Join Date
    06-11-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    9

    Smile Macro to send mail via outlook

    Hi,

    A b c d
    Custmer Name Customer Email Id Order No Shipment tracking No
    abc [email protected] 123 456
    xyz [email protected] 789 345


    I do have this data in excel file,
    I wanted a Macro from which i can send direct mail via outlook,

    mail should be,

    Dear abc,

    Your order no. 123, has been dispatch by shipment no. 456.

    Thanks


    Please help me to do this.
    Reply With QuoteRegister To Reply
  2. 06-19-2013, 12:21 AM #2
    HaHoBe
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Macro to send mail via outlook

    Hi, dhammdip17a,

    Mail a message to each person in a range will deliver an example for that.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you
    Reply With QuoteRegister To Reply
  3. 06-19-2013, 12:27 AM #3
    dhammdip17a
    dhammdip17a is offline
    Registered User
    Join Date
    06-11-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Macro to send mail via outlook

    Hi Ciao,
    Thank You so much for your help.
    but how can i add more rows?
    and how can i edit a subject for each mail?
    is it possible that i also mention subject in excel file and macro will send that?
    Please help for this.

    Thanks
    Dhammdip
    Reply With QuoteRegister To Reply
  4. 06-19-2013, 12:36 AM #4
    HaHoBe
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Macro to send mail via outlook

    Hi, dhammdip17a,


    Quote Originally Posted by dhammdip17a
    but how can i add more rows?
    Quote Originally Posted by RDB
    The Macro will loop through each row on the Activesheet

    Quote Originally Posted by dhammdip17a
    and how can i edit a subject for each mail?
    Substitute
    Please Login or Register  to view this content.
    with
    Please Login or Register  to view this content.

    Quote Originally Posted by dhammdip17a
    is it possible that i also mention subject in excel file and macro will send that?
    Add another column to your data if you feel like the necessity and rely on it. Say the Subject is in Column E
    Please Login or Register  to view this content.
    You should check that there is a value in that cell otherwise give some standard subject in an If-Else-Statement.

    My name is definitely not Ciao.

    HTH,
    Holger
    Reply With QuoteRegister To Reply
  5. 06-19-2013, 12:40 AM #5
    dhammdip17a
    dhammdip17a is offline
    Registered User
    Join Date
    06-11-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Macro to send mail via outlook

    Hi "Holger"

    I am sorry for your Name

    But thank you so much for your help.

    Regards,
    Dhammdip
    Reply With QuoteRegister To Reply
  6. 06-19-2013, 12:42 AM #6
    HaHoBe
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Macro to send mail via outlook

    Hi, Dhammdip,

    donīt worry about my name - I hope you can get along with the information supplied.

    Ciao,
    Holger
    Reply With QuoteRegister To Reply
  7. 06-19-2013, 01:52 AM #7
    dhammdip17a
    dhammdip17a is offline
    Registered User
    Join Date
    06-11-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Macro to send mail via outlook

    Hi Holger,

    Macro is working fine. Thanks.

    Require one more help,

    I wanted to add hyper link in RAW "F" and it has to be display as "Click Here".

    Is this possible.

    Please suggest.

    Regards,
    Dhammdip
    Reply With QuoteRegister To Reply
  8. 06-19-2013, 02:13 AM #8
    HaHoBe
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Macro to send mail via outlook

    Hi, Dhammdip,

    the hyperlink should lead to anything (this is what would be part of the hyperlink address). You could record a macro inserting a hyperlink to get the structure of how to embed it into the table.

    Ciao,
    Holger
    Reply With QuoteRegister To Reply
  9. 06-19-2013, 06:52 AM #9
    mohandeck
    mohandeck is offline
    Registered User
    Join Date
    06-14-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Macro to send mail via outlook

    Hi Holger,

    Can pls provide script to add attachment and signatures pls...

    Regards,
    Mohan.Y
    Reply With QuoteRegister To Reply
  10. 06-19-2013, 02:40 PM #10
    HaHoBe
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Macro to send mail via outlook

    Hi, Mohan,

    please do not post you rquestion in the thread of any other member - please start yoour own thread.

    Insert Outlook Signature in mail and Mail a different file(s) to each person in a range may help.

    Ciao,
    Holger
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1