KingSwish828
Board Regular
- Joined
- Jul 13, 2010
- Messages
- 84
I know about VBA and how helpful it can be and would like to learn how to create my own VBA codes. Can anyone recommend a good book on the subject?
Until I learn how to create my own VBA code can someone help me create a VBA code? I will explain what I need below. I get a report sent to me daily and I may need to send an email to the people on the report to check on the status of a purchase order.
I need the VBA code that will open up an Outlook email and put in the body of the email and copy and past the data from my escel file in the email. I want the option to send the email out.
Column A contains the email address that I want my email to go to. If column A rows 1 and 2 = the same email address then I only want one email to open up for that person
Column B- Vendors name
Columns B-M contain all of the data that I want pasted in the email
I use Excel and Outlook 2010
<COLGROUP><COL style="WIDTH: 268pt; mso-width-source: userset; mso-width-alt: 13056" width=357><COL style="WIDTH: 228pt; mso-width-source: userset; mso-width-alt: 11117" width=304><COL style="WIDTH: 155pt; mso-width-source: userset; mso-width-alt: 7533" width=206><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3584" width=98><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2157" width=59><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 87pt; mso-width-source: userset; mso-width-alt: 4242" width=116><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2304" width=63><COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 2230" width=61><COL style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1389" width=38><COL style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 2084" width=57><TBODY>
</TBODY>
Until I learn how to create my own VBA code can someone help me create a VBA code? I will explain what I need below. I get a report sent to me daily and I may need to send an email to the people on the report to check on the status of a purchase order.
I need the VBA code that will open up an Outlook email and put in the body of the email and copy and past the data from my escel file in the email. I want the option to send the email out.
Column A contains the email address that I want my email to go to. If column A rows 1 and 2 = the same email address then I only want one email to open up for that person
Column B- Vendors name
Columns B-M contain all of the data that I want pasted in the email
I use Excel and Outlook 2010
Name | Shipto Desc | PO Date | Disp Method | PO ID | Line Nbr | Due Date | Item ID | PO Qty | Recv Qty | UOM | Confirm | |
Joe.Smith@mmm.com | YME | Swish Candy Co | 6/24/2013 | EDI | H011358308 | 1 | 7/9/2013 | H0890081816 | 50 | 0 | EA | C |
bhurr@AIECASTERS.com | AIE | Swish Candy Co | 7/10/2013 | EML | H021366017 | 1 | 8/22/2013 | H0890012679 | 4 | 0 | EA | |
jennifer@airsupply.com | Air Supply | Swish Candy Co | 7/11/2013 | EML | H011366548 | 1 | 8/30/2013 | H0890145165 | 2 | 0 | EA | |
Joe@airgascom | AIRGAS | Swish Candy Co | 7/15/2013 | FAX | H011368324 | 1 | 7/29/2013 | H0890096698 | 10 | 0 | LBS | |
judy@airline.com | Airline | Swish Candy Co | 7/16/2013 | EML | H011368874 | 1 | 7/19/2013 | H0890059904 | 10 | 0 | EA | |
judy@airline.com | Airline | Swish Candy Co | 7/11/2013 | EML | H011366316 | 1 | 8/21/2013 | H0810030927 | 1 | 0 | EA | |
Aled | Swish Candy Co | 7/9/2013 | EML | H011365321 | 3 | 7/23/2013 | H0890101319 | 2 | 0 | EA | ||
Aled | Swish Candy Co | 7/9/2013 | EML | H011365321 | 2 | 7/24/2013 | H0890034075 | 2 | 0 | EA |
<COLGROUP><COL style="WIDTH: 268pt; mso-width-source: userset; mso-width-alt: 13056" width=357><COL style="WIDTH: 228pt; mso-width-source: userset; mso-width-alt: 11117" width=304><COL style="WIDTH: 155pt; mso-width-source: userset; mso-width-alt: 7533" width=206><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3584" width=98><COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 2157" width=59><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2742" width=75><COL style="WIDTH: 87pt; mso-width-source: userset; mso-width-alt: 4242" width=116><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2304" width=63><COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 2230" width=61><COL style="WIDTH: 29pt; mso-width-source: userset; mso-width-alt: 1389" width=38><COL style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 2084" width=57><TBODY>
</TBODY>