Bronwyn Coulthart
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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-
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-
ASKER
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
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
ASKER
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