+ Reply to Thread
Results 1 to 10 of 10

Raplace Variables in HTML template With values from excel

  1. #1
    Valued Forum Contributor Steffen Thomsen's Avatar
    Join Date
    10-15-2010
    Location
    Kolding, Denmark
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    953

    Raplace Variables in HTML template With values from excel

    Hi

    I have the a problem for which i need some help.

    Please Login or Register  to view this content.
    What i need is something in the code that replaces a variable in the HTML Template [FirstName] with the Name in column A.

    Any help is welcome

    Steffen Thomsen
    Last edited by Steffen Thomsen; 11-18-2010 at 11:28 AM.

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Raplace Variables in HTML template With values from excel

    You can always open that HTLM-file and change anything you like in it, save it and use it as an HTMLbody

    Please Login or Register  to view this content.



  3. #3
    Valued Forum Contributor Steffen Thomsen's Avatar
    Join Date
    10-15-2010
    Location
    Kolding, Denmark
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    953

    Re: Raplace Variables in HTML template With values from excel

    Hi snb.

    Thats a heavy procedure when going threw long mailing lists.

    I could try it though.

    Steffen Thomsen.

  4. #4
    Valued Forum Contributor Steffen Thomsen's Avatar
    Join Date
    10-15-2010
    Location
    Kolding, Denmark
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    953

    Re: Raplace Variables in HTML template With values from excel

    Hi again snb.

    I've tried applying your code, theres a problem though.

    After it's been modified it has to be saved under a different name and the be called back as the body for the mailtext, then delete the file again.
    And keep going threw the loop.

    Steffen Thomsen.

  5. #5
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Raplace Variables in HTML template With values from excel

    Please Login or Register  to view this content.
    I assume: firstname in column A
    emailaddress in column B
    Last edited by snb; 11-17-2010 at 10:20 AM.

  6. #6
    Valued Forum Contributor Steffen Thomsen's Avatar
    Join Date
    10-15-2010
    Location
    Kolding, Denmark
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    953

    Re: Raplace Variables in HTML template With values from excel

    Hi again snb

    Getting a compile error on the following

    Please Login or Register  to view this content.
    Steffen Thomsen

  7. #7
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Raplace Variables in HTML template With values from excel

    Improved code in last post.

  8. #8
    Valued Forum Contributor Steffen Thomsen's Avatar
    Join Date
    10-15-2010
    Location
    Kolding, Denmark
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    953

    Re: Raplace Variables in HTML template With values from excel

    Hi again snb.

    There's some of your code i dont understand fully understand and cant implement into my code.

    If it's not to much to ask, would you combine the 2 codes and put in some explenation for your part off the code?

    Thanks in advance

    Steffen Thomsen.
    Last edited by Steffen Thomsen; 11-17-2010 at 10:51 AM.

  9. #9
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Raplace Variables in HTML template With values from excel

    implementing in ?

    I already implemented it in yours.

  10. #10
    Valued Forum Contributor Steffen Thomsen's Avatar
    Join Date
    10-15-2010
    Location
    Kolding, Denmark
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    953

    Re: Raplace Variables in HTML template With values from excel

    Hi again snb.

    My bad...
    I set it up badly, it works like a charm.
    Nicely done.
    Care to educate me a bit on the code you made?

    Steffen Thomsen.

+ 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