Hello,
I am new to this board and I have limited VBA knowledge. I have an Excel file I use to bill customers with. I am using some code I saw on these forums to automatically generate an email with a PDF of the invoice. I have that working now over the last day or so but am now stuck.
I need to update the attached Excel workbook code in the following ways:
* I need the date in the subject line to show the full month only. Now it shows the date in mm/dd/yyyy.
* I need to adjust the code to include a greeting, a body, and a signature line for my name and business name in the body of the email.
* I also need a button to run the macro from each sheet. I added one and it worked but the button disappears after the macro runs and comes back after reopening.
All help is appreciated.
Tim
Hi Tim
You can give this a try.
1) The button did not disappear but it somehow moved to another part of the worksheet.
To prevent it from "disappearing" again, I have adjusted the button's property.
Right-click the button and choose Format Control - Properties - Object positioning - Do not move or size with cells.
2) You can now copy the formatted button to each of your sheets.
3) I have modified some of the codes to add the e-mail body. If you have created a Signature in Outlook, it will be automatically included in your e-mail.
Hope this helps.
Sunny
