Excel VBA Developer Needed for Automated Screenshot and Email Generation Task
Budget: ₹600 – ₹1,500 INR
Excel VBA Macro for Data Capture & Email
**Job Title:**
Excel VBA Developer Needed for Automated Screenshot and Email Generation Task
**Description:**
We are seeking an experienced Excel VBA developer to create a macro that automates the following tasks:
1. **Country-Based Data Selection**:
- Read a country name selected in one sheet (e.g., "CountrySelection" sheet).
- Locate the corresponding row in another sheet (e.g., "Data" sheet) where the country is listed.
2. **Dynamic Data Range Capture**:
- Identify the relevant row and its associated columns dynamically.
- Capture this data as a screenshot or export it as an image.
3. **Email Integration**:
- Embed the screenshot/image into the body of an email.
- Automatically generate and send the email using Microsoft Outlook.
**Deliverables:**
- A fully functional Excel workbook with the required VBA code.
- The VBA macro should:
- Be easy to run and maintain.
- Handle errors gracefully (e.g., notify if the country is not found).
- Save the screenshot temporarily and clean up files after sending the email.
- A brief document or comments in the code explaining how to run and edit the macro.
**Skills Required:**
- Advanced proficiency in Excel VBA.
- Experience with dynamic range calculations in Excel.
- Familiarity with Microsoft Outlook automation via VBA.
- Strong problem-solving skills and attention to detail.
**Additional Notes:**
- The "CountrySelection" sheet contains a cell where the user selects the country.
- The "Data" sheet contains country-related rows, with data extending across multiple columns.
- The macro must ensure compatibility with modern versions of Excel and Outlook.
**Budget:**
500-1000
**Timeline:**
In next 2 days
**Job Title:**
Excel VBA Developer Needed for Automated Screenshot and Email Generation Task
**Description:**
We are seeking an experienced Excel VBA developer to create a macro that automates the following tasks:
1. **Country-Based Data Selection**:
- Read a country name selected in one sheet (e.g., "CountrySelection" sheet).
- Locate the corresponding row in another sheet (e.g., "Data" sheet) where the country is listed.
2. **Dynamic Data Range Capture**:
- Identify the relevant row and its associated columns dynamically.
- Capture this data as a screenshot or export it as an image.
3. **Email Integration**:
- Embed the screenshot/image into the body of an email.
- Automatically generate and send the email using Microsoft Outlook.
**Deliverables:**
- A fully functional Excel workbook with the required VBA code.
- The VBA macro should:
- Be easy to run and maintain.
- Handle errors gracefully (e.g., notify if the country is not found).
- Save the screenshot temporarily and clean up files after sending the email.
- A brief document or comments in the code explaining how to run and edit the macro.
**Skills Required:**
- Advanced proficiency in Excel VBA.
- Experience with dynamic range calculations in Excel.
- Familiarity with Microsoft Outlook automation via VBA.
- Strong problem-solving skills and attention to detail.
**Additional Notes:**
- The "CountrySelection" sheet contains a cell where the user selects the country.
- The "Data" sheet contains country-related rows, with data extending across multiple columns.
- The macro must ensure compatibility with modern versions of Excel and Outlook.
**Budget:**
500-1000
**Timeline:**
In next 2 days