Send Excel file as attachment to pre-determined recipient

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repetitive mailings-different subjects/attachments 2
Prevent sending Excel files as attachements 1
Determine recipients of the message being replied to 1
Automatically send email with attachment. 1
Excel as a data source for Outlook to email Word docs 3
Forward selected mail as attatchment 1
Sent Mail won't be removed from Draft for Redemption with Outlook 2010 1
Outlook within Excel, get return code to know if user pressed SEND 3

Top