Hi Guy's, is there a method I can add an excel workbook to email body ??, i can add an attachment easy, would like to add to mail body ???
Kindest
Hi Guy's, is there a method I can add an excel workbook to email body ??, i can add an attachment easy, would like to add to mail body ???
Kindest
An Excel range can be copy/pasted into email. This https://stackoverflow.com/questions/...sing-excel-vba shows Excel VBA code.
Alternatively, automation code can manipulate Excel to read data from cells and concatenate into string that can be used as email body. If sheet is simple enough so Access can link to it, this process would be simplified because then the link could be treated as a table.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.