Adrian has attended:
Excel VBA Introduction course
Excel VBA Intermediate course
Excel Intermediate course
Email Generation or Certain data
Hi
I want an email to be automatically generated (not to send, but to generate so all I have to do is hit send. The email will be generated in Outlook.
The problem is, that I want the email to be created by clicking a Macro button and this email will then populate certain information from within the Excel spreadsheet. I have various bits of data, but the concept is the same, so for ease, I shall keep it brief.
I have Row 1 which will have the months of the year. In row 2, I have sales data populated. At the end of the months, so Column M I believe, I have a Totals column. If its July, I want the email to populate Rows 1 and 2 for all months of the year up to and including July, plus the Totals column, but not the Future months.
Your help would be much appreciated
Kind regards
Adrian
RE: Email Generation or Certain data
Hi Adrian,
Thank you for the forum question.
I can guide you in the right direction but this will take some time to write the code. I would use a dynamic array to store the data I will find using a input box where I can type the month. July if I want the data from January to July.
To add the data in a body of and email you can find the code here:
http://www.rondebruin.nl/win/s1/outlook/amail4.htm
I hope this can help you.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
