Hi all,
As I mentioned in another thread, I'm working on a form which will be sent by email from Excel. I'm very happy with the layout of the form at the moment, and when it sends it looks great on the recipients end.
For reference, I'm using some option buttons (from the Excel Forms toolbar), some group boxes (just to make it look nice) and mainly bordered cells that the user fills in. (Sheet will be protected when I'm done). From what I can see, all the option buttons and group boxes are converted to pictures before sending. Doesn't bother me. It's just a display.
Now, I mention that the form looks great in email. It does when the user first opens the email. BUT, if they try to forward the email, Outlook creates duplicate items of the option buttons and group boxes. So what I'm left with is option buttons, sitting on top of pictures of option buttons.
I've attached the code I'm using to send the form, in case it assists with working out what is going on.
Thanks for your time, it's greatly appreciated.
-Bob
Edit: P.S. I'm happy to try sending the email form to you if it helps show what's happening. As an FYI, tests have so far been in Outlook 2003. I'm going to send it to myself at home later to see how it displays.
Bookmarks