Send Excel file as attachment to pre-determined recipient

**NKA** · June 5th 07, 06:12 AM posted to microsoft.public.outlook.program_vba

Hello.

I have no idea how to create macro's in Excel, but I would like to click on
a custom button (with macro) to send an Excel spreadsheet to a recipient
(same person every time).

The spreadsheet needs to be sent as an attachment, not included in the body
of the message.

Has anyone done this before and do you have the code (or can you point me to
the right code)?

Many thanks in advance

**Mark Ivey** · June 5th 07, 01:28 PM posted to microsoft.public.outlook.program_vba

Check out this site...

http://www.rondebruin.nl/mail/add-in.htm

"NKA" wrote in message
...
Hello.

I have no idea how to create macro's in Excel, but I would like to click
on
a custom button (with macro) to send an Excel spreadsheet to a recipient
(same person every time).

The spreadsheet needs to be sent as an attachment, not included in the
body
of the message.

Has anyone done this before and do you have the code (or can you point me
to
the right code)?

Many thanks in advance

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Send to mail recipient (As attachment) Outlook 03 error	mark.monroe@hotmail.com	Outlook - General Queries	0	February 13th 07 09:14 PM
Mail Recipient (As Attachment)	wec	Outlook Express	1	December 10th 06 10:46 PM
Can't send file to mail recipient using outlook 2003	homer2727	Outlook - General Queries	5	October 4th 06 04:22 PM
send to recipient mail as attachment	Chriske911	Outlook - General Queries	0	July 17th 06 07:07 PM
Variable attachment and recipient vb	Xluser@work	Outlook and VBA	1	January 21st 06 10:05 AM