+ Reply to Thread
Results 1 to 3 of 3

Email macro, include variable in body & add default outlook signature

  1. #1
    Registered User
    Join Date
    05-10-2013
    Location
    notts
    MS-Off Ver
    365
    Posts
    24

    Email macro, include variable in body & add default outlook signature

    Hi all,

    hopefully someone can point me in the right direction! How do you include a variable in the HTML body for an email generated via macro? I have the current selection of cells stored in a variable SelRange, my code looks like:

    Please Login or Register  to view this content.
    I've tried a few combinations but I only dabble with VBA so im not sure where Im going with this problem.

    Second request, does anyone know how to include the outlook default signature to the email when using HTML body? This seems to delete it as apposed to using plain text email.

    Thanks in advance!

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Email macro, include variable in body & add default outlook signature

    Take a look at these pages.
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    05-10-2013
    Location
    notts
    MS-Off Ver
    365
    Posts
    24

    Re: Email macro, include variable in body & add default outlook signature

    Perfect, just the help I needed, both problems solved

+ 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