Access Email Signature

[Pjdelchi]

I currently use MS Access 2007 and have a macro that generates .pdf reports
and then emails them to several clients via Outlook. I would like to add
my usual email signature to these emails. Does anyone know how this can be
done? Thanks.

 

[bhicks11 via AccessMonster.com]

Hi,

Yes you make a template of the email you want to send and refer to it in the
sendobject command.

Bonnie

http://www.dataplus-svc.com

 

[Pjdelchi]

Thanks, but forgive me Bonnie, can you dumb it down for me a bit? I know
Access, but I have not worked with templates before. Can you give me an
example or give a link to some place where I could see an example?

 

[bhicks11 via AccessMonster.com]

Link :

http://office.microsoft.com/en-us/outlook/HA010917681033.aspx?pid=CL100626971033



Example
The following example includes the Employees table in a mail message in
Microsoft Excel format and specifies To, Cc, and Subject lines in the mail
message. The mail message is sent immediately, without editing.

DoCmd.SendObject acSendTable, "Employees", acFormatXLS, _
"Nancy Davolio; Andrew Fuller", "Joan Weber", , _
"Current Spreadsheet of Employees", , False
Bonnie

http://www.dataplus-svc.com

Thanks, but forgive me Bonnie, can you dumb it down for me a bit? I know
Access, but I have not worked with templates before. Can you give me an
example or give a link to some place where I could see an example?

Hi,

[quoted text clipped - 9 lines]