Hello,
Haven't used VBA for 15 or so years and have literally forgotten it all!
Hope you can help
Been reading around, and I see parts of the solutions here and there, but couldn't figure out how to combine it all.
Trying to autogenerate a standard email in Outlook, text is in Word, with one Excel attachment, files are in one folder. The references are in an Excel "master file".
Folders (made up paths for ref.):
C:\Weblinks/Image_Links (containing all files for attachment)
C:\Weblinks/Masterinfo (containing all other files)(Master excel + word doc with email content)
Word doc:
EmailContent
Excel columns:
A= #ID
B=fileName (for attachment)
C= filePath; C:\Weblinks/Image_Links
D= filePathName (combined C&B if needed)
E= A2= email subject (the same for all mails)
Haven't used VBA for 15 or so years and have literally forgotten it all!
Hope you can help
Been reading around, and I see parts of the solutions here and there, but couldn't figure out how to combine it all.
Trying to autogenerate a standard email in Outlook, text is in Word, with one Excel attachment, files are in one folder. The references are in an Excel "master file".
Folders (made up paths for ref.):
C:\Weblinks/Image_Links (containing all files for attachment)
C:\Weblinks/Masterinfo (containing all other files)(Master excel + word doc with email content)
Word doc:
EmailContent
Excel columns:
A= #ID
B=fileName (for attachment)
C= filePath; C:\Weblinks/Image_Links
D= filePathName (combined C&B if needed)
E= A2= email subject (the same for all mails)