VBA

Resolved · Medium Priority · Version 2003

Fri 20 Jun 2008, 16:01 Delegate Jason said...

Jason has attended:
Excel VBA Intro Intermediate course

VBA

Each day excel spreadsheets are emailed to outlook addresses in the company. I would like to have a macro set up that will email certain excel spreadsheets (10 in all, all different spreadsheets to various email addresses). I would also need the spreadsheets to be value pasted when they are emailed out but not obviously the original. How can you do this ?

Thanks

Jason

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips