I have a spreadsheet which contains the following fields for 200 customers:
Name, Number, Address, Email, Address, Location, Delivery, Date etc
I want the ability to:
- Send each row of data from Excel 2007 through Outlook 2007 to each indvidual email address (each row) in one push to 200 customers.
- Allow users to check and update the details if incorrect.
- For them to send the updated data back through Outlook and into one central spreadsheet so I don’t have to copy and the paste the data from each email.
- I would like a flag which shows who has checked or updated their details so I do not have to follow up.
I have been informed I could use Infopath however I have never used it before so would prefer to use Outlook and Excel. Can anyone assist?
Bookmarks