Excel Macro For e-mailing Prices

[UnityB]

Good morning all,

I was under the impression that if I recorded a macro using excel it would also record actions made in other Office programs, am I wrong?

I have seven different price bands which each have specific customers assigned to them. Currently I have to open up seven separate e-mail templates, C+P the up-to-date price band prices into each one and send them off to their contact groups.

I recorded a macro and assigned it to a button on the spreadsheet. This took me through the process of opening each e-mail template, C+P the prices from the spreadsheet to the table in the e-mail template and pressing send. I've run the macro this morning and it appears that any action I made in Outlook wasn't recorded, so the macro was a failure!

What have I missed, or is this something that simply isn't possible to automate?

As ever very appreciative for any and all help you can give me

Many thanks,

Rob

 

[ParamRay]

Hello, sadly Excel's macro recorder only captures actions performed within Excel. It is possible to automate Outlook using VBA code running in Excel, but you can't capture this process using a macro recorder; you need someone with knowledge of the Outlook object model to help you write the macro.

If you post details (and, if possible, screenshots) of how the worksheet is structured, how the e-mails are structured, and precisely what the macro needs to do, then someone should be able to help...