Link to home
Start Free TrialLog in
Avatar of Bronwyn Coulthart
Bronwyn CoulthartFlag for Australia

asked on

Sending Email from Ms Access with Outlook Signature

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
ASKER CERTIFIED SOLUTION
Avatar of jadedata
jadedata
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bronwyn Coulthart

ASKER

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
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-
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