Reply
 
Thread Tools Display Modes
  #1   Report Post  
wilkisa wilkisa is offline
Junior Member
 
Posts: 2
Default Mail merge hyperlink wrong results

My user has created a mail merge in Word 2010, using Excel 2010 workbook as source data. One of the many fields is called "Survey Link" and contains links to Sharepoint pages, either a DEVELOPMENT page or a PROJECT page. When the hyperlink is created in Word and the merge field is entered as Survey Link, the first 28 merged documents are correct because they all use the Development link. Document 29 and all remaining documents use the Project link but the mail merge doesn't pull those in.

We have inserted the link into every single cell in the Survey Link field of each record so I don't understand why it is pulling in the first Sharepoint link and not changing when it comes to the second link.

Does anyone have any ideas or suggestions?

Thanks for your consideration.
Shirlene
  #2   Report Post  
wilkisa wilkisa is offline
Junior Member
 
Posts: 2
Default

I figured it out because what I wrote in my thread made me start thinking differently.

My user was creating the hyperlink in Word to a field in Excel that was also hyperlinks. I removed the hyperlink in the Excel field and left it as a text field. The merged hyperlink in Word is now giving the correct results.

Although no one here helped me yet, thank you for this site. I'm sure it will be a valuable resource in the future.

Shirlene
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mail merge data results problem FERSCMem Mailmerge 1 February 24th 10 06:51 PM
Mail merge in Word, from Excel, the merge results for a percentag. Conrad Klein Microsoft Word Help 1 November 11th 09 11:00 PM
Mail merge display results barjas Mailmerge 3 July 19th 08 03:04 AM
Save results of a mail merge katmagic[_2_] New Users 1 May 3rd 08 07:38 PM
Bogus Mail Merge Results workliveplay Mailmerge 1 December 19th 06 08:49 PM


All times are GMT +1. The time now is 05:52 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"