Results 1 to 14 of 14

Thread: Macro to insert sequential reference number into subject of email...

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #8
    VBAX Regular lamensterms's Avatar
    Joined
    Apr 2014
    Location
    Pakenham
    Posts
    16
    Location
    Hi again everyone,

    So I have the below form with code (which for some reason I cannot post).

    Which works ok. The code is still quite rough, but I do have a lot to learn.

    One of the biggest issues I am having is - during the "CommandButton1_Click" sub, the find/replace "###" with the 'tracking number' works fine... but it will fail to include the text selected from combobox3. If I type manually into combobox3, the text is included when when I hit CommandButton1, but the text is removed if it is chosen from the combobox3 pulldown. If that makes sense.

    Can any please help me figure out where I might be going wrong?
    Attached Images Attached Images

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •