Emailing a template, Word VBA, that includes attachments
Posted on 2014-02-07
After constructing a Report within MS Word, what would be the best process for having a macro that opens an Outlook template and attaches the current document, plus one other, and then Sends the e-mail out to those designated within the Outlook template.
Or, maybe the better question is what is the best process for using VBA, either in Word or Outlook, to open the template, and attach two files that have the current days date within the filename, and then sends it out. Currently, the two Word files are saved as, with each one having a different path or subdirectory, as:
vPath & "\" & Format(Date, "mm.dd.yy") & " Error_Log_Report.doc(x)
vPath & "\" & Format(Date, "mm.dd.yy") & " EI_Log_Report.doc(x)