Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Send the content of a worksheet by email

Resolved · Medium Priority · Version 2010

Reply Thu 3 Nov 2011, 13:08Delegate Alain said...

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

Send the content of a worksheet by email

Hi,

Sorry i asked this question on the VBA Access forum first. I assume the answer is likely to be very similar. Here it is once again for Excel:

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

For upcoming training course dates see: Pricing & availability

Reply Thu 10 Nov 2011, 10:42Trainer Anthony said...

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

Reply Thu 10 Nov 2011, 12:38Delegate Alain said...

RE: Send the content of a worksheet by email

Hi Anthony,

I thank you for your answer. This looks really good. I am looking forward to trying it.

Alain

Excel articles

· Baffled by custom number formatting in Excel?
· Experience The Power Of PowerPivot
· Edit Anywhere With Mobile Spreadsheets
· Correct In, Garbage Out
· Special Characters in Excel

Please browse our web site to find out more about
excel+and+powerpoint+courses+uk and other Microsoft training courses.

Excel tip:

Create your own custom list on Excel 2010!

If you know how to use the auto-fill option on Excel then why not create your own customs lists?

The auto fill feature saves you time by allowing you to enter one of the list entries into a cell and then use your mouse to automatically drag the rest of the list into the cells below, above or to either side of the initial cell. When using your mouse to perform this task you will see a thin black cross appear at the bottom right hand side of the cell. Click, hold and drag to make the list appear.

Default lists include weekdays and months. To create your own list in Excel 2010 do the following;

>File
>Options
>Advanced
>Scroll right to the bottom of the page and you will see a buttom "edit custom lists", click this button
>enter your list in the list entries
>click add

Now try it out. Good luck.
>

View all Excel hints and tips