I have a form that I enter work parts into (see attatched file). From that data I am wanting to create several macros to make my life a lot easier. To order parts I send an email with the info that is in the database.
I would like to have a button when clicked would extract data from my database such as Part Number from a table called Assets and Account and Account Address from a table called Accounts and add it to an email template. The information needed are on multiple tables. I hope I have described this problem well enough.
Is that possible?
Thanks in advance.