Thread: [Solved] Help with macro not working - Pull from fields > attaches doc from folder > sends email
View Single Post
 
Old 01-08-2015, 12:20 AM
gmayor's Avatar
gmayor gmayor is offline Windows 7 64bit Office 2010 32bit
Expert
  
Join Date: Aug 2014
Posts: 4,143
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
Given that you only have one line of data, it is difficult to see the whole picture. Is the aim to produce one e-mail message with all the recipient data collated, or several e-mail messages, each with its own data? I suspect the former, though your macro suggests otherwise.

If I suspect correctly then I must further assume that you want to add a raft of recipients (as CC?) and an equal number of attachments?

How EXACTLY do the attachment names relate to the fields in the section from row 9 on?

While you can do that (though I would have to look at the limits) might it not be better to send separate messages - in effect mail merge?
__________________
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