+ Reply to Thread
Results 1 to 2 of 2

Possible to build a macro to generate a basic e-mail template with user defined fields?

  1. #1
    Registered User
    Join Date
    06-07-2017
    Location
    Canada
    MS-Off Ver
    Microsoft Office 2016
    Posts
    9

    Question Possible to build a macro to generate a basic e-mail template with user defined fields?

    Hi everyone,

    Please see the attached image for reference.

    I have to send out repetitive e-mails like this to different people all the time. I generate data on excel essentially and have to include it in the e-mail. If you look at the following image, you should be able to understand what I mean.
    Is there anyway I can generate an outlook e-mail template using VBA that will allow me to inject data using Excel? I will not necessarily only have 1 or 2 items to include in each e-mail, on occasion, I can have up to 10 lines of items even.

    I am new to VBA but have automated tasks before. I've been googling and searching on youtube for keywords that relate to outlook and user defined templates to no avail.

    Could you please point me in the right direction?

    Snipsnipvba.PNG

  2. #2
    Valued Forum Contributor
    Join Date
    08-07-2014
    Location
    Quito, Ecuador
    MS-Off Ver
    Excel 2016 & 365, Windows 10
    Posts
    511

    Re: Possible to build a macro to generate a basic e-mail template with user defined fields

    You should check this page :

    http://www.rondebruin.nl/win/section1.htm
    Barriers are there for those who don't want to dream

+ 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. Generate excel reports depending on user defined values
    By Parth007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2016, 03:01 AM
  2. How to build a dynamic matrix table with user defined no.of rows and no.of columns
    By santhosh51 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-20-2013, 03:58 AM
  3. Importing csv files to task list with user defined fields
    By jcranst in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2012, 10:59 AM
  4. User defined function to evaluate time fields
    By Smallies in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-30-2011, 12:31 AM
  5. "User-defined type not defined" error when trying to send e-mail
    By SupperDuck in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-02-2006, 02:40 AM
  6. [SOLVED] Fetching user-defined fields from Outlook
    By Marcus Langell in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-13-2005, 07:06 AM
  7. user-defined chart template location
    By simon in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-12-2005, 12:05 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1