[AccessD] Email Signatures

Not that useful, but maybe it can help...

I wish I could find that damn code that dealt with this.... sheeesh!


anyway, found some stuff on the Excel L and G archives.

'===========================================================================================

When the message comes up, can you use Insert - Signature - YourSig? This
works in XP.

-----Original Message-----
From: Vera Hawkins [mailto:VHawkins at BLACKMORES.COM.AU]
Sent: Tuesday, February 22, 2005 6:28 PM
To: EXCEL-G at PEACH.EASE.LSOFT.COM
Subject: Excel 2003 - Adding signature to emailing workbook


In Excel 2000 we were able to use our automatic signature when emailing
workbooks from Excel. This does not seem to be available in 2003. In
Excel when we go to File | Send To | Mail Recipient as Attachment, the
dialog box comes up with the current workbook as an attachment but no
signature. This is the signature which appears in a new email message in
Outlook which has our name, title and other stuff.

Does anyone know if this is possible or have some code to automatically
add a signature?

Any help would be greatly appreciated.

Thanks and regards

Vera Hawkins


'===========================================================================================

OR

Gareth,
it might have changed in later versions (I use Outlook 97) but I don't think you can add the signature automatically.  2 workarounds use .show instead of .send so that the user can manually add the sig from the menu.   Alternatively add the signature to the body text.

.body = .body & mysigstr

where mysigstr is either a previously set string or if you enclose it in quotes can be the actual text of the signature.  You will have to use & char(13) & for a carriage return and replace 13 with 9 for a tab.

hth

Martin

'===========================================================================================





-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin
at Beach Access Software
Sent: Wednesday, 9 July 2008 3:34 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Email Signatures


Dear List:

In a legacy app there are two places where the user can generate an email to
the client.  IN both of these places the code is identical:

CreateOutlookEmail_MailTo varSubject:=strSubject,
varTo:=strEmailAddressesTo, varCC:=strEmailAddressesCc, _
    varBCC:=strEmailAddressesBcc, varMessage:=strWholeStory

where I've set up the TO, Cc, and Bcc addresses in the strings.

The sub is:

Public Function CreateOutlookEmail_MailTo(Optional varSubject As Variant,
Optional varTo As Variant, _
                                   Optional varCC As Variant, Optional
varBCC As Variant, _
                                   Optional varMessage As Variant, Optional
varAttachmentPath As Variant) As Boolean

'Creates an Outlook e-mail for the user to send.
'This method is the same as the MailTo method, which does not involve the
Outlook security prompt.
'1/12/07


When I call this email function from one form the email generated includes
the default signature which I have set up in Outlook.  When I call it from
the other form, there's no signature.  Code's identical (seemingly).  Any
ideas on why the difference?

MTIA,







Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/>

www.bchacc.com <http://www.bchacc.com/>






--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses.  No warranty is made that this material is free from computer virus or any other defect or error.  Any loss/damage incurred by using this material is not the sender's responsibility.  The sender's entire liability will be limited to resupplying the material.