|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
| Tags: code, email, stationery, through |
|
|
Thread Tools | Display Modes |
|
#1
September 17th 06, 09:11 PM
posted to microsoft.public.outlook,microsoft.public.outlook.program_vba
|
|||
|
|||
No email stationery when through code
Hi
I am creating email via code from access using below; Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem Set objOutlook = CreateObject("Outlook.Application") Set objOutlookMsg = objOutlook.CreateItem(olMailItem) objOutlookMsg.To = " objOutlookMsg.Subject = "Email Subject" objOutlookMsg.Body = "Dear abc..." objOutlookMsg.Display The problem is that the default signature that is set in outlook doe snot come up in the email. How can I fix it? Thanks Regards 
|
| Ads |
|
#2
September 18th 06, 05:48 AM
posted to microsoft.public.outlook,microsoft.public.outlook.program_vba
|
|||
|
|||
|
No email stationery when through code
Am Sun, 17 Sep 2006 21:11:45 +0100 schrieb John:
Call Display first, then insert your text before the existing the body (instead of overwriting it). -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.VBOffice.net -- Hi I am creating email via code from access using below; Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem Set objOutlook = CreateObject("Outlook.Application") Set objOutlookMsg = objOutlook.CreateItem(olMailItem) objOutlookMsg.To = " objOutlookMsg.Subject = "Email Subject" objOutlookMsg.Body = "Dear abc..." objOutlookMsg.Display The problem is that the default signature that is set in outlook doe snot come up in the email. How can I fix it? Thanks Regards
|
|
#3
September 18th 06, 06:01 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
No email stationery when through code
Thanks. I am now using;
objOutlookMsg.Display objOutlookMsg.BodyFormat = olFormatHTML objOutlookMsg.Body = "Dear abc..." & objOutlookMsg.Body The email displays fine with the signature but as soon as the text is added, the signature formatting is lost and the signature image is replaced with a hyperlink. How can I preserve the signature formatting while adding text before it? Thanks Regards "Michael Bauer [MVP - Outlook]" wrote in message ... Am Sun, 17 Sep 2006 21:11:45 +0100 schrieb John: Call Display first, then insert your text before the existing the body (instead of overwriting it). -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.VBOffice.net -- Hi I am creating email via code from access using below; Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem Set objOutlook = CreateObject("Outlook.Application") Set objOutlookMsg = objOutlook.CreateItem(olMailItem) objOutlookMsg.To = " objOutlookMsg.Subject = "Email Subject" objOutlookMsg.Body = "Dear abc..." objOutlookMsg.Display The problem is that the default signature that is set in outlook doe snot come up in the email. How can I fix it? Thanks Regards
|
|
#4
September 18th 06, 12:11 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
No email stationery when through code
Am Mon, 18 Sep 2006 06:01:22 +0100 schrieb John:
Use HTMLBody property instead of Body. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.VBOffice.net -- Thanks. I am now using; objOutlookMsg.Display objOutlookMsg.BodyFormat = olFormatHTML objOutlookMsg.Body = "Dear abc..." & objOutlookMsg.Body The email displays fine with the signature but as soon as the text is added, the signature formatting is lost and the signature image is replaced with a hyperlink. How can I preserve the signature formatting while adding text before it? Thanks Regards "Michael Bauer [MVP - Outlook]" wrote in message ... Am Sun, 17 Sep 2006 21:11:45 +0100 schrieb John: Call Display first, then insert your text before the existing the body (instead of overwriting it). -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.VBOffice.net -- Hi I am creating email via code from access using below; Dim objOutlook As Outlook.Application Dim objOutlookMsg As Outlook.MailItem Set objOutlook = CreateObject("Outlook.Application") Set objOutlookMsg = objOutlook.CreateItem(olMailItem) objOutlookMsg.To = " objOutlookMsg.Subject = "Email Subject" objOutlookMsg.Body = "Dear abc..." objOutlookMsg.Display The problem is that the default signature that is set in outlook doe snot come up in the email. How can I fix it? Thanks Regards
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| No email stationery when through code | John | Outlook - General Queries | 2 | September 21st 06 11:02 AM |
| is it possible to color code incoming email by sender? | Mr . . | Outlook - General Queries | 7 | August 6th 06 10:12 PM |
| VBA code to populate an email header and footer | marie | Outlook and VBA | 1 | July 28th 06 03:21 AM |
| VBA Code to put in Access that will send an Email with Attachments | jon.ingram@comcast.net | Outlook and VBA | 1 | April 9th 06 05:30 PM |
| Stationery Logo tiles on some Mac Email Systems | Bielefelder | Outlook Express | 2 | March 10th 06 07:37 AM |
Linear Mode
