Attaching file to email message

[yakpol]

Is it a possible task throuth Excel VBA:
Start email
Personalise text (based on variables)
Attach file and send it.

Appreciate all ideas.

 

[IRstuff]

Have you looked at using some form of Mailmerge?

TTFN

FAQ731-376

 

[yakpol]

I've never heard about mailmerge, is it a part of MS Office?

 

[IRstuff]

Yes, it's supposed to handle sending emails to a list of individuals. However, I don't know if it'll do attachments.

TTFN

FAQ731-376