D
DanHood
Hi there,
From your professional experience is it possible to create Add-in using
Visual Studio Tools for Office which will automate following manual actions:
attachment of the excel file with the unique name (eg excel file starting
with MLC word)
and sending it to multiple number of email address that have unique company
field (eg MLC1, MLC2,)
While sending an excel file to a bulk email is pretty straightforward I have
encountered a lot of difficulties in finding the code solution for MOutlook
add. It is all about mapping the right excel file with the coresponding
recipient, but not one article could be found on this topic.
Both lists are stored at SharePoint and one idea is to use VSTO to somehow
communicate with lists at SharePoint and Outlook classes so as to create and
send an email. For example there are 450 participants of the survey and to
each of them I send specifically designed excel files as an attachment from
folder stored at SharePoint. The Excel files are automatically generated at
the beginning of the each month and have dynamic nature because of their
naming convention (eg MLCA001_July_06).
The forms are send to corresponding participants individually (450).
However, each participant has a few email recipient, (unique company field).
Currently I am sending emails manually and it takes up to six hours to
perform this tedious job. In Microsoft outlook I have specifically created
folder with all email addresses of survey participants.
I would appreciate if you can share a few thought with me about feasibility
of the idea to automate whole process of attaching correct forms to correct
recipient and emailing of the context.
Thanks, Dan
From your professional experience is it possible to create Add-in using
Visual Studio Tools for Office which will automate following manual actions:
attachment of the excel file with the unique name (eg excel file starting
with MLC word)
and sending it to multiple number of email address that have unique company
field (eg MLC1, MLC2,)
While sending an excel file to a bulk email is pretty straightforward I have
encountered a lot of difficulties in finding the code solution for MOutlook
add. It is all about mapping the right excel file with the coresponding
recipient, but not one article could be found on this topic.
Both lists are stored at SharePoint and one idea is to use VSTO to somehow
communicate with lists at SharePoint and Outlook classes so as to create and
send an email. For example there are 450 participants of the survey and to
each of them I send specifically designed excel files as an attachment from
folder stored at SharePoint. The Excel files are automatically generated at
the beginning of the each month and have dynamic nature because of their
naming convention (eg MLCA001_July_06).
The forms are send to corresponding participants individually (450).
However, each participant has a few email recipient, (unique company field).
Currently I am sending emails manually and it takes up to six hours to
perform this tedious job. In Microsoft outlook I have specifically created
folder with all email addresses of survey participants.
I would appreciate if you can share a few thought with me about feasibility
of the idea to automate whole process of attaching correct forms to correct
recipient and emailing of the context.
Thanks, Dan