MRichmond
01-17-2012, 07:41 AM
Cant seem to see how to unsolve a thread, so I'll post again with link to original thread
http://www.vbaexpress.com/forum/showthread.php?t=40498
As stated, I thought it was working ok, but on further testing I can only seem to get issue number one to be sent (even though file name is saved correctly).
After looking it appears that the logNo which is being used to populate the form (in A1 on Issue Cust Type 1) is not changing with the record change on the user form.
If I can get that little bit to work, then I think we can call it job done.
Any idea how to get the value from txtLogno (on user form) into cell A1 on all of the Issue sheets?
http://www.vbaexpress.com/forum/showthread.php?t=40498
As stated, I thought it was working ok, but on further testing I can only seem to get issue number one to be sent (even though file name is saved correctly).
After looking it appears that the logNo which is being used to populate the form (in A1 on Issue Cust Type 1) is not changing with the record change on the user form.
If I can get that little bit to work, then I think we can call it job done.
Any idea how to get the value from txtLogno (on user form) into cell A1 on all of the Issue sheets?