Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Sending Email from Ms Access with Outlook Signature

Posted on 2004-09-20
4
Medium Priority
?
554 Views
Last Modified: 2010-05-18
I have a problem when I generate emails from an Access database.  Generating the emails are not the problem.  The problem is that when the email is produced it does not display the users signature at the bottom of the email.  The email is blank except for the detail exported from the database.

I have used sendobject and a number of other methods listed on this site to generate the emails but all give the same result - no signature at the bottom.

Software Versions I have tested this in:
Access 2000
Outlook 2000

Access 2002
Outlook 2002

I believe I must be missing something because I would not have thought it would be that hard to achieve this.  Any ideas would be greatly appreciated - Thanks.

Seybienne
0
Comment
Question by:Bronwyn Coulthart
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 32

Accepted Solution

by:
jadedata earned 2000 total points
ID: 12108184
Greetings Seybienne!

  You are either going to have to 'recreate' the signature into the body of the email or,...
  use the Mapi object to dig into the objects collections and find the users signature (and possibly sift it out of many signatures)

  I'd suggest taking a simple approach to this and devise a signature line(s) from existing and readily available data.

regards
:)-j-
0
 

Author Comment

by:Bronwyn Coulthart
ID: 12110444
Greetings jadedata

Thanks for that I have tried this also except the signature does not look the same as the Outlook one and my client want's it to look exactly the same.  Any suggestions on how to make this happen?  They have about 10 lines in their signatures including disclaimer with fancy lines separating the disclaimer from the contact information.

Thanks

Seybienne
0
 
LVL 32

Expert Comment

by:jadedata
ID: 12111627
sometimes it comes down to a matter of how much the customer is willing to spend to get their way.  I usually find that talk of cost will make a customer amenable to changes in the specifications.  

the 10 lines shouldn't be that big a deal to simulate in a manner very close to the requirement, just NOT EXACTLY.  
EXACTLY = $$$$$$

if
  (A line) = $50
  and
  (A fancy line) = $1000
then
  customer will probably choose (A line)
endif

One of the things I remind customers regularly is:
  A Contractor's Axiom
  Cheap.  Fast.  Good.  Pick Two.  Because all three can't be had together.
 
-j-
0
 

Author Comment

by:Bronwyn Coulthart
ID: 12127988
Hi jadedata,

Thank you that seems to have worked and the signature is pretty close the major difference being the absense of colour font, and the plain lines.  I have tested it on my systems and it works well I shall test it on my client's system tomorrow.  Hopefully there shall be no anomolies on site.

Thank you once again for your help and good advice.

Seybienne
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question