Send email from records in excel sheet
- or -
Post a project like this$$
- Posted:
- Proposals: 20
- Remote
- #2258984
- Expired
TOP PRO - Excel, Word, PowerPoint, VBA, Google Sheet, Outlook, Access, Database, Scripting
Bay Minette
Google sheets apps script GAS VBA Excel Macro VB.NET ADD-INS Web Scrap API developer
Kharkiv
Researcher, Data base building, Lead generation, E Mail database, Data Entry, Research base writing, Market Research,
Bay Minette
14494731365006126446311927988799628378043863472351365
Description
Experience Level: Intermediate
I have an excel sheet (sheet changes every day). The sheet contains part numbers. Each line has a different part number and quantity. Another excel sheet has email addresses.
I would like you to develop a macro that sends an email with all the items for one supplier to request a quote.
example table:
Part#......PartName.......Quantity.....SupplierName....Supp#
P001.......bearing..................10..................Supp01.......10001
P002.......shaft........................5.................................................. (supplier same as line1)
P003.......motor......................1.................................................. (supplier same as line1)
P025.......gloves..................200..................Supp99........11032
P156..........tires.....................50................................................. (same as above 11032)
P344........tubes....................10...................Supp87........35077
in this case you would send 3 emails.
email 1 to supplier 10001
subject: please send a quote
please provide your best pricing for
P0001 bearing 10 ea
P0002 shaft 5 ea
P0003 motor 1 ea
Email 2 to supplier 11032
subject: please send a quote
please provide your best pricing for
P025 gloves 200 ea
P156 tires 50 ea
Email 3 to supplier 35077
subject: please send a quote
please provide your best pricing for
P344 tubes 10 ft
I would like you to develop a macro that sends an email with all the items for one supplier to request a quote.
example table:
Part#......PartName.......Quantity.....SupplierName....Supp#
P001.......bearing..................10..................Supp01.......10001
P002.......shaft........................5.................................................. (supplier same as line1)
P003.......motor......................1.................................................. (supplier same as line1)
P025.......gloves..................200..................Supp99........11032
P156..........tires.....................50................................................. (same as above 11032)
P344........tubes....................10...................Supp87........35077
in this case you would send 3 emails.
email 1 to supplier 10001
subject: please send a quote
please provide your best pricing for
P0001 bearing 10 ea
P0002 shaft 5 ea
P0003 motor 1 ea
Email 2 to supplier 11032
subject: please send a quote
please provide your best pricing for
P025 gloves 200 ea
P156 tires 50 ea
Email 3 to supplier 35077
subject: please send a quote
please provide your best pricing for
P344 tubes 10 ft
I F.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
26 Apr 2024
Canada
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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