+ Reply to Thread
Results 1 to 1 of 1

find and replace text in outlook template.oft

  1. #1
    Registered User
    Join Date
    01-31-2013
    Location
    London, england
    MS-Off Ver
    Excel 2010
    Posts
    1

    find and replace text in outlook template.oft

    Hi

    I've written some code based on Ron de Bruin's example of creating a mail item to send, but I changed it to open an outlook template instead. Everything works fine, except that I can't get the .body = replace line to do anything - it doesn't error, it just does nothing at all. I was wondering if anyone can see why this is? I want it to find the "<< contact >>" in the testtemplate.oft and replace it with the value from the specified sheet/cell.

    Code:

    Please Login or Register  to view this content.
    I'm sure it's a simple thing that I'm overlooking. I'm just not that good with the old VB is all.

    Any help greatly appreciated.

    Cheers

    rbbr
    Last edited by rbbrman; 08-06-2013 at 09:50 AM.

+ 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. Replace text in Outlook OFT file from excel
    By BT777 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2013, 02:05 PM
  2. find in excel replace in word: find/replace text in text boxes and headers
    By dean.rogers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-10-2012, 12:40 PM
  3. Creating a 'find and replace' template
    By Payroll in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2009, 06:31 PM
  4. Find & Replace Template
    By Bandit Country in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-07-2008, 01:31 PM
  5. [SOLVED] Where can I find an excel template for creating Outlook contacts
    By Jc777 in forum Excel General
    Replies: 1
    Last Post: 07-25-2006, 05:10 PM

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