Excel 2016 Macro, Outlook attachment
2228
$$
- Posted:
- Proposals: 5
- Remote
- #1902707
- Archived
Description
Experience Level: Intermediate
#1
Macro: When the customers selects this button it would prepare the excel as an attachment and populate the email address to a customer service member.
#2
I would like to have a macro to “Distribute Customer Pricing”. When selected – it would convert the excel worksheet into a PDF that can be used for an outlook attachment.
#3 Maybe. Recommendation on how to update pricing changes when needed. You will see in the workbook the current function.
The excel sheet needs to be protected when sending to the customer but I would want the macro button’s to work and the filters on line 6 to function while the sheet is protected. Is this possible.
I have a number if other excel projects and items but I'm starting with the above. I can provide the excel sheet.
No email sending at all. This is customer pricesheets and workflow help.
Macro: When the customers selects this button it would prepare the excel as an attachment and populate the email address to a customer service member.
#2
I would like to have a macro to “Distribute Customer Pricing”. When selected – it would convert the excel worksheet into a PDF that can be used for an outlook attachment.
#3 Maybe. Recommendation on how to update pricing changes when needed. You will see in the workbook the current function.
The excel sheet needs to be protected when sending to the customer but I would want the macro button’s to work and the filters on line 6 to function while the sheet is protected. Is this possible.
I have a number if other excel projects and items but I'm starting with the above. I can provide the excel sheet.
No email sending at all. This is customer pricesheets and workflow help.
Kevin K.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
20%
Last project
20 Feb 2018
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Can you attach the existing file, given your reference to "filters in row 6"?
Can you also confirm that the attachment the customer will mail to Customer Service will remain an Excel file , whilst the mail you send to customers needs the Excel sheet to be a PDF? -
Kevin,
Can you attach the existing file, given your reference to "filters in row 6"?
Can you also confirm that the attachment the customer will mail to Customer Service will remain an Excel file , whilst the mail you send to customers needs the Excel sheet to be a PDF?
594557594172
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies