Excel Statment of Account

[josros60]

Hi,

I have A/R access database and in Excel i have Statement of Account Spread sheet, from Access i would to attach not the whole spread sheet but just the statement as body message of the email.

any suggestion example of vba code to do so.

thanks.

 

[Ranman256]

you're taking a simple 1 line solution ( docmd.sendto)
and making it a complicated programing venture.

 

[arnelgp]

another approach (psudocode) would be:

using vba copy the sheet (statement of account) into new workbook.
attach the new workbook to your email.

or

using vba again copy and save your statement of account sheet as picture.
attach this picture to your email.