Forum Discussion
Add data to email
"In other words, do you have to send these numbers as text or numbers that the recipients can copy and paste themselves elsewhere?"
No, the data would be just be text to populate an email. The email would go to a logistics dept that would set items up for shipping.
I'd set up a simple spreadsheet that would include each data point needed.
This is a sample email:
Please transfer (1) {thingy} into stock
Ops,
Please expedite [Data D] once the transfer order is received and print ticket to the warehouse."
Do you need more info? Thank you for the reply.
music_traveler I recommend looking at this youtube video. The author does a great job and shares a macro that I think is very useful and might help you. Basically he creates the mail merge features of Word in Excel macro, which give much more flexibility. Let me know what you think.
https://www.youtube.com/watch?v=URF3ikW0Svc
- music_travelerNov 03, 2020Copper Contributor
mtarler !!! Thanks! I'll look into this later this morning! Looks similar to what mathetes discussed earlier.