Chrissy

Does anyone know the code to email an Excel spreadsheet to a specific recipient as an attachment? I cannot use the mapi as its not licenced on my system.

I have so far recorded a macro, but all it does is open outlook with the attachment, it will not let me record the recipient name, any ideas?

Ideally I would like it to do this and send automatically too.

wbeetge

If you say that MAPI is not registered on your machine, do yo have Oultook installed on your machine ?

Graham

MindGenius

Do you want to email the actual spreadsheet in Outlook using a macro, or within the program (e.g. create a program that emails it without using Outlook)?

Chrissy

I do have outlook on my machine, but for some reason am not able to use the mapi control, it tells me I do not have a licence.
I have now got my code to email in a round about way, but it works!

Thanks guys for all your help....much appreciated!

Chrissy

I have done it now using a macro, still have some minor problems with it but can hopefully resolve those.

Many thanks for your help!