+ Reply to Thread
Results 1 to 6 of 6

Help needed with tweaking Ron de Bruin's mail code

  1. #1
    Registered User
    Join Date
    04-19-2012
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2010
    Posts
    5

    Help needed with tweaking Ron de Bruin's mail code

    Hi ,

    I have adaped Ron de Bruin's mail code and am in the process of creating a mailer tool.

    While i can now create an email and pass the message body, i am in need of help to finish the work.

    What i have is a 100 rows of data with email id

    I need to filter and pass each row which is associated with the email id in the body of the mail

    Hi,

    Please Note



    Name Email
    Andy abc@abc.com

    and the next as
    Hi,

    Please Note



    Name Email
    Sandy xyz@yxyz.com


    so and so forth.

    Any help is greatly appreciated! Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,747

    Re: Help needed with tweaking Ron de Bruin's mail code

    Cross posted here
    http://www.mrexcel.com/forum/showthread.php?t=630554
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Registered User
    Join Date
    04-19-2012
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Help needed with tweaking Ron de Bruin's mail code

    Hi,

    Yes, it is so, i am trying to close this last bit as I need to implement it very urgently, and the final piece is evading me or I am just nt able to adapt it!

  4. #4
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,747

    Re: Help needed with tweaking Ron de Bruin's mail code

    Hi andy_iyeng

    Yes, well, you need to disclose that...Rule #8

    8. Don't cross-post without a link. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the URL from the address bar in your browser) to the cross-post. Expect cross-posts without a link to be closed

    Provide the Link...perhaps you'll get some hits.

  5. #5
    Registered User
    Join Date
    04-19-2012
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Help needed with tweaking Ron de Bruin's mail code

    Hi Jas,

    Gotcha! thanks!

  6. #6
    Registered User
    Join Date
    05-27-2013
    Location
    bangalore
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Help needed with tweaking Ron de Bruin's mail code

    Hi,

    This is very good forum and helping a lot in doing automation….

    I have a query

    How can I insert particular data/text from excel cell in between the text which is already in the mail body.

    Ex:

    Col A Col B Col C
    xyz 28 Name1
    ABC 29 Name2
    DEF 30 Name3

    Email body :

    In First email -> My name is “xyz” and my age is “28” and bla…bla………and send this to “contact1”.
    In Second email -> My name is “ABC” and my age is “29” and bla…bla……… and send this to “contact2.

    This has to loop for all rows get the data and display in outlook email.

    So if I click once it has to generate all the emails for all the rows in excel.

    I have attached the file//.

    Can you please help me on this.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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