default email signature

**bigfishprf** · 07-07-2015, 12:00 PM

I am creating an email from within Excel

With CreateObject("Outlook.Application").CreateItem(0)
                    .To = Sheets("Data").Range("B122").Value
                    .Subject = title
                    .Body = "Please confirm the outcome for" & Chr(13) & _
                    Chr(13) & _
                    "Surname - " & Sheets("Data").Range("B4").Value & Chr(13) & _
                    "Forenames - " & Sheets("Data").Range("B124").Value & Chr(13) & _
                    "Date of Birth - " & Sheets("Data").Range("B10").Value & Chr(13) & _
                     .Display

Is there any property I can use to tell Outlook to use the default email signature when Displaying the new email? I know the user can easily add the signature to the bottom of the mail before sending but it would be easier for them if the default was applied.

Thanks

**Arkadi** · 07-07-2015, 12:06 PM

Not 100% sure but I believe the signature is in the email until you set the .body property, which overwrites.. so try this:

With CreateObject("Outlook.Application").CreateItem(0)
                    .display
                    signature = .Body
                    .To = Sheets("Data").Range("B122").Value
                    .Subject = title
                    .Body = "Please confirm the outcome for" & Chr(13) & _
                    Chr(13) & _
                    "Surname - " & Sheets("Data").Range("B4").Value & Chr(13) & _
                    "Forenames - " & Sheets("Data").Range("B124").Value & Chr(13) & _
                    "Date of Birth - " & Sheets("Data").Range("B10").Value & Chr(13) & signature & _
                     .Display

**bigfishprf** · 07-07-2015, 02:01 PM

Arkadi, many thanks for your reply. That makes perfect sense but just adding the keyword & signature doesn't seem to do the trick. You are perfectly correct that the .body statement overwrites the signature as if I comment that out then the email displayed includes the signature. Any more suggestions gratefully received

Cheers

Paul

**Arkadi** · 07-07-2015, 03:25 PM

Paul, did you try the code I posted? On my end using that code produces an email with signature. please note it is not just a keyword, it was first assigned a value at the top, then added back at the end. I edited that post to show the changes I made in red.

**bigfishprf** · 07-07-2015, 04:05 PM

Arkadi. Many thanks. I had missed the first part of the amendment you suggested. Apologies for that. It does work now I put that in with one minor exception. I have a jpeg within the signature which shows up when I create a normal email but is absent when I create the email from Excel. I can live with it as is but if you have any further suggestions that would be very much appreciated. Once again thanks very much for your assistance.

Paul

**Arkadi** · 07-07-2015, 07:45 PM

I'll get back to you on that in the morning, I do have an idea

**bigfishprf** · 07-08-2015, 02:41 AM

Great - thanks

**Arkadi** · 07-08-2015, 08:07 AM

Paul, If html format for the email works for you, then this version ought to take care of images for you:

With CreateObject("Outlook.Application").CreateItem(0)
                    .Display
                    Signature = .htmlBody
                    .To = Sheets("Data").Range("B122").Value
                    .Subject = Title
                    .htmlBody = "Please confirm the outcome for" & "<br>" & _
                    "<br>" & _
                    "Surname - " & Sheets("Data").Range("B4").Value & "<br>" & _
                    "Forenames - " & Sheets("Data").Range("B124").Value & "<br>" & _
                    "Date of Birth - " & Sheets("Data").Range("B10").Value & "<br>" & Signature & _
                     .Display

**bigfishprf** · 07-08-2015, 09:00 AM

Can only give you 10/10 I afraid. Works great. Thanks again for your help (and patience!)

Cheers

Paul

**Arkadi** · 07-08-2015, 10:55 AM

My pleasure Paul, thanks for the rep and marking the thread as solved.

default email signature

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

default email signature

Re: default email signature

Re: default email signature

Re: default email signature

Re: default email signature

Re: default email signature

Re: default email signature

Re: default email signature

Re: default email signature

Re: default email signature

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Excel VBA code for saving PDF to file & adding default signature to Email

generating automatic email with default signature and hyperlink

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

send selected range in email with default outlook email signature included

Unable to link default email signature to email

Bookmarks

Bookmarks

Posting Permissions