Automatic? What constitutes 'automatic' in this context?

With regard to '1'. Do I take it that the Outlook message with just a subject is sent to you and that as a consequence, you create the reply with the attachment and send it back?

That should be feasible but it seems to be a tortuous process.

You would need a rule to identify the incoming messages that fit the bill and run a script that opens Excel, creates and saves the PDF and attaches it to a reply.

You will need to modify your existing Excel macro so that it can be called with the customer code parameter.

Why not simply give the colleagues access to Excel file, let them create the pdfs and forget all about the e-mails?

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com