Hi, I want to use Outlook to email a set of contacts contained within a spreadsheet. Each message have a common text but with some personalization. The personal bits will include RECIPNAME, ORGNAME and their email address - this is contained within the spreadsheet. This is done using Office 2003 packages. The final message will look like:
Dear RECIPNAME,
General blurb common, but for ORGNAME. More blah ORGNAME and yet more common blah ORGNAME.
Yours,
Etc.
I am new to VBA, my difficulty is this, how from within Outlook can I access the cell contents of the Excel spreadsheet to insert the specifics within the message and set the email address. If someone can give me one example for part of this then I can probably do the rest.
Thanks for your help.
Dear RECIPNAME,
General blurb common, but for ORGNAME. More blah ORGNAME and yet more common blah ORGNAME.
Yours,
Etc.
I am new to VBA, my difficulty is this, how from within Outlook can I access the cell contents of the Excel spreadsheet to insert the specifics within the message and set the email address. If someone can give me one example for part of this then I can probably do the rest.
Thanks for your help.