+ Reply to Thread
Results 1 to 3 of 3

Create Outlook Template (.oft) from Excel file

  1. #1
    Registered User
    Join Date
    07-02-2013
    Location
    Harrisburg, PA
    MS-Off Ver
    Excel 2013
    Posts
    3

    Create Outlook Template (.oft) from Excel file

    I have a section of an excel form that I need to populate with text from a word document. It could be 3 lines or 300 depending on the size of the work order. How can I build a template that will allow me to paste the information into a merged cell section (1 row by 6 columns) that would automatically resize showing all of the pasted text? The reason I have to use excel is I have sections of the document where I use vlookup to populate fields. After I have everything populated I then send on via email with the excel form in the body of said email. I was thinking of saving a working form of the spreadsheet as an outlook template but don't think that would work..........Any suggestions?

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Create Outlook Template (.oft) from Excel file

    do you have a sample file for your merged cell issue?

    re: outlook bit

    you can either export the table into email and let excel send email
    or you can capture table as image and send it as part of email
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    07-02-2013
    Location
    Harrisburg, PA
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: Create Outlook Template (.oft) from Excel file

    What I'm trying to do is paste text into the merged cells below (row 2) and have it automatically resize so that all the text, no matter if it's 3 lines or 300, will be seen and keep it's formatting from the source. IS there a way to do this other than merged cells? I tried a text box but have to manually resize it to work. That isn't feasible as it needs to be simple and automatic or the users won't use it.

    Example.png
    Last edited by dkeller33; 11-25-2014 at 03:45 PM.

+ 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] automatically fill template and create Outlook mail
    By Bax in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-18-2013, 05:46 AM
  2. Macro to create an e-mail using an Outlook Template and add an attachment
    By hsarro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-06-2012, 12:25 PM
  3. Replies: 8
    Last Post: 10-08-2011, 07:39 AM
  4. Replies: 1
    Last Post: 07-16-2009, 09:14 PM
  5. Create Outlook Distribution lists (default txt file) with excel
    By nicolascap in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-03-2006, 12:40 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