I Know! I've had to uninstall 2010 and re-install 2003 on my home laptop to try to get this working.
Unfortuantly we have some very large Access files that don't work with anything newer than 2003 and we currently don't have time or knowledge to update them to work with anything else.
Thank you Diane! Macro works great now.
But now i have another problem, i need to assign the Marco to a button and add it to one of the ribbons.
Which i could do when i wasn't using word as the editor but now since word is the editor when i try to add the macro to the ribbon i cannot see any...
my above Marco works fine in Outlook 2007 but when i tried to use on 2003 i got an error on the line
Unfortunatly i don't have the error code.
does anyone have any ideas on how to fix to work in 2003 also?
In case anyone else is looking for something similar, below is what I have come up with
I used Late binding so no need to reference Word or Excel
Dim Xl As Object
Set Xl = CreateObject("Excel.Application")
Dim WD As Object
Set WD =...
Thanks for this!, i didn't even know where to start.
I've adapted so i can now paste my required text but do you know if there is way to paste into the active email without wiping out the rest of the text that is already in the email?
I'm very new to VBA, I've just started working with Excel VBA and finding it incredibly useful but this is the first time I've tried anything in outlook and I'm stuck already on something I hoped was just very small and simple...
I have an excel sheet that contains a unique number that I...