+ Reply to Thread
Results 1 to 2 of 2

VBA Signature Font Different Then Body

  1. #1
    Registered User
    Join Date
    09-23-2010
    Location
    NY
    MS-Off Ver
    Excel 2007
    Posts
    35

    VBA Signature Font Different Then Body

    OK, since my original question could not be answered regarding adding a specific font and size'd signature to one of Ron's templates I figured I would try something a little different. Since I know I can change the font and size of the text in a cell, I figured I could create a seperate cell from the body of the email and put the signature in there. This way in the VBA editor I can combine the two, and have the body be the normal size and font, and the signature be the correct (for my company at least) size and font. Exactly how to add this to the mail VBA language I am unsure. Would I just change the code to something like this:

    Please Login or Register  to view this content.
    If that is the case, how can I format what is in that column. Would the formatting script go right after this code that I posted? Thanks guys.
    Last edited by dieseldogpi; 11-24-2010 at 11:27 AM.

  2. #2
    Registered User
    Join Date
    09-23-2010
    Location
    NY
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: Another VBA Mail Question

    OK, I have the signature pulling into the body of the email perfectly with the following code:
    Please Login or Register  to view this content.
    Now I just need to format the cells in column M. Where would this code go? Thanks.

+ 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