I have a repetitive task to do several times each day that i would like to automate.
In my excel file i have several cells in a row that get filled in with data. After the data is filled an outlook template is opened containing a table where the same information is filled in and emailed to a client. Is there a way to automate this task so when i click a button a macro will run that will automatically input the info into the table in the outlook template? Also after Excel row 16 is filled in I move into the next row (17) so the rows are not static.
Screenshot of excel file:Please Login or Register to view this content.
im2.jpg
Screenshot of email template:
im1.jpg
Bookmarks