Nick Collins
asked on
Excel - VBA with Email
Good Morning,
I have a simple excel template that keeps a record of job..
I want to add some functionality using VBA so that when a job is added the the spreadsheet it automatically emails the row data for that job.
I would like the VBA to run and check for new data when the spreadsheet closes automatically together with the email
I have a simple excel template that keeps a record of job..
I want to add some functionality using VBA so that when a job is added the the spreadsheet it automatically emails the row data for that job.
I would like the VBA to run and check for new data when the spreadsheet closes automatically together with the email
ASKER
Yes each line represents a job.
The emails are sent to a default email address for all jobs and yes they can be sent by today's date
The emails are sent to a default email address for all jobs and yes they can be sent by today's date
The code could filter all today's jobs, then insert the result into the body of the email. Would this work?
ASKER
That sounds perfect
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Is the email address in the clients column.
I think you will need to also store a note that an email has been sent, unless you only want to send details for the current date's jobs.