Log In
Register
Home
New Member
January 29, 2021
Offline
Hi All,
I am currently working on an automated OTIF report. I have a tab called table, line failures and copy. I need VBA to code to send an email to different supplier emails based up on the slicer selection of the line failures tab. I need the email to say hello please see your monthly OTIF figures, I also need the pivot table in the table tab to be in the body of the email and then also attach a copy of the copy tab. The various email addresses are in the emails tab of the workbook.
Please feel free to ask any questions.
Thanks,
Sam
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Can you upload a sample file with your structure?
New Member
January 29, 2021
Offline
Hi Catalina,
Attached is a sample file showing the structure.
Feel free to ask anymore questions.
Thanks,
Sam
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi Sam,
Here is an example that is attaching to a new email a PDF and one of the sheets saved as a new workbook.
It also has the code to add a range from a sheet in the email HTMLBody.
Please test it and adjust it to your needs.
1 Guest(s)
