MindManagement
New Member
- Joined
- Jan 13, 2016
- Messages
- 8
Dear All,
I am VERY new to Macro's, except when it comes to record a macro which is easy.
I create my invoices with an excel sheet. The workbook only contains 1 sheet which is the invoice.
The print range is already set so when I print or save it (as a PDF) in only prints or saves this range.
I would like to :
1- Save the workbook with his name as a PDF to a specific location (in my case g:\Facturen\PDF)
2- Print the invoice - so my accounting has a copy for their files
Next to this I have a draft mail which I use to e-mail my invoices; one in English and one in Dutch.
These mails are under Inbox\STD. Message\e-invoice; One with the subject "Electronic Invoice", the other one with the subject "Electronische factuur".
Is it possible to open one of them and attach the PDF I just created ?
That would mean I need 2 almost identical macro's. One for sending an invoice to an English speaking customer; the other to a Dutch speaking customer.
Putting these 3 steps in a macro (save as PDF - Print - Attach to a specific mail) would save me tons of times.
I am even willing to pay for someone creating me those 2 macro's, if desired.
Marc
Mind Management Consulting
I am VERY new to Macro's, except when it comes to record a macro which is easy.
I create my invoices with an excel sheet. The workbook only contains 1 sheet which is the invoice.
The print range is already set so when I print or save it (as a PDF) in only prints or saves this range.
I would like to :
1- Save the workbook with his name as a PDF to a specific location (in my case g:\Facturen\PDF)
2- Print the invoice - so my accounting has a copy for their files
Next to this I have a draft mail which I use to e-mail my invoices; one in English and one in Dutch.
These mails are under Inbox\STD. Message\e-invoice; One with the subject "Electronic Invoice", the other one with the subject "Electronische factuur".
Is it possible to open one of them and attach the PDF I just created ?
That would mean I need 2 almost identical macro's. One for sending an invoice to an English speaking customer; the other to a Dutch speaking customer.
Putting these 3 steps in a macro (save as PDF - Print - Attach to a specific mail) would save me tons of times.
I am even willing to pay for someone creating me those 2 macro's, if desired.
Marc
Mind Management Consulting
