Results 1 to 2 of 2
2003-05-14, 02:25 #1
- Join Date
- Feb 2001
- Silicon Valley, USA
- Thanked 94 Times in 90 Posts
Re: Mail merge/Excel datafile to email (Office XP)
In Outlook, it's <post#=253081>post 253081</post#>.
Is the resulting mail message in HTML format? If so, and the link still doesn't come over, you might have to generate the messages another way. Being an Office 2000 user, I've had to resort to automation (VBA) on more than one occasion. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
2003-05-14, 03:03 #2
- Join Date
- Jan 2001
- Christchurch, New Zealand
- Thanked 0 Times in 0 Posts
Mail merge/Excel datafile to email (Office XP)
<P ID="edit" class=small>(Edited by KarenWright on 14-May-03 16:03. Found the answer)</P>Hi all.
I have a mail merge main document in Word that contains email addresses, inserted using a hyperlink in Word. I have an Excel datafile that contains the details of the people to whom I wish to send this email, including their email addresses.
When I do the mail merge to email - the links that were a part of the original main document have been converted to text, instead of staying as a link.
Does anyone have any ideas at all where I should be looking? (I "thought" I'd posted this on the Outlook forum but now can't find it there, so apologies if it is listed twice.)
I have now found the answer, but thought I'd leave the post in case anyone else had the same query. Apparently it is a "bug" corrected with service release 2. However, there is a "workaround" - see microsoft knowledge base article 287004 for this.