Recent content by Cupid Stunt

  1. C

    Copy Cell value from Excel and paste into current email

    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. Ok so...
  2. C

    Copy Cell value from Excel and paste into current email

    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...
  3. C

    Copy Cell value from Excel and paste into current email

    Hi All, my above Marco works fine in Outlook 2007 but when i tried to use on 2003 i got an error on the line Doc.Application.Selection.TypeText Xltxt Unfortunatly i don't have the error code. does anyone have any ideas on how to fix to work in 2003 also?
  4. C

    Copy Cell value from Excel and paste into current email

    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 Sub PasteCurrentNumber() Dim Xl As Object Set Xl = CreateObject("Excel.Application") Dim WD As Object Set WD =...
  5. C

    Copy Cell value from Excel and paste into current email

    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?
  6. C

    Copy Cell value from Excel and paste into current email

    Hi, 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...
Back
Top