send content worksheet email

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Send the content of a worksheet by email

Send the content of a worksheet by email

resolvedResolved · Medium Priority · Version 2010

Alain has attended:
Excel VBA Intro Intermediate course
Excel VBA Advanced course
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course
Introduction to Management course

Send the content of a worksheet by email

Hi,

I am currently using a macro that attaches the active workbook to an email and then sends it to a mailing list.

I would like to know how I could copy and paste the content of a workbook in an email and simply send this email without attaching the workbook.

I would be very grateful if you could suggest a solution. I thank you in advance for your help.

Alain

RE: Send the content of a worksheet by email

Hi Alain, thanks for your query. This link should give you what you need:

http://www.rondebruin.nl/mail/folder3/mail4.htm

Hope this helps,

Anthony

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Design View in Relationship window

Your in the Relationship window and changes are required to be made to a Table's design.

Rather than exiting the Relationship window, if you perform a right-mouse click on the table, it opens that table up in Design view

View all Access hints and tips


Server loaded in 0.08 secs.