Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
mmcdowell
 
Posts: n/a
Default How to identify a list of numbers as a publisher field

I have created a ticket in Publisher. I want to mail merge tracking numbers
into it from a list of numbers in Excel. I have never used excel before. I
did my list of numbers need to know, with simple directions, how to identify
the list as a field in publisher and have publisher recognise that field.
Thanks so much for any help on this.
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default How to identify a list of numbers as a publisher field

Hi

Just put your numbers into a column - with a header. Save the file.
Open Publisher and go to Mailmerge/Open Data Source. Select 'Merge
information from another type of file' and browse to your file.
It will ask if you want to use the first row as field names - that's a Yes.
It will then probably ask for a sheet name of the book. It'll probably be
Sheet1 - unless you have renamed it.
It will then display a list of field names - well, there should only one!
Position your cursor where you want to insert your field and put it in
there!
You can then click on Mailmerge/Merge to show the results.

Hope this helps.
Andy.

"mmcdowell" wrote in message
...
I have created a ticket in Publisher. I want to mail merge tracking
numbers
into it from a list of numbers in Excel. I have never used excel before.
I
did my list of numbers need to know, with simple directions, how to
identify
the list as a field in publisher and have publisher recognise that field.
Thanks so much for any help on this.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pivot table not showing field list bobteixeira Excel Worksheet Functions 0 March 16th 06 01:46 PM
find sum in list of of numbers Jim Thomlinson New Users to Excel 3 January 4th 06 09:58 PM
Extract sub-string of number from field of long series of numbers ExcelExtrator Excel Worksheet Functions 3 December 27th 05 10:56 PM
Identify missing record numbers Earl Excel Worksheet Functions 3 November 16th 05 02:59 PM
Create a new list that singles out duplicate numbers moglione1 Excel Discussion (Misc queries) 1 August 18th 05 06:32 PM


All times are GMT +1. The time now is 04:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"