+ Reply to Thread
Results 1 to 18 of 18

How can I forward an email, remove FW/RE, delete body and insert signature

  1. #1
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    How can I forward an email, remove FW/RE, delete body and insert signature

    So I found multiple macros that do what I want, so I have to combine them, but I am unfamiliar with Outlook compared to Excel. Can someone help out?

    Please Login or Register  to view this content.

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

    Re: How can I forward an email, remove FW/RE, delete body and insert signature

    hmmm if your deleting body...what are you actually forwarding?
    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
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: How can I forward an email, remove FW/RE, delete body and insert signature

    lol. The attachments. I have a report forwarded to me by my team, I review and forward it on.

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

    Re: How can I forward an email, remove FW/RE, delete body and insert signature

    oh *face palm*
    sorry yes of course
    instead of using that array loop i went old school and just did two replace lines

    adapted something i did previously on here, see it works for you
    i cannot test for you in outlook...our company has blocked macros on outlook now

    Please Login or Register  to view this content.

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

    Re: How can I forward an email, remove FW/RE, delete body and insert signature

    if you find that the subject line has too many double spaces
    you can add another line in to get rid of those too
    something like
    Please Login or Register  to view this content.
    this being the last one of course

  6. #6
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: How can I forward an email, remove FW/RE, delete body and insert signature

    This works beautifully, the only thing I can see is that my signature has our company logo (img) and it says it cannot displayed.

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

    Re: How can I forward an email, remove FW/RE, delete body and insert signature

    http://stackoverflow.com/questions/2...es-to-the-mail

    try mentioned solution here
    sorry cannot test with my current setup

  8. #8
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: How can I forward an email, remove FW/RE, delete body and insert signature

    Thanks, i tried but can't seem to get it to work. If I change the address to the entire path, nothing happens, blank email, no signature. If I do the whole path only, taking out the Environ, same thing. Even going on folder back, doing \Roaming\ causes this.

    it says
    In the .htm file in the signatures directory you can edit the htm file. The pictures are stored as relative path and when you use the code it looses that path so if you use discrete path it will be able to find the pictures. so go into the file and look for any relative paths and make them discrete.

    "/Microsoft/Signatures/picturefile.jpg"

    change that to include the whole path

    "/root/user/blah blah../Microsoft/Signatures/picturefile.jpg"

    This solved the missing image problem for me.

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

    Re: How can I forward an email, remove FW/RE, delete body and insert signature

    i think the issue is this
    Please Login or Register  to view this content.
    maybe skip the whole signature piece and do display first which should open blank email with default signature & picture (presuming you have as current setup)

    Please Login or Register  to view this content.
    basically ron's first code
    http://www.rondebruin.nl/win/s1/outlook/signature.htm

  10. #10
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: How can I forward an email, remove FW/RE, delete body and insert signature

    Getting a variable not defined error and I think it is for the ".HTMLBody = "<br>" & HTMLBody" part

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

    Re: How can I forward an email, remove FW/RE, delete body and insert signature

    try with the extra "."
    Please Login or Register  to view this content.

  12. #12
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: How can I forward an email, remove FW/RE, delete body and insert signature

    that seems to have done it! awesome. thank you.

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

    Re: How can I forward an email, remove FW/RE, delete body and insert signature

    Cheers
    thanks for the rep

  14. #14
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: How can I forward an email, remove FW/RE, delete body and insert signature

    I don't know if just didn't see it or what, but the old email is still being included. It doesn't remove the previous body. Changing the signature to .htmlbody keeps the old body.

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

    Re: How can I forward an email, remove FW/RE, delete body and insert signature

    hmmm not being able to test code makes it slightly harder to give out solutions

    Please Login or Register  to view this content.
    one last try
    ^this grabs signature out of new email and it for later use

    if that doesnt work then my only recourse is to back to original solution but fix the image path (potentially the last post may work for you)
    http://www.vbaexpress.com/forum/show...Outlook-e-mail

  16. #16
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: How can I forward an email, remove FW/RE, delete body and insert signature

    lol. It opens two emails. One new blank email, then the forward, same issue, but on the image error instead of can't be displayed, it says moved or deleted.

  17. #17
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    Re: How can I forward an email, remove FW/RE, delete body and insert signature

    humdingaling, i got it! Altering the data in the .HTM file made it work. WEIRD thing to have to do, but w/e. As of right now it is working. I closed out and reopened Outlook and seems to be ok....

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

    Re: How can I forward an email, remove FW/RE, delete body and insert signature

    oh...forgot to close the new email
    i always like to try/test my solutions before giving them to avoid giving code with small mistakes like this

    Please Login or Register  to view this content.
    ^this should solve the double emails things

    anyway this seemed to not have worked as well

    persistence pays off, hope that solves your issue

    Cheers
    Hum

+ 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. VBA to adjust font in body of email and add signature to email
    By jawirth44 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-14-2015, 08:39 PM
  2. Insert body of email above signature in Lotus Notes
    By ladislav Jakl in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-16-2015, 04:52 PM
  3. Help with email signature VBA not same text size as rest of body
    By Rick23 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-13-2014, 02:40 PM
  4. Insert Lotus Notes Signature In Body Of Email Excel VBA
    By Pierce Quality in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-06-2013, 02:57 PM
  5. Email macro, include variable in body & add default outlook signature
    By promithius in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2013, 09:05 AM
  6. Qutlook email with signature using body message from cell values
    By gmc2k2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2013, 10:11 AM
  7. [SOLVED] Email Body Text & Signature
    By Darrell Lankford in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-07-2006, 12:55 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