Thread: automatic reply with parametric Excel file attached
View Single Post
 
Old 12-05-2017, 07:13 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
  
Join Date: Aug 2014
Posts: 4,142
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
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
Reply With Quote