A Microsoft Outlook email forum. Outlook Banter

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.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook - Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Using Outlook Standard Email Template from Access VBA



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old May 22nd 08, 03:06 PM posted to microsoft.public.outlook.program_forms
CaptainBly
external usenet poster
 
Posts: 8
Default Using Outlook Standard Email Template from Access VBA

I have in several different applications set up the ability for a
customer to send emails from the application.

My application creates an instance of outlook. Creates an email.
Adds necessary email addresses. Adds attachments where applicable.
Adds subject and body text and sends.


That all works great.


The emails that generate are very simple plane text emails though. I
have a customer that would like it to use the email template
like Outlook does with their signature etc... on the generated emails
from Access.


They would also like the ability to "pretty up" the email. Use
different fonts. Different colors. Etc... But that is not as
pressing. The first portion is more important. Is there a way to get
their signature on an email? To use the same blank template that they
see
when they just generate an email in outlook?


Is there a way to do this from VBA?

Any help is greatly appreciated
Ads
  #2  
Old May 22nd 08, 03:37 PM posted to microsoft.public.outlook.program_forms
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Using Outlook Standard Email Template from Access VBA

Yes, that's possible. You'd need to instantiate an Outlook.Application object, then use its CreateItem() method to create your message. Add formating by setting the value of the HTMLBody property to the fully tagged HTML content that you want the message to display.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"CaptainBly" wrote in message ...
I have in several different applications set up the ability for a
customer to send emails from the application.

My application creates an instance of outlook. Creates an email.
Adds necessary email addresses. Adds attachments where applicable.
Adds subject and body text and sends.


That all works great.


The emails that generate are very simple plane text emails though. I
have a customer that would like it to use the email template
like Outlook does with their signature etc... on the generated emails
from Access.


They would also like the ability to "pretty up" the email. Use
different fonts. Different colors. Etc... But that is not as
pressing. The first portion is more important. Is there a way to get
their signature on an email? To use the same blank template that they
see
when they just generate an email in outlook?


Is there a way to do this from VBA?

Any help is greatly appreciated

  #3  
Old May 22nd 08, 04:14 PM posted to microsoft.public.outlook.program_forms
CaptainBly
external usenet poster
 
Posts: 8
Default Using Outlook Standard Email Template from Access VBA

On May 22, 10:37*am, "Sue Mosher [MVP-Outlook]"
wrote:
Yes, that's possible. You'd need to instantiate an Outlook.Application object, then use its CreateItem() method to create your message. Add formating by setting the value of the HTMLBody property to the fully tagged HTML content that you want the message to display.
--
Sue Mosher, Outlook MVP
* *Author of Microsoft Outlook 2007 Programming:
* * *Jumpstart for Power Users and Administrators
* *http://www.outlookcode.com/article.aspx?id=54



"CaptainBly" wrote in ...
I have in several different applications set up the ability for a
customer to send emails from the application.


My application creates an instance of outlook. *Creates an email.
Adds necessary email addresses. *Adds attachments where applicable.
Adds subject and body text and sends.


That all works great.


The emails that generate are very simple plane text emails though. *I
have a customer that would like it to use the email template
like Outlook does with their signature etc... on the generated emails
from Access.


They would also like the ability to "pretty up" the email. *Use
different fonts. *Different colors. *Etc... But that is not as
pressing. *The first portion is more important. *Is there a way to get
their signature on an email? *To use the same blank template that they
see
when they just generate an email in outlook?


Is there a way to do this from VBA?


Any help is greatly appreciated- Hide quoted text -


- Show quoted text -


I am creating the emails using those objects/methods. I did see the
htmlbody property/setting and set that but the email I send doesn't
have the default signature from outlook on it. That is more
important than using fonts and stuff actually. Is there a way to add
the signature section to the outgoing email? I didn't see a property/
setting/method in the object definition that let me do that.

I really just want the email to look like they sent it natively from
their outlook session with their signature etc. The body itself can
be plain old Arial or whatever. Is there an HTML Tag to stick the
signature in there? I am NOT an HTML programmer so that is not my
forte at all.

Thanks for your help.
  #4  
Old May 22nd 08, 05:32 PM posted to microsoft.public.outlook.program_forms
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Using Outlook Standard Email Template from Access VBA

The signature is part of the item body. It is not a separate property. The signature will be present if you display the message (or access its Inspector with GetInspector). You would then modify the HTMLBody property to insert the additional content you want to include. In other words, you will need to know HTML to make this work.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"CaptainBly" wrote in message ...
On May 22, 10:37 am, "Sue Mosher [MVP-Outlook]"
wrote:
Yes, that's possible. You'd need to instantiate an Outlook.Application object, then use its CreateItem() method to create your message. Add formating by setting the value of the HTMLBody property to the fully tagged HTML content that you want the message to display.



"CaptainBly" wrote in ...
I have in several different applications set up the ability for a
customer to send emails from the application.


My application creates an instance of outlook. Creates an email.
Adds necessary email addresses. Adds attachments where applicable.
Adds subject and body text and sends.


That all works great.


The emails that generate are very simple plane text emails though. I
have a customer that would like it to use the email template
like Outlook does with their signature etc... on the generated emails
from Access.


They would also like the ability to "pretty up" the email. Use
different fonts. Different colors. Etc... But that is not as
pressing. The first portion is more important. Is there a way to get
their signature on an email? To use the same blank template that they
see
when they just generate an email in outlook?


Is there a way to do this from VBA?


Any help is greatly appreciated- Hide quoted text -


- Show quoted text -


I am creating the emails using those objects/methods. I did see the
htmlbody property/setting and set that but the email I send doesn't
have the default signature from outlook on it. That is more
important than using fonts and stuff actually. Is there a way to add
the signature section to the outgoing email? I didn't see a property/
setting/method in the object definition that let me do that.

I really just want the email to look like they sent it natively from
their outlook session with their signature etc. The body itself can
be plain old Arial or whatever. Is there an HTML Tag to stick the
signature in there? I am NOT an HTML programmer so that is not my
forte at all.

Thanks for your help.
 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I remove a toolbar from the standard outlook email template Juj312 Outlook - Installation 0 May 13th 08 08:05 PM
Send email from Access using Outlook template Jerry M. Faison III Outlook and VBA 1 February 27th 08 05:44 AM
Office Standard 2007 Upgrade & Outlook Email math48teach Outlook - Installation 7 March 5th 07 08:49 AM
is it possible to export my outlook email files to some standard format ? surfunbear@yahoo.com Outlook - General Queries 3 August 27th 06 06:24 PM
Standard Email program ? Planbureau Van Oirschot Outlook Express 4 August 26th 06 11:10 PM


All times are GMT +1. The time now is 06:47 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.