Hello all,
I'm new to this site and it was recommended by afriend - thankyou for letting me join.
I'm not familiar VBA but aware of the powerful thingsit can achieve so look forward to developing my knowledge.
I was hoping there was a code available which I could use in a Macro.
I have an ODBC connection linked to an excel workbookand this contains lots of information relevant to customers. I would like to do the following:
1. Refresh the sheet.
2. Split the refreshed data into separateworksheets based on a value within the sheet (Customer name for example).
3. Name the 'new' sheet based on that customer.
4. Generate emails for each customer based on anemail address within the Customer worksheets and save to my draft email folder- the email ideally will contain predefined text and also a copy of the worksheetthat is only relevant to that customer.
Will it be possible to decide which emails aregenerated? For now I only want togenerate emails for a predefined list of customers but would like a worksheet for all customers to be generated so I can review.
Can the macro access be hidden when theworksheet is attached to the email so the recipient can't see the code?
Thankyou in advance.
<strike></strike>
I'm new to this site and it was recommended by afriend - thankyou for letting me join.
I'm not familiar VBA but aware of the powerful thingsit can achieve so look forward to developing my knowledge.
I was hoping there was a code available which I could use in a Macro.
I have an ODBC connection linked to an excel workbookand this contains lots of information relevant to customers. I would like to do the following:
1. Refresh the sheet.
2. Split the refreshed data into separateworksheets based on a value within the sheet (Customer name for example).
3. Name the 'new' sheet based on that customer.
4. Generate emails for each customer based on anemail address within the Customer worksheets and save to my draft email folder- the email ideally will contain predefined text and also a copy of the worksheetthat is only relevant to that customer.
Will it be possible to decide which emails aregenerated? For now I only want togenerate emails for a predefined list of customers but would like a worksheet for all customers to be generated so I can review.
Can the macro access be hidden when theworksheet is attached to the email so the recipient can't see the code?
Thankyou in advance.
<strike></strike>
