+ 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 2010, Windows 10
    Posts
    413

    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)

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