Hello Everyone,
First time posting, lets get into it.
I'm making a parts order form for work. It has a list of all stocked items with part numbers, descriptions and recommended stock quantities.
When you enter actual stock quantities it outputs order amounts of each item to Sheet 2 like below.
Item QTY |Min QTY |Actual QTY |Order QTY |Part Number |Description
5 pack | 5 |6 | 0 | 18711514 | A/C Fibre Washer for Bottle Fittings 5pk
1 pce |4 |0 | 4 | 1498189519 |A/C Fitting Alu #10 45
On sheet 2 I'm trying to have a button with a macro that emails the table of the stock order to a work address but my knowledge of Visual Basic code is limited.
We don't use outlook because of compatibility issues and instead use Windows Mail, which I also use, so it needs to be sent via the default mail app. The only way I could find to do that is with cmd using Mailto.
I have tried many different lines of code I could find online but i'm just getting error after error. Also I don't know how to get the table to insert into the body of the email using cmd.
This is what I have at the moment;
I'm hoping what I want to do is even possible but googling for code for VB to insert a table into a mailto doesn't look to be anything anyone else has asked.
Even trying CreateObject ("Outlook.Application"), OutMail it errors at the "Set order = Sheets" part. Most of the code is from the youtube video "Excel VBA Macro: Send Email With Table In Body (Dynamic Range)"
But it uses outlook so have tried to adapt it for mailto.
Thanks everyone.
Bookmarks