General discussion


daily email to a group of users

By sally ·
I have a product list in MS Excel that is updated daily. I need to send out this update to a group of users daily as an attachment. Is it possible to just change the attachment, leave the defined message and send this to the group daily, automatically? This all done through MS Outlook.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by Oldefar In reply to daily email to a group of ...

Outlook doesn't get the file until you select Send in Excel, or you save the file to be selected as an attachment. The easiest approach would be to create a macro in Excel to Send the email, enter the standard message text, and select the recipient group from the address book.

However, I don't think distributing copies of a daily Excel file via email is the best approach to your business requirement. The business requirement as I understand it is to make available to a group of users a product list that changes at least daily. One list - many users. Better ways to accomplish this are:
1) Shared file on server that users have access to
2) Web page that users access using browser and you update as needed
3) Shared public folder in Outlook that contains the file

The problems with your current approach, besides the effort on your part, include:
1) Users cannot easily insure they have current file
2) Users may save multiple versions, eating up storage space
3) Each user has at least 1 copy (size times your distribution list) to be backed up
4) Users may save message and file in Outlook, slowing performance and increasing the size of their *.pst and archives
5) Distribution depends on user checking email
6) Network load - performance issue potential on the LAN and a cost and performance issue over a WAN

Collapse -

by Oldefar In reply to

The trick to getting the most out of technology is to focus first on what you are trying to achieve from a business perspective. Once you have defined the what, you can determine the how.

Too often, we begin with the technology and try to make it fit a new business requirement.

Related Discussions

Related Forums