sending mails using outlook

  • Thread starter Thread starter Bart van den Burg
  • Start date Start date
B

Bart van den Burg

hi

I have an Excel sheet with macro's running behind it, which, among others,
creates HTML files which need to be sent to various persons within the
intranet. For this I wish to use Outlook. However, an approximate of 150
files need to be sent every week, so of course we cannot do this manually.

Now I'm looking for a way to automate this, to use Visual Basic scripting to
control Outlook and create those mails for me, attach two specific files to
each of then, and send them out. But I have no idea where to start looking,
on how to approach this. Can anyone give me some hints for this?
Documentation or a step-by-step walkthrough?

Thanks in advance
Bart
 
You must log in or register to reply here.

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

Automated Solution to Repair PST Files 2
Access Send and Receive Mail thru Outlook using Access VBA 0
How to Export Gmail Emails to PST Format? 6
How can I migrate MBOX to PST? 2
Automatically sending Outlook mail 2
Macro to use information in a cell to locate and send files using outlook 0
Outlook addin - how to tell an email is created from window explorer file->send to->mail recipient? 1
Best Gmail Backup Tool to use in 2025? 3

Back
Top