Forum Discussion
Creating Forms
I'm a complete numb skull when it comes to Excel, and I can't figure out what to google to make what I want to do happen. I have an excel sheet with cookie orders, and I want to extract that data to...
I would suggest looking into using your Excel spreadsheet as the data source for the MailMerge function in Word. (Don't let the "Mail" in that mislead you--you can merge into a document that would look just like you want it to look.)
Here are links to two instructional YouTube videos. My guess is that either would work--and there are more--but start with these
https://www.youtube.com/watch?v=0XifMrBegS0
https://www.youtube.com/watch?v=mFqCvTOpOL0
- here is another video I really liked because it uses Excel more and gives more flexibility than the standard mail merge... it's been a long time since I watch but pretty sure it even goes over how to automatically create the e-mails...
Excel macro to create word docs without mail merge:
https://www.youtube.com/watch?v=URF3ikW0Svc
